R12.0.4 only - MSCFNSCW Sourcing Rule Split Is Inaccurate When Multiple Effective Dates (Doc ID 562827.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On 12.0.4 in CRP:
Users are testing with an Unconstrained ASCP plan with sourcing rules that are split between two suppliers as follows for a specific item:

Sourcing rule name = SP1_SR for Item = TEST_ITEM1
From Date = 12-FEB-2008
To Date = 29-FEB-2008
Make At = Org = SP1 - Allocation = 70% - Rank = 1
Buy From = China supplier - Allocation = 30% - Rank = 1

Forecast Qty = 150 for item = TEST_ITEM1 due 25-FEB-2008

Run the unconstrained ASCP plan - which results in following planned orders:
Qty = 136 for Org = SP1 - % allocated = 136/150 = 90%
Qty = 14 for China Supplier - % allocated = 14/150 = 10%

This also generated an exception message:
'sourcing split percentage violated'

Important Note: Note.399468.1 Ext/Pub How To Understand The ASCP Plan Output That Does Not Respect Allocation Percentage From Sourcing Rule does not resolve this particular problem

EXPECTED BEHAVIOR

Expect the allocation for the planned orders to be 70% for Org = SP1 and 30% for the China supplier as per the sourcing rule definition

STEPS

The issue can be reproduced at will with the following steps:
1) Load item
2) Define sourcing rules with split % between make and buy and define multiple effectivities for the same sourcing rule
3) Load forecast data
4) Run data collections
5) Run ASCP unconstrained plan
6) Planned order qty does not match with sourcing rule split % in Planners Workbench

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.