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 |
what are the sql attributes?
What is the Exception. Types of exception, Difference between those. And example
what is the difference between procedure and function
what is the prerequisite for defining unit of measure?
LOCKS?
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
Can u define exceptions twice in same block?
what is the need of registering table in apps?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
HOW CAN U KNOW TABLE IS REGISTERD IN APPS?
what are the different calculation columns available in reports?
what are the mandatory parameters in suppler Conversion?