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 |
What r the validation done in ap inbound ?
What is cursor?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
what is the error you will get if field is referenced in wrong repeating frame?
what are the default arguments for pl/sql program?
What is sca and how is it useful?
explain o2c cycle? what are the table reflected for this process?
suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?
What are the Import Programs We need to run after creating Interface table for all modules
What is a flexfield? List out its types.
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems