AMDPREPT Error: Process 5993 ABENDED at Step AMDPREPT.DPRPT200.Step16 (SQL) -- RC = 805 (108,524) (Doc ID 662767.1)

Last updated on MARCH 09, 2017

Applies to:

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

This document was previously published as Customer Connection Solution 201071243



***Checked for relevance on 24-May-2011***
***Checked for relevance on 18-Feb-2013***
***Checked for relevance on 01-OCT-2015***
***Checked for relevance on 09-MAR-2017***





Symptoms


PeopleSoft Asset Management Information Center > Listing of AMDPREPT Error Messages and Troubleshooting Tips to Resolve Each Error > Note 662767.1

The AMDPREPT process is abending with a unique constraint on PS_DEPR_RPT after an Add, and Adjusting the Accumulated Depreciation twice, running AM_DEPR_CALC, and running the Load Depr Reporting Table process AMDPREPT for 2008 with the Process Current Activity option unchecked.

Also, here is another scenario which created the same error:

This scenario is data related.  There was an ADD row in Deptid A. The asset was retired in Deptid B, but the CF_SEQNO value of the RET row was 0, which is the same for the ADD.

If the error is caused by data, then the fixes mentioned below will not help.  You must use SQL to fix the CF_SEQNO.  That is, all rows with the same set of chartfields should have the same CF_SEQNO.

 

 

Here was the error for the 1st scenario:

File: e:\pt84908c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1603 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_DEPR_RPT) violated
Failed SQL stmt:INSERT INTO PS_DEPR_RPT (BUSINESS_UNIT, ASSET_ID, BOOK, FISCAL_YEAR, ACCOUNTING_PERIOD, CF_SEQNO, GROUP_ASSET_FLAG, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, PROJECT_ID, DEPTID, CATEGORY, COST_TYPE, ACTIVITY_SW, RETIRE_SW, DEPR, DEPR_YTD, DEPR_LTD, CURRENCY_CD, MANUAL_DEPR_TYPE, SPEC_DEPR, INITIAL_DEPR, ACCEL_DEPR, INCREASE_DEPR, STANDARD_DEPR, COST, SALVAGE_VALUE, GRP_COST, GRP_SALVAGE_VALUE, ACCUM_DEPR_ADD, ACCUM_DEPR_TRF, ACCUM_DEPR_RCT, ACCUM_DEPR_REI, ACCUM_DEPR_RET, COST_ADD, COST_ADJ, COST_TRF, COST_RCT, COST_REI, COST_RET, DEPR_PDP, ACCOUNT_AD, ACCOUNT_FA, LOCATION
Process 5993 ABENDED at Step AMDPREPT.DPRPT200.Step16 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 17.05.57 2008-06-26

 

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