IO: Loader Worker Failing With ORA-01722 Loading Data Into MSC_DEMANDS.FORECAST_MAD
(Doc ID 2098716.1)
Last updated on FEBRUARY 03, 2019
Oracle Inventory Optimization - Version 12.1.3 and later Information in this document applies to any platform.
Using Inventory Optimization / Planning engine On VCP 22.214.171.124: When attempting to run an IO plan, the loader worker handing MSLD_DEMANDS.dat fails and the following error occurs:
ERROR ----------------------- Record 47914: Rejected - Error on table MSC.DEMANDS28079, column FORECAST_MAD. ORA-01722: invalid number
-- Steps To Reproduce:
Customer states the issue can be reproduced at will at customer site with the following steps: 1. Confirm that all of the entries in the MSD_DP_SCN_ENTRIES_DENORM table have a FORECAST_ERROR = 75 AND ERROR_TYPE='MAPE' where scenario_name like 'VIS FORECAST RETAIL' 2. Run the IO plan 3. Observe that the loader worker handing MSLD_DEMANDS.dat fails with the noted 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!