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 DECEMBER 03, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 18.104.22.168 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***
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