ASCP Constrained Plan Resource Hours/Rate Calculated Incorrectly When Simultaneous Resources Being Used (Doc ID 1533422.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Users are on 12.1.3 and have applied VCP 12.1.3.3 Patch 10389190. They're using 64 bit LInux MSONWL64.exe 120.3.12010000.88 with no one offs at this time. Customer plan start date 01-FEB-2013 and they have 60 days calculating minutes bucket so this includes out to 01-APR-2013. They run EDD Constrained plan.

2 Planned orders qty = 5035 due 25-MAR-2013 and 01-APR-2013 have the following calculation which is correct:

5035 qty x 0.000641 rate = 3.227435

3.227435 x 60 minutes = 193.6461 minutes - round to 194

194 / 60 = 3.233333 - this is what I see for Planned order due 25-MAR-2013 and 01-APR-2013 which is correct and as expected

The above two planned orders did fall in the minutes bucketing since they have 60 days calculated in the minutes bucket in the Constraints tab. Plan start date was on/around 01-FEB-2013. When we add 60 calendar days that hits on/around 01-APR-2013 so hence the planned orders above get calculated correctly at 3.233333

Now the planned order (trans id = 323100747) due 08-APR-2013 is in the daily bucket so we need to figure out how to calculate the daily bucket. The resource is available 14 hours per day (Monday to Friday). but for this planned order we get resource hoursrate = 4.2 and again this is for the same planned order qty = 5035 and rate = 0.000641 as the other two planned orders. Can you tell me how it got 4.2 for the resource hours/rate in this daily bucket

MSO: Lead Time Control = Violate minimum processing lead times

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run EDD Constrained plan
2. Review minutes bucket data and calculations appear correct for minutes calculation
3. Review same item/dept/resource data for daily buckets and can't figure out how the number is calculated

Cause

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