MSCPLD - Loader Worker With Direct Load Option Failed With Error ORA-01722: Invalid Number on Column NEW_ORDER_QUANTITY in Table MSC_SUPPLIES

(Doc ID 2098198.1)

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Memory Based Planning in PROD:

When running the ASCP Plan, the MSCPLD - Loader Worker With Direct Load Option program failed with error:


ERROR
-----------------------


Loader Worker With Direct Load Option request failed with error Record 408793: Rejected - Error on table MSC.SUPPLIES5021 (Note: 5021 is the plan id and the partition number for this table), column NEW_ORDER_QUANTITY.

ORA-01722: invalid number


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ASCP plan
2.Plan fails as noted


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