While importing data into interface tables,if u got number
of records are error(like more than 1000 records are
error),how to imform user?

Answers were Sorted based on User's Feedback



While importing data into interface tables,if u got number of records are error(like more than 100..

Answer / ram

I agree with above answer...but if the records are erroring
out during custom validation then we can have one exception
report and share the same with the user.

Is This Answer Correct ?    0 Yes 0 No

While importing data into interface tables,if u got number of records are error(like more than 100..

Answer / phani

For this, It is important to know how you are populating the
data in the Interface table from the flat files.

If you are using the SQL*LOADER then it will create
bad file automatically if there are some bad records
created. And same can be sent to the User/Client.

For the Better understanding about the SQL*Loader, I sugges
you go through the following link.

http://alloracletech.blogspot.com/2008/08/sql-loader-tutorial.html

Regards,
Phani

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Oracle Apps Technical Interview Questions

what is the defference between credit memo and debit memo

2 Answers  


is it possible to run the interface without using oracle apps?

0 Answers  


in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,


can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,


Can we create tables in apps schema?

0 Answers  


What are triggers?

3 Answers  


How can you achieve loose coupling in soa framework?

0 Answers  


how to debug the report?

2 Answers   IBM, Qualcomm, Sierra Atlantica,


Can you differentiate between mediator and osb?

0 Answers  


sourcing in GL

1 Answers   Convergys,


What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,


what is trace file? what is the use of that?

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)