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 MAY 01, 2017

Applies to:

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

***Checked for relevance on 02-SEP-2015***

Symptoms

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.

Table MSC.MSC_RESOURCE_REQUIREMENTS:
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.

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

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