My Oracle Support Banner

ELA: The Close Depreciation (AM_DPCLOSE) Process Abends at Step AM_DPCLOSE.500150.Step10C With “ORA00001: Unique Constraint (PS_LEASE_DIST1_TMP) Violated” if a Lease Asset Is Associated With Both a Payables and a Receivable Lease (Doc ID 2918946.1)

Last updated on JANUARY 03, 2023

Applies to:

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

Symptoms

The Close Depreciation (AM_DPCLOSE) process fails with the following error if a Lease Asset is associated with Both a Payables and a Receivable Lease

*The error can be found on the Process Monitor > Message Log or in the AM_DPCLOSE .AET Trace File

The issue can be reproduced at will with the following steps:
1. Add a new Payables Lease.
Navigation: Lease Administration > Payables Leases > Create New Payables Lease
2. Add/Select a finance property and activate the Lease.
3. Add a new Receivable Lease.
Navigation: Lease Administration > Receivables Leases > Create New Receivables Lease
4. Select the same property id on and activate the Lease.
5. Calculate the Depreciation
Navigation: Asset Management > Depreciation > Processing > Calculate Depreciation
6. Create the Accounting Entries
Navigation: Asset Management > Accounting Entries > Create Accounting Entries
6. Run the Close Depreciation Process AM_DPCLOSE.
Navigation: Asset Management > Accounting Entries > Close Depreciation
7. Review the AM_DPCLOSE Process Monitor > Message Log and/or the .AET Trace File


Detailed DEMO Replication Steps attached.

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.