My Oracle Support Banner

Defining Multicurrency Price List Errors: "ORA-01422: exact fetch returns more than request number of rows in package QP_LIST_HEADERS_PVT Procedure Price_List" (Doc ID 2300090.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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

Symptoms

Problem Statement
When attempting to define Multicurrency Price,
the following error occurs.

Error

ORA-01422: exact fetch returns more than request number of rows in package
QP_LIST_HEADERS_PVT Procedure Price_List

Steps to Reproduce

  1. (N)OM > Pricing > Price Lists > Price List Setup
  2. Define Price List and Enter Multi-Currency Conversion
  3. The error appears

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.