MSCPLD Load Worker Fails With APP-FND-01388 ORA-01722 Invalid Number For New_order_quantity (Doc ID 1532769.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3.8 version, Memory Based Planner

When attempting to run a plan, the following error occurs in the MSCPLD module: Loader Worker With Direct Load Option

ERROR
-----------------------
Request ID 830559
Record 2440: Rejected - Error on table MSC.SUPPLIES5022, column NEW_ORDER_QUANTITY.
ORA-01722: invalid number

Request ID 830560
Record 5219: Rejected - Error on table MSC.FULL_PEGGING5022, column SUPPLY_QUANTITY.
ORA-01722: invalid number

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