ORA-01422 Exact Fetch Returns More Than Requested Number Of Rows Encountered (Doc ID 1368224.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Release Management - Version 12.1.2 and later
Information in this document applies to any platform.
Form: RLMCMWKB.FMB - CUM Workbench
***Checked for relevance on 25-Nov-2014***
***Checked for relevance on 01-Aug-2016***

Symptoms

On : 12.1.2 version, RLM Rules Issues

Customer cannot see CUM Records: Using the following navigation, see the details step by
step process:

Navigate to Release Management Workbench
OU: VCAN_OU
Ship From Org: TOR > Toronto
Customer Name: WOOBRIDGE FOAM CORPORATION
Click on Ship To: S0004-KIPLING
TP Location Code: 240585588
Customer is receiving the following error message when going into S0004-KIPLING Ship To:
Error: Unexpected error ORA-01422: exact fetch returns more than requested number of rows encountered in
rlm_shipfr_cust_items.post_query-10.

OBSERVATION
You will see at the bottom of that screen the Customer Items, as you keep clicking on the OK
button, it will change the Customer Items.
 
CUM Workbench
History: Customer stopped using RLM about a year ago because all records were going into
error, however, development made some changes to their profile options which allowed them
to start using Release Management Application.

EXPECTATION
Wants to use the following:
8214 Kipling Avenue
WOODBRIGE ON L4L2A4, CANADA

Looking at this specific customer you can see 4 addresses:
- 1 Bill To/Ship To address that are ACTIVE
- 1 Bill To/Ship To address that are INACTIVE

S0000 WFC KIPLING > TP Location Code: 240585588 > Ship To is confirmed as ACTIVE
*Want to use this
B0000-WFC KIPLING > TP Location Code: 240585588 > Bill To is confirmed as ACTIVE
*Want to use this

S0004 KIPLING > TP Location Code: 240585588 > Ship To is confirmed as INACTIVE
B0004-WOODBRIDGE > TP Location Code: 240585588 > Bill To is confirmed as INACTIVE


ERROR
ORA-01422: exact fetch returns more than requested number of rows encountered in rlm_shipfr_cust_items.post_query-10.


STEPS
1. Navigate to Release Management Workbench
OU: VCAN_OU
Ship From Org: TOR > Toronto
Customer Name: WOOBRIDGE FOAM CORPORATION
2. Click on Ship To: S0004-KIPLING
TP Location Code: 240585588
3. Customer is receiving the following error message when going into S0004-KIPLING Ship To:
Error: Unexpected error ORA-01422: exact fetch returns more than requested number of rows   encountered in rlm_shipfr_cust_items.post_query-10.
4. Observe: bottom of that screen the Customer Items > Keep clicking on the OK button, it will
change the Customer Items.
 

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