My Oracle Support Banner

MSCPLD Loader Worker With Direct Load Option Fails With ORA-01722: invalid number Error on MSC.MSC_RESOURCE_REQUIREMENTS (Doc ID 1154504.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Advanced Supply Chain Planning - Version and later
Information in this document applies to any platform.
Executable:MSCPLD - Loader Worker With Direct Load Option


Users Run an ASCP plan, however it fails in log file MSCPLD - Loader Worker with Direct Load Option with the following:

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

MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

55141 Rows successfully loaded.
1 Row not loaded due to data errors.
693 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


1.  Run ASCP Plan
2.  The Loader Worker program completes in error


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.