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 DECEMBER 10, 2024
Applies to:
Oracle Advanced Pricing - Version 12 and laterInformation 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
QP_LIST_HEADERS_PVT Procedure Price_List
Steps to Reproduce
- (N)OM > Pricing > Price Lists > Price List Setup
- Define Price List and Enter Multi-Currency Conversion
- 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 |