My Oracle Support Banner

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 MARCH 27, 2019

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

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
Changes
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.