in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
Answer Posted / sandeep kumar
You can acheive this by adding two columns say error_flag, error_msg and updating that column when ever that record got errored out, once it reaches 10 you can use user defined expection and restrict. or after validating all records you can check for error flags and insert the records accordingly
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to move the one file from one instance to another instance? And your scripts also?
Do you know what is applysys in oracle application database schema, what is apps?
what are the different transaction clauses in AR?
What are the different components of soa suite?
how can i print random rows in plsql table
tell me the scenarios of the independent in reports
How to create a purchase order without a requisition?
how do you describe O2C along with tables
What is a flexfield? List out its types.
q)what are the validations in sql*loader
What is instead of trigger in where we will use?
How is choreography different from orchestration?
Is soa a part of oracle fusion middleware?
What are do's and dont's of Interface?
How do you register report in oracle apps?