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 cursor?
what is the invoice matching
Do you know what is applysys in oracle application database schema, what is apps?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
in one report using two layout models.if yes how to do
What is Place holder Columns?
Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .
What is procedure?
explain registration steps of a concurrent program.
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
Exception Handilings?