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
- 9559 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 |
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
what are the receipt types in Po?
can we use commit in trigger? If yes how?
What is instead of trigger in where we will use?
IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
What are profile options?
oracle apps architecture
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
what are the different calculation columns available in reports?
Can we customize a form with out template.fmb
can we execute one concurrent program through another concurrent program?
Oracle Apps Technical 
