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
- 9728 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 are the tables in GL?
Presently u are working in which version?
What is the use of format trigger?
what is the differences between internal requisition and internal sales order?
When loading data from staging table to interface table , how to reload the invalid record once again ?
What are do's and dont's of Interface?
In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?
In report we have to show two Layout? how it is and how we can see from where it?
in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
what is the difference between procedure and function
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions
how i can create temporary table?
Oracle Apps Technical 
