Oracle Business Intelligence Applications (Oracle BI Apps) OOTB Integration_id

w_sales_order_line_f.integration_id  = oe_order_lines_all.line_id

w_sales_invoice_line_f.integration_id  = RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID

w_product_d.integration_id = MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID

w_product_lot_xact_f.integration_id = MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID~MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER

w_product_xact_f.integration_id =  MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID~MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER

SIL_ARTransactionFact
w_ar_xact_f.integration_id = w_ar_xact_fs.integration_id 
SDE_ORA_ARTransactionFact_ReceivableApplication
w_ar_xact_fs.integration_id = 
IIF(
ISNULL(SQ_AR_XACTS_APPREC.ORIGINAL_LINE_ID) OR SQ_AR_XACTS_APPREC.UPG_FLG = 'Y',
'R'||'~'||
TO_CHAR(SQ_AR_XACTS_APPREC.LINE_ID),
'R~RECEIPTREVERSE~'||
TO_CHAR(SQ_AR_XACTS_APPREC.LINE_ID)||'~'||
TO_CHAR(SQ_AR_XACTS_APPREC.ORIGINAL_LINE_ID)
)

SQ_AR_XACTS_APPREC.LINE_ID = AR_DISTRIBUTIONS_ALL.LINE_ID

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