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.
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 |
where to define interorganization transaction charges and what are the different options?
what is the database size you used?
what is the difference between %_all and %_f tables
How many typres of Purchase order and what are those.
How to write the no data found in XML Publiser Report in apps?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Form development process?
What is REF Cursor?
19 Answers Infosys, Intelligroup,
what are centralized and decentralized level of control of item attributes?
do you know is it possible to run the interface without using oracle apps?
what is aim methodolozy
I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.
1 Answers Genpact, Y3K Imaginations,