Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 9561 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramesh
we can use rollback operation in exception block
| Is This Answer Correct ? | 12 Yes | 1 No |
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 |
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 |
What is the concept of soa governance?
How do u customize the Reports?
why r u transer the data base tables to flat file and what is use
while running a interface if we get 100 records as erors. how to debug it.
What repots or concurrent program run to transfer data from Inventory to GL.
Name the different Cursor Attributes.
What are file in oracle.
what is difference between API and Interface?
how many layout sections are tehre in layout editor?
What are the requests groups?
Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?
Tell me some thing about SQL-LOADER.
Oracle Apps Technical 
