Home » Applications » Oracle Fusion Apps & E-Business Suite » interface
interface [message #194113] Wed, 20 September 2006 17:05 Go to next message
shubha456
Messages: 5
Registered: August 2006
Location: Florida
Junior Member
1)How the data stored in staging tables are validated.
2)Where will the error records of staging tables will get stored.
3)Do we need to process the whole records and validate again and put into staging table?
4)Where will the error records of Interface tables will get stored.
Re: interface [message #194129 is a reply to message #194113] Wed, 20 September 2006 22:11 Go to previous message
saurabhsaraswat
Messages: 11
Registered: August 2006
Location: NOIDA
Junior Member
Hi,

1)How the data stored in staging tables are validated.

The data stored in staging tables are validated yhrough various procedures and user defined functions.We transfer only validated data into the interface tables.

2)Where will the error records of staging tables will get stored.

There is no table to record the staging tables error records.
they will generally remain in the staging table if the validation fails.

3)Do we need to process the whole records and validate again and put into staging table?

No, you have to process only those records which fails in validation.

4)Where will the error records of Interface tables will get stored.
The error records of interface table will remain in interface table only with some error flag set.
You can check the error reason by checking the error table for that interface or in some cases a report is genrated after running the interface so you can check that report also (eg. GL Interface).
Previous Topic: Could not see the output through ADI
Next Topic: Is Activex control require to install?
Goto Forum:
  


Current Time: Sun Dec 04 22:41:37 CST 2016

Total time taken to generate the page: 0.07206 seconds