12.2.5 - WIP Mass Load Has Incorrect Completion Date

(Doc ID 2130651.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Both EBS and VCP instance have
VCP 12.2.5 / R12.SCP_PF.C.delta.6 patch - PLUS Mandatory Patch #2 - 22493520

PROBLEM
-------------
Select all for release fails to load WIP jobs correctly and fails with error.
Single planned order. released normally without issue.

DETAILS:
When we release the planned orders from ASCP planning workbench…. The "Suggested Due Date" is at the end of the day 23:59:00.
But the WIP Mass Load reverts the Completion Date/Time to 00:00 of the same day.
All our discrete jobs are only few hour jobs.
Since they are intra-day jobs, with Start Date later than the Completion Date, all the WIP Mass Load are completing with error.


Reproduced internally
12.2.5 - donovan-1225.us.oracle.com
Org M1
DGFG02
 |_DGCP02

Small routing
DGfset forecast

Constrained EDD plan - DGaps1a
Minute buckets for 30 days


ANALYSIS
--------------
Per customer update it appears to be an issue when using /Plan / Select all for release
-- this invokes different code path - instead of MSCPRELB.pls
we use MSC_SELECT_ALL_FOR_RELEASE_PUB MSCSARPB.pls 120.22.12020000.4


Duplicated the issue
- release 4 planned orders using Select all for release and all error.
- Then run plan again (without collections to collect the new jobs)
- then release same job as a single order and it works fine.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms