ORA-20006: Error(6): Msd_dem_sop.load_plan_data - ORA-20000: FAILURE: Missing T

(Doc ID 2326690.1)

Last updated on NOVEMBER 24, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, LoadData

When attempting to run 'Load plan scenario' method
the following error occurs.

ERROR
-----------------------
25-09-2017 07:14:47 MSD_DEM_SOP ORA-20006: Error(6): msd_dem_sop.load_plan_data - 25-SEP-2017 07:14:47ORA-20000: FAILURE: Missing T value in Inputs Table For Until Date

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Collaborator Workbench as sop user.
2. Go to Dashboard: Supply Review worksheet.
3. Right click on K9_PLAN plan ,
4. Go to Method
5. Run Load scenario data method.
It fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run Load scenario data method. Rapid planning data is not getting loaded into SOP .

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