My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2019

Applies to:

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


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

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.


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

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