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 |
How relation will be made between modules in oracle financial?
In unix Schell sript what is very 1st line to be wriiten .
what is multi org structure?
When loading data from staging table to interface table , how to reload the invalid record once again ?
How You Will display the key flexifields in your report
we have 10 records. It's occured error in 6th record how can u find and how to rectify that?
In hierarchical structure of a database? we have write query from where we should start?
How to print invoice from APPS(front end).if we have invoice number in hand with us???
in procedure how to return a value
Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems
i have 100 pages output. i want to print 10 records per page in Template?
What is responsibility and how u attach