QP Price List report

Hi,
We’re trying to run the QP Price List report and get the following error

Error at line 70:

qllv.start_date_active desc

ORA-01427: single-row subquery returns more than one row
ORA-06512: at “SYS.DBMS_SQL”, line 1726

Any thoughts on what would cause this?

2 replies

Support Enginatics May 14, 2021
Hi,
This is likely caused by data corruption as per My Oracle Support Document included below. I can replicate the same error in the Blitz report if I introduce the corruption scenario as included in the MOS document,
Finding Item on Price List Errors with ORA-01427 : Single-row Subquery Returns More Than One Row (Doc ID 2195557.1)
Kind Regards,
Eric
Customer May 14, 2021
Hi Eric,
Thanks for the quick reply and the Doc ID. The check query does return 6 list_line_id rows. I’ll work with our BA to open an Oracle SR to get this resolved.