1) why we need to do Validations when the Standard Conc. Prog or the API will d

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

Question Posted / divyareddy1985

2 Answers
8069 Views
Zensar, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validation..

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

1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validation..

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

Post New Answer

More Oracle Apps Technical Interview Questions

what is difference between d2k report and oracle apps report

2 Answers iFlex, TCS,

Can functions be overloaded ?

2 Answers

What is OM Cycle and What do u mean by Alternate Item

3 Answers IBM,

In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??

1 Answers

how can we get odd numbered pages in output of a report

2 Answers Infosys,

how can we return morethan one parameters in procedure?

2 Answers

what is po approval hierarchy?

1 Answers Cap Gemini,

LOCKS?

1 Answers

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.

2 Answers

can we execute one concurrent program through another concurrent program?

1 Answers KPIT,

If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers Accenture,

What and Who is the best Institute or Trainer for Oracle Apps Technical ?

2 Answers

For more Oracle Apps Technical Interview Questions Click Here