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
- 7183 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 |
wht is the use of Xml reports over reports6i?
PL/SQL stored procedure parameters?
What are triggers?
name all status attributes.
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
Oder of firing triggers in form
What are different execution methods of executabls?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
what are the different types of parameters avialable in reports?
Can u attach Request set with in the Request set?
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
Can functions be overloaded ?
Oracle Apps Technical 
