There are set of records to be processed from staging table
into interface table. If one record fails the entire set of
data should be rejected.
- 3 Answers
- 8114 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramesh
we can use rollback operation in exception block
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sandeep
You can also use an extra columns for tracking error flag, error message. First you can validate the records and update that particular record with the above mentioned columns.
if you don't find any errors after validation then you can load them to interface tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / raghupal
No, only the particular record is not insert the interface tables.to check for this record, this record will insert in to the bad file & discord file
| Is This Answer Correct ? | 3 Yes | 2 No |
what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
in ap_terms table what data will be stored
Tell me some errors names and number what u got while developing the reports?
Define multi org structure with example(take any businees).
what are the types of interfacing?
What is Summary columns?
Which oracle apps version you are very confident in?
where do u specify in org_id?
difference b/w procedures&functions
how to print multi lay outs,muti currency,muti language in xml publisher
Tell me some interface tables on ordermangement.
Registering parametric report?
Oracle Apps Technical 
