ASCP Unconstrained Plan Has Resource Overload Exceptions Despite Enough Resource Availability
(Doc ID 1942492.1)
Last updated on NOVEMBER 01, 2018
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 126.96.36.199.1 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 = DNA-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
EXPECTED BEHAVIOR ----------------------- Expect future dated resource requirements to spread properly in the horizontal plan when profile CRP:Spread discrete requirements = Yes
STEPS ----------------------- 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!