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
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 |
In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?
In which table or database definition we can find the link of organization and operation units.
Oder of firing triggers in form
What are basic steps for AIM?
what is the difference between procedure and function
what is difference between procedure and function
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
what are the difference between oracle discoverer and report6i
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?
How many parameters we can pass through pl/sql program in Oracle apps
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
what is the standard program for blanket po to process data from interface table to bace table