Memory Based Planner Fails With Error In Loader Worker For Safety Stocks - Legacy Collections Setup Issue (Doc ID 2208081.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

12.1.3.9.1

PROBLEM
-------------
Loader worker fails
MSCPLD module: Loader Worker With Direct Load Option
...
Parent Program Name: MSONEW
This IS part of a Plan run.
....
Path used: Conventional
...
value used for ROWS parameter changed from 1000 to 160
Record 666: Rejected - Error on table MSC.MSC_SAFETY_STOCKS, column SAFETY_STOCK_QUANTITY.
ORA-01722: invalid number

STEPS
--------
Run plan

BUSINESS IMPACT
----------------------
cannot run this plan successfully

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