My Oracle Support Banner

Error When Query The Modifier/Price List ORA-01422 exact fetch returns more than requested number of rows (Doc ID 2002398.1)

Last updated on SEPTEMBER 22, 2018

Applies to:

Oracle Advanced Pricing - Version 12.2.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Modifiers Setup only

When attempting to query a modifier,
the following error occurs.

ERROR
-----------------------
An unexpected Error - 1422 has occurred. An alert has been
sent to the system administrator
ORA-01422 exact fetch returns more than requested number of
rows


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Pricing Manager

2. Modifiers/Modifier Setup

3. Query a modifier

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot query modifiers as expected.

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.