My Oracle Support Banner

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

Last updated on JUNE 18, 2021

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

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
Symptoms
Cause
Solution
References


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