There are set of records to be processed from staging table into interface tabl

There are set of records to be processed from staging table
into interface table. If one record fails the entire set of
data should be rejected.

Question Posted / manaswini

3 Answers
9595 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

There are set of records to be processed from staging table into interface table. If one record fai..

Answer / ramesh

we can use rollback operation in exception block

Is This Answer Correct ?

12 Yes

1 No

There are set of records to be processed from staging table into interface table. If one record fai..

Answer / sandeep

You can also use an extra columns for tracking error flag, error message. First you can validate the records and update that particular record with the above mentioned columns.

if you don't find any errors after validation then you can load them to interface tables.

Is This Answer Correct ?

3 Yes

0 No

There are set of records to be processed from staging table into interface table. If one record fai..

Answer / raghupal

No, only the particular record is not insert the interface tables.to check for this record, this record will insert in to the bad file & discord file

Is This Answer Correct ?

3 Yes

2 No

Post New Answer

More Oracle Apps Technical Interview Questions

testing tools?

0 Answers BirlaSoft, Convergys,

what is meant by boilerplates?

1 Answers

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

3 Answers Intelligroup, Satyam,

Difference between Bind and Lexical parameters?

3 Answers

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers Accenture,

Tell me where we find the status of order information?

0 Answers

explain o2c cycle? what are the table reflected for this process?

1 Answers BirlaSoft,

how to create a file in forms?

3 Answers Wipro,

What is an Index , Types od index why we are use index.

2 Answers IBM,

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

0 Answers Satyam,

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,

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers TCS,

For more Oracle Apps Technical Interview Questions Click Here