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?
- 2 Answers
- 8145 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
what are the match approvals in PO?
what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference
What is the difference between base table and multi-org table?
can we write sql statement in Format trigger?
While running the concurrent program we will get the status, we have to change the status. How it will be done.
What is Place holder Columns?
explain registration steps of a concurrent program.
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
what is the database size you used?
how can we get odd numbered pages in output of a report
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
Oracle Apps Technical 
