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
- 8729 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 |
why r u move in the cus_top only why not move another top
where is setup of business group done?
WHAT IS USE OF APPS API?
is UOM maintained at master level or organization level or both?
Challenges faced during upgradation of 11i to R12
how to customize the report,please tell me customization steps
How can you achieve loose coupling in soa framework?
what is trace file? what is the use of that?
what is the use of placeholer column?
Which one Module is Biggest Module in oracle apps?
What are the different components of soa suite?
explain o2c cycle? what are the table reflected for this process?
Oracle Apps Technical 
