New ETL content in Supply Chain Management after the upgrade from 11.1.1.10.1 to 11.1.1.10.2 is listed in this topic.
Changes after the Upgrade
Tables truncated and reloaded:
NA
Tables with records updated / populated:
W_PRODUCT_LOT_XACT_FS.batch_number
W_PRODUCT_XACT_A.LOC_MATERIAL_AMT
Tables with data model changes:
NA
Metrics calculated differently (metadata repository calculation-wise) or added newly:
NA
New features introduced:
NA
Issues and bug fixes covered:
BUG 21802966 - Qty are doubled in Material Usage Variance by Product Report
Apply max function on the transaction_id column of MTL_MATERIAL_TRANSACTIONS table
BUG 22090483 - RFA: Not able to populate batch_number in W_PRODUCT_XACT_F table.
Batch_number column is not mapped in base table w_product_lot_xact_fs etl and so it’s not getting carried in subsequent etls.
Bug 21338791 - RFA: LOC_EXCHANGE_RATE null in W_PRODUCT_LOT_XACT_FS
LOC_EXCHANGE_RATE attribute was not mapped in the interface - SDE_ORA_ProductLotTransactionFact_Process.W_PRODUCT_LOT_XACT_FS.
Bug 22023753 - Issue in Multiple WIP "Issue" Transaction
Apply max function on the Last_update_date column of MTL_MATERIAL_TRANSACTIONS table