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?
- 1 Answers
- 7795 Views
- Oracle, I also Faced
- E-Mail Answers
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 |
mention the interface tables for item open interface and open transaction interface and also their respective production tables.
What is the package?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
Can anybody tell me, What is the Implementation Process?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
what are the prerequisite set ups for inter organization transaction?
In what situation u create the BPA.
what is the difference between %_all and %_f tables
How to move the one file from one instance to another instance? And your scripts also?
what is MRC? Why it is needed?
Can you have two stored functions with in the same name?
Tell me some thing about SQL-LOADER.
Oracle Apps Technical 
