Sourcing Rank 2 On Hand Supply Not Being Used While Forecast Supplied by Sourcing Rank 1 Planned Order
Last updated on MAY 25, 2018
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Planner workbench, Distribution Planning:
On Hand Supply in Sourcing Rank 2 Organization not being used while Forecast is supplied by planned order from Rank 1
On Hand Supply not being pegged with forecast
Assembly-Item-1 has a Forecast of 1 Unit for 21-DEC-2018 in Organization INST:ORGA,
the company has an on hand supply of 3 units in organization INST:ORGB.
And the supply allocated for the Forecast is Planned Order (#1234567890) from INST:ORGC
while the on hand supply in ORG-B is not used.
Pegging in Workbench
INST:ORGA - Forecast: 21-DEC-2018 - Qty: 1
|_ INST:ORGA - Planned inbound shipment 21-DEC-2018 - Qty: 1
.. |_ INST:ORGC Planned Order 14-DEC-2018 - Qty: 1
INST:ORGB On Hand 04-MAY-2018 - Qty: 3
|_ not pegged to anything
Checked sourcing rules for the organization INST:ORGA;
the Distribution Center INST:ORGB is included in the TRANSFER_ORGA sourcing rule.
The Assignment Set for the Item Assembly-Item-1 and Sourcing Rule TRANSFER_ORGA for INST:ORGA is assigned correctly.
Sourcing Rule TRANSFER_ORGA for Org INST:ORGA
Type Org Inv Rebal Rebal Rank Rank Alloc % Shipping Method Intransit Time
--- ------- -------- ------- ---- ---- ----- -----
Transfer From INST:ORGC null-null 1 100 TRUCK_T_LTL 1
Transfer From INST:ORGB null-null 2 100 TRUCK_T_LTL 1
The forecast of another item (Assembly item 2) in INST:ORGA
is being pegged with the on-hand supply in INST:ORGB as expected.
Need to know reason why the onhand supply in INST:ORGB is not being pegged normally with demand for ALL the demands like this case with Assembly-Item-1.
The expected results are the use of the Sourcing Rank 2 on hand supply in INST:ORGB, not a planned inbound shipment from INST:ORGC to INST:ORGA.
Expect Onhand from Sourcing Rank 2 Org INST:ORGB be available for use, instead of generating Planned Inbound Shipment (early build) in Rank 1 Source Org INST:ORGC
The issue can be reproduced at will with the following steps:
1. Create Sourcing
Rank 1 100% Transfer from INST:ORGC
Rank 2 100% Transfer from INST:ORGB
2. Have on-hand in Org INST:ORGB and no onhand in INST:ORGA or INST:ORGC
3. Create Forecast Demand in INST:ORGA
3. Run the DRP
4. Review the output
5. Find Planned Inbound Shipment from INST:ORGC pegged to INST:ORGA Forecast instead of Onhand in INST:ORGB
The issue has the following business impact:
Due to this issue, DRP is not using up Onhand in Rank 2 organization before creating Planned Orders and Planned Inbound Shipments from Rank 1. Plan needs to use up the onhand from alternate source organization before creating new planned orders..
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