EAM 9.1: AM_DEPR_CALC Abended with Unique Constraint Error on PS_DEPRECIATION after BKS and ADJ (Doc ID 1501416.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

In release 9.1, bundle #23, Demo, received the following error:
Calculate Depreciation - 9.1
 
 Program Started at 11-SEP-2012_05:35:22.000000_PM
 
*----------------------------------------*
* PROCESS AMDPCALC_RQST *
*----------------------------------------*
d:\bld\g\e910\ora\e910g2ae\sqr\amdpcalc.sqr: AMDPCALC - SQL Statement =

SQL Status = 1, SQL Error = ORA-00001: unique constraint (EMDBO.PS_DEPRECIATION) violated

Error on line 71:
  (SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting.

Business Impact:
Because of this, we cannot create additional depreciation to a fully depreciated asset.

Steps to replicate:
1. Create a new profile with 2 books:
CORP has convention AM, method FL, rate 33.33333, low limit .01
Federal has convention FM, life 36, method SL
2. Go to Express add, using Profile created above. Cost and accum depreciation are equal 4,988,820.00, Trans/acctg date 12/31/2010. Expand additional info to put in acquisition date of 12/29/2005. Save.
3. Run am_depr_calc
4. Go to AM, Asset transactions, Asset book info, Define tax/depr criteria. For each book, change the In service date to 12/29/2005. Trans/acctg dates are 12/31/2010. Repeat for the federal book. Save.
5. Run am_depr_calc
6. Go to AM, Asset transactions, Asset book info, Define tax/depr criteria. For FEDERAL book, change the life to 85. Trans/acctg dates are 07/01/11. Save.
7. Run am_depr_calc
8. Go to AM, Asset Transactions, Financial transactions, Cost Adjust/transfer asset. Trans/acctg dates of 07/01/2011, action adjustment. Put in amount 51,520. Save.
9. Run am_depr_calc
10. Go to AM, Asset transactions, Asset book info, Define tax/depr criteria. For FEDERAL book, change the life to 94. Trans date 04/01/2012, acctg date is 06/01/2012. Save.
11. Run am_depr_calc
12. Go to AM, Asset Transactions, Financial transactions, Cost Adjust/transfer asset. Trans date 04/01/2012, acctg date is 06/01/2012. Action Adjustment. Cost adjust 179,200.00. Save.
13. Run am_depr_calc

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