in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?



in interface and conversion if 10 records are error out we can't load the records?if >10 we ..

Answer / sandeep kumar

You can acheive this by adding two columns say error_flag, error_msg and updating that column when ever that record got errored out, once it reaches 10 you can use user defined expection and restrict. or after validating all records you can check for error flags and insert the records accordingly

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

What is ERP? Architecture of apps?

3 Answers   TCS,


What do you understand by soa and what are the benefits of using this architecture?

0 Answers  


Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,


How to create a purchase order without a requisition?

0 Answers  


how i can create temporary table?

1 Answers   Zensar,


What do you understand by soa?

0 Answers  


What is procedure?

3 Answers   IBM,


What are the requests groups?

3 Answers  


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

6 Answers   Accenture,


Can u give the Documentation of Custom.pll in oracle apps

0 Answers  


what is MRC? Why it is needed?

4 Answers   Convergys,


What is REF Cursor?

19 Answers   Infosys, Intelligroup,


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)