My Oracle Support Banner

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 AUGUST 19, 2019

Applies to:

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

Symptoms

Memory Based Planning

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
-----------------------
1. Run ASCP plan
2.Plan fails as noted


Cause

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
Symptoms
Cause
Solution


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