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
Tell me where we find the status of order information?
tell my any difficult situtation you solved in your experience in your company?
tell me the scenarios of the independent in reports
How can you achieve loose coupling in soa framework?
Do you know what are user profiles in apps. Any examples you can give?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How to create a purchase order without a requisition?
What is oracle soa suite and what are its different components?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What is count(*) from po_vendors(any table)?
what are the different transaction clauses in AR?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How to move the one file from one instance to another instance? And your scripts also?
Do you know where we can check the status of po?
How many schemas we have? how many you have used?