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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which oracle apps version you are very confident in?

707


What is sca and how is it useful?

663


What does appl_top directory contain?

650


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1657


Can we create tables in apps schema?

622






What do you understand by concurrent programs?

621


What is count(*) from po_vendors(any table)?

645


How can we import the data into a database using sql * loader?

682


q)what are the validations in sql*loader

1746


can we use look up type instead of a pofile option?or valueset?is it possible how?

1788


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.

2470


In sequence i want to 11 and 15th values how we will write?

1574


tell my any difficult situtation you solved in your experience in your company?

1869


what is the differences between internal requisition and internal sales order?

2162


In hierarchical structure of a database? we have write query from where we should start?

1708