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
Which oracle apps version you are very confident in?
What is sca and how is it useful?
What does appl_top directory contain?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Can we create tables in apps schema?
What do you understand by concurrent programs?
What is count(*) from po_vendors(any table)?
How can we import the data into a database using sql * loader?
q)what are the validations in sql*loader
can we use look up type instead of a pofile option?or valueset?is it possible how?
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.
In sequence i want to 11 and 15th values how we will write?
tell my any difficult situtation you solved in your experience in your company?
what is the differences between internal requisition and internal sales order?
In hierarchical structure of a database? we have write query from where we should start?