My Oracle Support Banner

PNGLDR : Generate Lease Detail Report Errors with ORA-01427: single-row subquery returns more than one row (Doc ID 2745242.1)

Last updated on JANUARY 22, 2021

Applies to:

Oracle Property Manager - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


Lease amended to extend the lease and payment term is extend as well.  When running the Lease Detail Report ( PNGLDR) the following error occurs

java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)



ERROR

ORA-01427

STEPS

The issue can be reproduced at will with the following steps:

Amend the lease to extend and extend the payment term as well

PN > Lease and Document > Main Lease > Enter Lease and Document

Run the Lease Detail Report.

Other > Request > Run > Generate Lease Detail Report


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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