EAM: Depr Close Error After Lease Fair Market Value Change
(Doc ID 2215886.1)
Last updated on JULY 21, 2020
Applies to:PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.
Currently, we have several leases that were initially set up with no Fair Market Value. These leases are being updated to include the Fair Market Value. In cases where the Present Value Lease Payments are greater than the Fair Market Value, Generally Accepted Accounting Principles (GAAP) requires that the Fair Market Value be the amount capitalized in the general ledger. Asset Management should create an adjusting entry to bring the asset balance to the capitalized amount.
After updating a Lease, AM_DPCLOSE errors with Unique Constraint. It may be that AM_DPCLOSE is not accounting for the fact that multiple lines are being created in the LEASE_SCHED table and as a result is creating multiple rows for insert into PS_DIST_LN.
We have several leases that were initially set up with no Fair Market Value. These leases are being updated to include the Fair Market Value.
When this update is done, we have to go back into the lease and alter the lease payment schedule or re-calculate it from the start of the lease. If a payment has already been processed for the payment date, it flags the processed payment schedule as “X” (ignore) and then creates a reversing entry for the process payment schedule (R) and a new payment schedule (N). So, there are three lines for each payment date.
Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_DIST_LN) violated
Process 96327 ABENDED at Step AM_DPCLOSE.400090.Step30 (SQL) -- RC = 805 (108,524)
This issue can be replicated by performing the following steps:
1) Create a Leased Asset with an Annual Payment Schedule.
2) Depreciate and Create Accounting entries.
3) Create Expense Schedule for Annual Lease.
4) Close Depreciation Period.
5) Interface Lease Payments to AP and Run Voucher Build.
6) Update the Fair Market Value on the Leased Asset.
7) Calculate Depreciation and Create Accounting Entries.
8) Create Expense Schedule for Annual Lease.
9) Close Depreciation Next Period. Abend occurs.
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