ORA-01427 Single-Row Subquery Returns More Than One Row when running QP: Bulk Import Price List (Doc ID 865222.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
QPXVBLK QPXPRLST.fmb
***Checked for relevance on 30-OCT-2012***

Symptoms

On 12.0.6 in Production:
When attempting to query an uploaded price list
the following error occurs:

ERROR
ORA-01427 Single-row subquery returns more than one row

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create a Price List by import using QP: Bulk Import Price List
2. Query the Price List in the Form
3. Get the error, ORA-01427 Single-row subquery returns more than one row

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot query imported Price Lists.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms