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



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

tell me the scenarios of the independent in reports

1 Answers   Accenture, IBM,


How you will Diaplay the Company LOGO In report.Can anyone knows please give solution

8 Answers   TCS,


How to generate XML Report with out using rdf?

6 Answers   BirlaSoft, Patni, UST,


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

1 Answers   IBM,


Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

5 Answers   Deloitte, IBM,


How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,


I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,


what are centralized and decentralized level of control of item attributes?

2 Answers   Scan Steel,


What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,


what is the use of placeholer column?

3 Answers  


What is SRW Package? (Sql Report Writer)

1 Answers  


what is the difference between %_all and %_f tables

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)