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 |
Matrix Report: Simple, Group above, Nested
how to customize the report,please tell me customization steps
What are the files you have used in the part of Conversion and Interfaces?
How to print invoice from APPS(front end).if we have invoice number in hand with us???
What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
What is responsibility?
Registering parametric report?
Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen
What is Formula Column?
Define multi org structure with example(take any businees).
why do we go for oracle apps technical other than sap and other packages?