My Oracle Support Banner

ASCP Plan Errors When OPM Resource Planned Completion is Before Planned Start After Rescheduling (Doc ID 2452170.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Process Manufacturing Process Planning - Version 12.1.3 and later
Information in this document applies to any platform.


When rescheduling a WIP step in an OPM batch, OPM never changes the planned start date, only the planned completion date. This is as per design. This can sometimes cause the planned completion date to be changed to earlier than the planned start date. When that data is collected into ASCP and the plan is run, the plan errors out with

Record 67244: Rejected - Error on table MSC.MSC_RESOURCE_REQUIREMENTS, column DAILY_RESOURCE_HOURS.
ORA-01722: invalid number

Having just a single batch with this error causes the entire plan to fail.

Users are running an Unconstrained ASCP plan. They ran into the error in MSCPLD: Loader Worker With Direct Load Option




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.