RP-SOP Flow: Data From Rapid Planning Plan Not Populated In SOP Worksheets - ORA-01422: exact fetch returns more than requested number of rows

(Doc ID 2342317.1)

Last updated on JANUARY 15, 2018

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 Ran "Load plan scenario" method from the 'Supply review dashboard",
the following error occurs.

ERROR
-----------------------
09-11-2017 04:16:06 MSD_DEM_SOP Exception: msd_dem_sop.load_plan_data - 09-NOV-2017 04:16:06
09-11-2017 04:16:06 MSD_DEM_SOP ORA-01422: exact fetch returns more than requested number of rows



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Collaborator Workbench as sop
2. Go to 'Supply review dashboard"
3. Ran "Load plan scenario" method
It fails.



Changes

 

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