Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 9449 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?
what is the defference between credit memo and debit memo
Do you know what is applysys in oracle application database schema, what is apps?
What is profile and what is level of profile option and it's hierarchy
why we can use synonym?
What are the different components of soa suite?
1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function
What repots or concurrent program run to transfer data from Inventory to GL.
tell me the scenarios of the independent in reports
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
what are the prerequisite set ups for inter organization transaction?
how to make a parameter optional in the query?
Oracle Apps Technical 
