Oracle Business Intelligence Application OOTB ETL Architecture

Oracle Business Intelligence Application OOTB ETL Architecture:
Oracle Business Intelligence Application (BI APPS) Out of the Box (OOTB)  ETL Architecture:

W_INVENTORY_MONTHLY_BAL_F

W_INVENTORY_DAILY_BAL_F(SDE_ORA_InventoryDailyBalanceFact)

W_ORA_INVENTORY_BAL_FS_TMP (SDE_ORA_InventoryBalanceFact_Temporary)

Mtl_onhand_quantities_detail

w_product_d

mtl_system_items_b   

w_ora_product_ds_tmp

Session Name: SDE_ORA_ProductDimension_Derive

w_product_ds

Session Name: SDE_ORA_ProductDimension  

w_product_d

w_inventory_product_d

w_ora_invprod_ds_tmp

Session Name: SDE_ORA_InventoryProductDimension_Derive

w_inventory_product_ds

Session Name: SDE_ORA_InventoryProductDimension

w_inventory_product_d

Session Name: SIL_InventoryProductDimension

W_PRODUCT_XACT_F

Source EBS Table:  MTL_MATERIAL_TRANSACTIONS

W_PRODUCT_LOT_XACT_FS

Session Name: SDE_ORA_ProductLotTransactionFact_Process

Session Name: SDE_ORA_ProductLotTransactionFact_Discrete

2.    W_PRODUCT_LOT_XACT_F

Session Name: SIL_ProductLotTransactionFact

3     W_PRODUCT_XACT_F

       Session Name: SIL_ProductTransactionFact

W_AP_BALANCE_F

1.       W_AP_XACT_F (PLP_APINCREMENTALACTIVITYLOAD)

2.       
          W_AP_BALANCE_F_TMP

3.       W_AP_BALANCE_F