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

What is procedure?

3 Answers   IBM,


In oracle application how do you debug or trace errors?

0 Answers  


what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,


what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,


Oracle E-Business suite?

2 Answers  






in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,


what are the receipt types in Po?

2 Answers   Evosys, UST,


Can u attach Request set with in the Request set?

2 Answers   Satyam,


q)what are the validations in sql*loader

0 Answers   Accenture,


What is responsibility?

5 Answers  


Can 2 functions have same name & input parameters but differ only by return datatype ?

5 Answers  


wht is format triger?

4 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)