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 JANUARY 21, 2022

Applies to:

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



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.


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

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