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 balancing segments in AR?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
q)what are the validations in sql*loader
in one report using two layout models.if yes how to do
How will U link GL with OU in Multi-org environment.
what are the prerequisite set ups for inter organization transaction?
what is organization id
we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?
what is the differences between internal requisition and internal sales order?
what is organization id
Tell me how to debug the report?
what is the data type of lexical parameter?