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

why do we go for oracle apps technical other than sap and other packages?

2 Answers  


how to use .prt file in bitmap reports?

2 Answers   Accenture,


WHAT IS USE OF APPS API?

3 Answers  


In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  


what is the difference between request group and request security in oracle apps?

1 Answers  






what is meant by boilerplates?

1 Answers  


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

0 Answers   IBM,


What is cursor?

3 Answers  


in procedure how to return a value

2 Answers   Wipro,


What is secuirity's in R12 features.

1 Answers   KPIT,


HOW CAN U KNOW TABLE IS REGISTERD IN APPS?

3 Answers  


about TCA architecture

1 Answers   TCS,


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)