Supply Chain Management

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

  1. Tables truncated and reloaded:

    NA

  2. Tables with records updated / populated:

    • W_PRODUCT_LOT_XACT_FS.batch_number

    • W_PRODUCT_XACT_A.LOC_MATERIAL_AMT

  3. Tables with data model changes:

    NA

  4. Metrics calculated differently (metadata repository calculation-wise) or added newly:

    NA

  5. New features introduced:

    NA

  6. 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