Answer / ramesh peddi

simple while writing code select the error records also in
main cursor so u can run program again

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.

Answer / guest

Discarded record will display in out put of loader program
copy the files and load them agin

Answer / manaswinig

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.

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!!

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. 

What are do's and dont's of Interface?

0 Answers  

Explain the multi-organization structure.

1 Answers   Accenture,

explain o2c cycle? what are the table reflected for this process?

1 Answers   BirlaSoft,

how i can create temporary table?

1 Answers   Zensar,

any one can expalin report registration steps?

6 Answers   Infosys,

how to customize the report,please tell me customization steps

5 Answers   Accenture,

wht r the basetables of customer interface?

2 Answers  

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

what is the difference between request group and request security group in oracle apps?

2 Answers   BirlaSoft,

Where I can download D2K software?

2 Answers  

tell me the scenarios of between pages in reports

1 Answers   TCS, Wipro,

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,