My Oracle Support Banner

Legacy Collections Errors in MSCSLD - Loader Worker With ORA-01858 On Table MSC.MSC_ST_SALES_ORDERS For All Sales Order Records (Doc ID 2470634.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

On : 12.1.3 version, Data Collections in Test

Users are on 12.1.3 and have just recently applied 12.1.3.9.2 patch 22706126. Users are using Legacy Data Collections and they are trying to load the MSC_ST_SALES_ORDERS.dat which is the sales order data file. However it errors in MSCSLD: Loader Worker with the following:

ERROR
======
Record 1: Rejected - Error on table MSC.MSC_ST_SALES_ORDERS, column REVISED_DMD_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected

Record 2: Rejected - Error on table MSC.MSC_ST_SALES_ORDERS, column REVISED_DMD_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected

Record 3: Rejected - Error on table MSC.MSC_ST_SALES_ORDERS, column REVISED_DMD_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected

Record 4: Rejected - Error on table MSC.MSC_ST_SALES_ORDERS, column REVISED_DMD_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected

This kept erroring out until all 7500 records errored with the same error. How is this resolved?
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.