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

Oracle Business Intelligence OPatch failed with error code 73

Problem:
If you see below error while applying Opatch:

OPatch detects the Middleware Home as "/opt/OBI_Home/Middleware" 

OPatchSession cannot load inventory for the given Oracle Home /opt/OBI_Home/Middleware/Oracle_BI1. Possible causes are: 
No read or write permission to ORACLE_HOME/.patch_storage 
Central Inventory is locked by another OUI instance 
No read permission to Central Inventory 
The lock file exists in ORACLE_HOME/.patch_storage 
The Oracle Home does not exist in Central Inventory 

UtilSession failed: Lock file left by a different patch, OPatch will not try re-using the lock file. 
Log file location: /opt/OBI_Home/Middleware/Oracle_BI1/cfgtoollogs/opatch/opatch2017-01-14_13-15-31PM_1.log 

OPatch failed with error code 73 

Solution:

Backup and remove 

<Middleware Home>/Oracle_BI1/.patch_storage/patch_locked folder.