1) why we need to do Validations when the Standard Conc.
Prog or the API will do all the validations
2) How can we display more then 1 column data in a formula
column (Ex displaying Empno, Ename, sal data in one Formula
column)
3) is it possible to give 2 out paramaters in a function
Answers were Sorted based on User's Feedback
Answer / amarnath reddy govind
1) For Business validations or we need to validate data
before inserting data in to interface tables.
2) We can display more than one column data in formula by
taking one placeholder column. By using the formula column
always returns value right, so based on the formula column
we can display the data for placeholder column.
3)
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / emmanuel
1) Std. C/P will not take care the Business and custom
Validations. So, we need do validations before inserting in
to Interface table.
2) As formula column is function. we can display only one
string. with concatenate we can display more that one
column data. But this will treat it as string.
3) Yes, with one return value, we can give OUT parameters
also
| Is This Answer Correct ? | 5 Yes | 1 No |
Is it possible to do purchase order without requisition?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
How to move the one file from one instance to another instance? And your scripts also?
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
what are the receipt types in Po?
What is the maximum number of statements that can be specified in a trigger statement?
what are the sql attributes?
can we get profile values in report without using user exists is it possible how?
how can we return morethan one parameters in procedure?
How many standard interface programs in oracle purchasing module and oracle inventory? What are they?
What are the requests groups?