Adding Exclude Items to the Modifier Errors: ORA-01427: Single-row Subquery Returns More Than One Row In Package QP_Validate_Pricing_Attr
(Doc ID 2476895.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to add a record for an item under 'Exclude" on the modifier setup form, the following error occurs.
Error: ORA-01427: ORA-01427: single-row subquery returns more than one row in Package QP_Validate_Pricing_Attr Procedure Entity
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager
2. Navigate to: Modifier > Modifier Setup
3. Query modifier
4. Place cursor on Modifier No
5. click on Exclude (button)
6. Attempt to add a record for an item
subquery returns more than one row in Package QP_Validate_Pricing_Attr Procedure Entity
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