Subinventory Details Not Updated In Supply Table (MTL_SUPPLY) When Updating PO Distribution If Linked To Advance Shipment Notice (ASN)

(Doc ID 2353752.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Subinventory is not updated in the supply table (MTL_SUPPLY) when populated at Purchase Order (PO) distribution level if the PO is linked to an advance shipment notice (ASN).

WHAT IS WORKING
If no ASN is linked to the PO, then issue does not occur.

Three cases
There are 3 cases as follows:
1. Update the subinventory details at PO distribution level where in PO does not have ASN linked to it. In this case subinventory detail from PO distribution level is getting updated in the column 'to_subinventory' in the table MTL_SUPPLY.
2. Update the subinventory details at PO distribution level where in PO has a ASN linked to it. In this case subinventory detail from PO distribution level is not updated in the column 'to_subinventory' in the table MTL_SUPPLY.
3. PO has an ASN linked to it. Update the subinventory details at PO distribution level for the PO line which is there in ASN. In this case subinventory detail from PO distribution level is not updated in the column 'to_subinventory' in the table MTL_SUPPLY. Now add a new item to the PO and this item is not there in the ASN.....when subinventory details updated at PO distribution level for this newly added PO line which is not there in ASN, subinventory detail from PO distribution level is getting updated in the column 'to_subinventory' in the table MTL_SUPPLY.

Observations
A. When the 'supply_type_code' is 'PO' in mtl_supply table, then column 'to_subinventory' details is getting updated with subinventory detail from po_distribution level
B. When the 'supply_type_code' is 'SHIPMENT' in mtl_supply table, then column 'to_subinventory' details is not getting updated with subinventory detail from po_distribution level

STEPS
1. Create and receive material on an advanced shipment notice (ASN).
2. Review subinventory -- Missing on supply table.

BUSINESS IMPACT
This issue has a big impact since they want to restrict some supplies in Material Resource Planning (MRP) by updating the non-nettable subinventory at PO distribution level after ASN creation but same is not getting updated in MTL_supply and thus such lines are still considered as supply in MRP.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms