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