Error :'ORA-01427: single-row subquery returns more than one row' When Doing an Advanced Search Using Certain Supplier Attributes
(Doc ID 2770476.1)
Last updated on APRIL 23, 2021
Applies to:Oracle Agile Product Cost Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
Error when querying certain attributes in Supplier object.
When doing an advanced search on Supplier for one or both of two specific attributes (say,X1 and X2), user gets the error message.
ORA-01427: single-row subquery returns more than one row
The issue can be reproduced at will with the following steps:
1. Log into Agile Web Client.
2. Advanced Search | Supplier | attributes <X1> is not null (and/or <X2> is not null)
3. Error: "ORA-01427: single-row subquery returns more than one row"
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