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
- 6677 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 |
How many typres of Purchase order and what are those.
Can you define an erp system?
what u did after ur btech(2009) till now? why did u prefer oracle apps technical?
why do we validate the records while developing interface?
what is meant by boilerplates?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
What is cursor?
Difference between triggers and procedures?
in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
what are the different types of parameters avialable in reports?
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
is UOM maintained at master level or organization level or both?
Oracle Apps Technical 
