My Oracle Support Banner

Lease Create Update APIs - Can't Create Lease With Multiple Expense Accounts Lines (Doc ID 1544878.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms


When attempting to create a lease having a term template with multiple expense accounts on distributions,
the following error occurs.

ERROR
-----------------------
PN_LEASE_PVTRevenue/Expense Account ID NULL:ORA-01422: exact fetch returns more than one requested number of rows


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Create Lease

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create leases with APIs with term template with multiple accounts definition.

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
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.