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 126.96.36.199 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