My Oracle Support Banner

ELA: AMDPCLOSE Returns Unique Constraint Error If The Same Asset ID Is Associated With Both Payables And Receivable Leases (Doc ID 2833771.1)

Last updated on APRIL 04, 2025

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 

AMDPCLOSE returns Unique Constraint Error When the Same asset id is used for both the receivables and payables Leases.

The issue can be reproduced at will with the following steps:
1. Add a new Payables Lease. (Lease Administration > Create new payables lease)

2. Add a finance property.

3. Activate the Lease.

4. Asset id is generated. Take the property id of this asset.

5. Add a new Receivables Lease.

6. Select the above property id on this lease.

7. Activate the Lease.

8. Run AMDPCALC on this asset id.

9. Run AMAEDIST process.

10. Run AMDPCLOSE process.



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.