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 |
What is procedure?
In oracle application how do you debug or trace errors?
what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference
what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?
Oracle E-Business suite?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
what are the receipt types in Po?
Can u attach Request set with in the Request set?
q)what are the validations in sql*loader
What is responsibility?
Can 2 functions have same name & input parameters but differ only by return datatype ?
wht is format triger?