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 |
Tell me where we find the status of order information?
Define MultiOrg Structure
What are different execution methods of executabls?
What is multi org?
in which table sub inventory related information for item is stored?
3 Answers chain sys, Scan Steel,
Do you know where we can check the status of po?
can we write sql statement in Format trigger?
How many typres of Purchase order and what are those.
What are the validations you don in .CTL file in inbound interface process?
how to customize the report,please tell me customization steps
You are working with interfaces if client doesnot give any flat then what will u do?
what is pl/sql table and pl/sql records? what is the use of that?