My Oracle Support Banner

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.

Symptoms

When attempting to add a record for an item under 'Exclude" on the modifier setup form, the following error occurs.

ERROR
Error: ORA-01427: ORA-01427: single-row subquery returns more than one row in Package QP_Validate_Pricing_Attr Procedure Entity


STEPS
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

Error: ORA-01427: ORA-01427: single-row
subquery returns more than one row in Package QP_Validate_Pricing_Attr Procedure Entity





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.