EAM: Depr Close Error After Lease Fair Market Value Change (Doc ID 2215886.1)

Last updated on DECEMBER 19, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

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.

Error Message
-------------------
PeopleTools 8.55.07 - Application Engine Server
Copyright (c) 1988-2016 Oracle and/or its affiliates.
All Rights Reserved


PSAESRV started service request at 19.17.12 2016-08-24


File: e:\pt85507c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723  Error Position: 0  Return: 805 - ORA-00001: unique constraint (EMDBO.PS_DIST_LN) violated
Failed SQL stmt: INSERT INTO PS_DIST_LN (BUSINESS_UNIT, ASSET_ID, BOOK, DTTM_STAMP, CF_SEQNO, ACCOUNT, ALTACCT, DISTRIBUTION_TYPE, TRANS_TYPE, ACCOUNTING_DT, IU_MAP_KEY, TRANS_IN_OUT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE, PROJECT_ID, CATEGORY, COST_TYPE, TRANS_CODE, APPL_JRNL_ID, AMOUNT, JOURNAL_ID, JOURNAL_DATE, JOURNAL_LINE, PROCESS_INSTANCE, GL_DISTRIB_STATUS, OPRID, LEDGER_GROUP, LEDGER, FISCAL_YEAR, ACCOUNTING_PERIOD, BUSINESS_UNIT_GL, PC_DISTRIB_STATUS, CURRENCY_CD, TXN_CURRENCY_CD, TXN_AMOUNT, RATE_MULT, RATE_DIV, RT_TYPE, RT_EFFDT, DOC_TYPE, DOC_SEQ_NBR, DOC_SEQ_DATE, DOC_SEQ_STATUS, ALLOC_RUN, IU_ANCHOR_FLG, IU_SYS_TRAN_CD, IU_TRAN_CD, IUT_JOURNAL_ID, TRANSFER_BU, TRANSFER_ASSET_ID, TRANSFER_BOOK, REVERSE_STATUS, REVERSE_DTTM_STAMP, BOOK_CODE, DTTM_STAMP_TRANS) SELECT DIST_LN1_TAO.BUSINESS_UNIT, DIST_LN1_TAO.ASSET_ID, DIST_LN1_TAO.BOOK, DIST_LN1_TAO.DTTM_STAMP, DIST_LN1_TAO.CF_SEQNO, DIST_LN1_TAO.ACCOUNT, DIST_LN1_TAO.ALTACCT, DIST_LN1_TAO.DISTRIBUTION_TYPE, DIST_LN1_TAO.TRANS_TYPE, DIST_LN1_TAO.ACCOUNTING_DT, 0 , DIST_LN1_TAO.TRANS_IN_OUT, DIST_LN1_TAO.DEPTID, DIST_LN1_TAO.OPERATING_UNIT, DIST_LN1_TAO.PRODUCT, DIST_LN1_TAO.FUND_CODE, DIST_LN1_TAO.CLASS_FLD, DIST_LN1_TAO.PROGRAM_CODE, DIST_LN1_TAO.BUDGET_REF, DIST_LN1_TAO.AFFILIATE, DIST_LN1_TAO.AFFILIATE_INTRA1, DIST_LN1_TAO.AFFILIATE_INTRA2, DIST_LN1_TAO.CHARTFIELD1, DIST_LN1_TAO.CHARTFIELD2, DIST_LN1_TAO.CHARTFIELD3, DIST_LN1_TAO.BUSINESS_UNIT_PC, DIST_LN1_TAO.ACTIVITY_ID, DIST_LN1_TAO.RESOURCE_TYPE, DIST_LN1_TAO.RESOURCE_CATEGORY, DIST_LN1_TAO.RESOURCE_SUB_CAT, DIST_LN1_TAO.ANALYSIS_TYPE, DIST_LN1_TAO.PROJECT_ID, DIST_LN1_TAO.CATEGORY, DIST_LN1_TAO.COST_TYPE, DIST_LN1_TAO.TRANS_CODE, DIST_LN1_TAO.APPL_JRNL_ID, DIST_LN1_TAO.AMOUNT, DIST_LN1_TAO.JOURNAL_ID, DIST_LN1_TAO.JOURNAL_DATE, 0, DIST_LN1_TAO.PROCESS_INSTANCE, DIST_LN1_TAO.GL_DISTRIB_STATUS, 'PS/AM' , DIST_LN1_TAO.LEDGER_GROUP, DIST_LN1_TAO.LEDGER, 0, 0, DIST_LN1_TAO.BUSINESS_UNIT_GL, 'N', DIST_LN1_TAO.CURRENCY_CD, DIST_LN1_TAO.TXN_CURRENCY_CD, DIST_LN1_TAO.TXN_AMOUNT, DIST_LN1_TAO.RATE_MULT, DIST_LN1_TAO.RATE_DIV, DIST_LN1_TAO.RT_TYPE, TO_DATE('2002-12-15','YYYY-MM-DD') , DIST_LN1_TAO.DOC_TYPE, DIST_LN1_TAO.DOC_SEQ_NBR, DIST_LN1_TAO.DOC_SEQ_DATE, DIST_LN1_TAO.DOC_SEQ_STATUS, 'N' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ', DIST_LN1_TAO.REVERSE_DTTM_STAMP, DIST_LN1_TAO.BOOK_CODE, CAST(SYSTIMESTAMP AS TIMESTAMP) FROM PS_DIST_LN1_TAO4 DIST_LN1_TAO WHERE PROCESS_INSTANCE = 96327 AND AMOUNT <> 0

Process 96327 ABENDED at Step AM_DPCLOSE.400090.Step30 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 19.17.17 2016-08-24

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms