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 |
which parameters passed in report in oracle developer how to pass
Explain oracle apps architecture.
what is mutating table and mutating error and how to solve that?
wheather discard file is automatically created or explicty created?can u mention it?
Steps for DFF registration
What is the package?
what is the use of format trigger?a
what are the mandatory parameters in suppler Conversion?
in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
is it possible to run the interface without using oracle apps?
what is inbound and outbound interface?
Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen