My Oracle Support Banner

ASCP Unconstrained Plan Has Resource Overload Exceptions Despite Enough Resource Availability (Doc ID 1942492.1)

Last updated on AUGUST 19, 2019

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, Memory Based Planner in Test:

Users are on 12.1.3 and have applied VCP Patch 17350769 with no MBP one offs - they have 64 bit Linux MSONWL64.ppc 120.3.12010000.355

MRP:Cutoff Date Offset Months = 18 - from OWC They also had Calculate resource requirements enabled in the Constraints tab - also unconstrained plan from OWC review

The problem in the unconstrained plan was the fact that resource requirements would all be lumped on one day in the future instead of spreading over the period for which they would be used. Discussion with development stated we needed to set ASCP profile CRP:Spread discrete requirements = Yes and rerun the plan.

However while that seemed to work for some planned order, other planned orders for the same item in the same time frame do not appear to take it into account

2. Screenshots of the routing for item = 740*515168 - It has only 1 operation seq which has two resource seq

Seq = 10 Res = 7XX_CTP Assign Unit = 1 Schedule = Yes Offset % = 0
Seq = 20 Res = QUEUE Assign Unit = 1 Schedule = Yes Offset % = 2.702702

Org DN1:US2
5 on 2 off calendar
Res = 7XX_CTP
Dept = 7XX_DEPT
Shift 1 only 09:00 to 17:00
Cap Units = 13 - 13x8 = 104

For the item - source setup in the routing
Res Seq 10 - Res = 7XX_CTP - Basis = Item - Rate 4 / 0.25 so 4 hours per item
Res Seq 20 - Res = QUEUE - Basis = Lot - Rate = 48 / 0.020833 so 48 hours Fix LT

Both are schedule flag = Y
Fixed LT = 6 (48/8) 08-JUL
Var LT = 0.5 (4/8) These are correct based on 1 shift 8 hours per day 07-JUL

Example data from the data files with the profile = Yes

Plan id = 7998
Plan Name = Firm
org id = 137
Org code = DN1:US2
Res Id = 54
Res Code = 7XX_CTP
Dept Id = 6
Dept Code = 7XX_DEPT

There's planned order
Start Date = 15-JUL-2014
End Date = 04-SEP-2014
For this planned order resource requirements are spread in horizontal plan as expected for 300 hours

Next planned order with start date = 05-AUG-2014 and end date 05-AUG-2014 208 hours is not spread. There's another planned order for 44 hours with same start and end date as well that did not spread. Seems like 1st planned order for resource spreads but subsequent of if they cross over dates, they don't spread

Expect future dated resource requirements to spread properly in the horizontal plan when profile CRP:Spread discrete requirements = Yes

The issue can be reproduced at will with the following steps:
1. Run unconstrained plan with CRP:Spread discrete requirements = No - there is no spreading of resource requirements on planned orders
2. Run unconstrained plan with CRP:Spread discrete requirements = Yes - there is some spreading of resource requirements on planned orders




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.