EAM: Depr Close Error After Lease Fair Market Value Change
Last updated on SEPTEMBER 29, 2017
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.
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
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.
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