My Oracle Support Banner

MSCFNSCW Sourcing Rule Split Is Inaccurate When Multiple Effective Dates (Doc ID 562827.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.4 and later
Information in this document applies to any platform.
FORM:MSCFNSCW.FMB - Planner Workbench


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


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


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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