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 / 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 |
What is the difference between base table and multi-org table?
I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.
why do we validate the records while developing interface?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
testing tools?
0 Answers BirlaSoft, Convergys,
tell me the scenarios of between pages in reports
how to initialize applications?
what is the data type of lexical parameter?
what is lexical parameter?
What is set function in sql .E.g.What is difference between union and union all
when we run payment batch what are the 3 concurrent programs?
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions