ELA: When Searching In Payable Transactions Page, Single-row Subquery Returns More Than 1 Row

(Doc ID 2411872.1)

Last updated on JUNE 15, 2018

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When Doing a Search in Payable Transactions Page, Error Occurs: ORA-01427: Single-row Subquery Returns More Than One Row. This occurs after applying PUM 26.
We have reviewed similar doc id: ORA-01427: Single-row Subquery Returns More Than One Row. (2,294) (Doc ID 2161664.1), however we already have this bug fix applied as part of PM 26.

Error
-------------------------
ORA-01427: Single-row Subquery Returns More Than One Row

Steps
--------

1) After creating the lease, navigating to Lease Administration > Payables Leases > Processing Payments:
2) Select BUSINESS UNIT
3) Select Lease Number
4) Click Search: Receive: ORA-01427: Single-row Subquery Returns More Than One Row


Business Impact
-----------------------
We cannot move forward with Lease Admin implementation as we are unable to process payments for lease.

Changes

 

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