Interested to Buy Any Domain ? << Click Here >> for more details...
When loading data from staging table to interface table ,
how to reload the invalid record once again ?
- 6 Answers
- 18554 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
simple while writing code select the error records also in
main cursor so u can run program again
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / santosh kumar
For validation failed records or error records need to be corrected according to the level of failure and these records can updated with particular status flag (in staging table). And next time validation program has to run only for those records.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / guest
Discarded record will display in out put of loader program
copy the files and load them agin
| Is This Answer Correct ? | 8 Yes | 4 No |
First to correct the errors may be data errors or Transformation rule errors. Usually any interface table will have batch id. Give a different batch Id and reload the error records after correcting them.
As such we can reload only the error data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / arun n
Normally it should not load data for the second time.
If the data is not loaded properly, then we need to handle in our custom program for re-processing.
Hope it is clear!!
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / naresh bandla
All the Error record's are stored in Interface Error Tables.
Correct the Error record's and Load this to staging tables and load this from staging to Interface Tables.
| Is This Answer Correct ? | 1 Yes | 3 No |
hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.
what is the use of format trigger?a
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 less then it must shows some error how we willmake
what do you mean by value sets
can we get profile values in report without using user exists is it possible how?
How do you register report in oracle apps?
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
can we use commit in trigger? If yes how?
How do u identity its name of report?
how to call report from oracle oracle apps11i?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
is it possible to run the interface without using oracle apps?
Oracle Apps Technical 
