MSCPLD Loader Worker With Direct Load Option Fails With ORA-01722: invalid number Error on MSC.MSC_RESOURCE_REQUIREMENTS
Last updated on MAY 01, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 188.8.131.52 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:
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
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