Home » Applications » Oracle Fusion Apps & E-Business Suite » Stage table
Stage table [message #211059] Tue, 26 December 2006 00:29 Go to next message
Messages: 25
Registered: September 2006
Junior Member
what is exact Purpose of stage table? without stage table I Insert data into apps tables by using plsql Procedure what happened.
Re: Stage table [message #213676 is a reply to message #211059] Thu, 11 January 2007 16:54 Go to previous messageGo to next message
Messages: 180
Registered: July 2005
Senior Member
You can insert directly in interface table (even without using temporary tables) but you should not insert into base tables. You may corrupt data and Oracle will not support you.
Re: Stage table [message #213705 is a reply to message #211059] Thu, 11 January 2007 23:56 Go to previous message
Messages: 153
Registered: July 2006
Location: -
Senior Member

Basically stage tables are used in conversion and/or migration.

These tables are used to collect data and validate data .

1) It is always a good practice to validate the data before you populate the oracle interface table..since one can minimize the errors in the interface table when an standard oracle program is run.

2) Also data collected may not contain all the necessary id's and data used for the oracle interface table. So one could generate them in the stage table.

3) There is no harm in directly populating the base table if the interface table is not available.One needs to be careful while doing so, since chances of oracle populating more than one table are possible.

The flow of data is as follows

Data source --> Stage table --> Oracle Interface table-->Oracle Base table

Previous Topic: Report Problem
Next Topic: view log problem
Goto Forum:

Current Time: Tue Aug 22 04:22:45 CDT 2017

Total time taken to generate the page: 0.24157 seconds