When loading data from staging table to interface table ,
how to reload the invalid record once again ?

Answers were Sorted based on User's Feedback



When loading data from staging table to interface table , how to reload the invalid record once ag..

Answer / ramesh peddi

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

When loading data from staging table to interface table , how to reload the invalid record once ag..

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

When loading data from staging table to interface table , how to reload the invalid record once ag..

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

When loading data from staging table to interface table , how to reload the invalid record once ag..

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.

Is This Answer Correct ?    0 Yes 0 No

When loading data from staging table to interface table , how to reload the invalid record once ag..

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

When loading data from staging table to interface table , how to reload the invalid record once ag..

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

Post New Answer

More Oracle Apps Technical Interview Questions

which parameters passed in report in oracle developer how to pass

3 Answers  


what is lexical parameter?

3 Answers   TCS,


How You Will display the key flexifields in your report

3 Answers   TCS,


how will u do documentation

2 Answers  


I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,


When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers   Accenture,


when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,


what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,


hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me

2 Answers   Pathway Technologies,


What are file in oracle.

0 Answers   BirlaSoft, IBM,


What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,


WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)