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
8259 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

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

0 Answers KPIT,

Give a brief overview on OrderManagement.

1 Answers Zensar,

what is inbound and outbound interface?

2 Answers

What are file in oracle.

0 Answers BirlaSoft, IBM,

What is oracle soa suite and what are its different components?

0 Answers

What do you understand by soa and what are the benefits of using this architecture?

0 Answers

Is it possible calling from one report to another? if possible means tell me ?