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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you define an erp system?

889


What are the benefits of using soa architecture?

928


What are the different components of soa suite?

945


What is count(*) from po_vendors(any table)?

837


do you know is it possible to run the interface without using oracle apps?

889


How do you register report in oracle apps?

879


what is the difference between request group and request security in oracle apps?

5461


What do you understand by a set of books?

846


In hierarchical structure of a database? we have write query from where we should start?

1942


List the types of flexfield?

805


where to define interorganization transaction charges and what are the different options?

2170


What is a flexfield? List out its types.

909


how to print multi lay outs,muti currency,muti language in xml publisher

11532


testing tools?

1973


What are the different components you should consider while defining a responsibility in oracle apps?

857