EAM 8.8SP1: AMDPCALC Abended with Unique Constraint PS_AM_DEPR_01_STG Error When Saving a second BKS (Book Adjustment) Transaction with Duplicate DTTM STAMP (Doc ID 797474.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 8.8 SP1 to 8.8 SP1 [Release 8.8]
Information in this document applies to any platform.
***Checked for relevance on 05-Nov-2013***

Symptoms


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


When saving a second BKS (Book Adjustment) transaction and running the Depreciation Calculation process AM_DEPR_CALC, the following error occurs:
=========
ORA-00001: unique constraint (E881G2AP.PS_AM_DEPR_01_STG) violated Failed SQL stmt:INSERT INTO PS_AM_DEPR_01_STG.

Also, ALL Pending asset transactions which were being processed, whether they had the duplicate BKS rows or not, now have a CALC_DEPR_STAUS value of "I" (In process).

Steps to replicate:
========
Go to AM > Financial Management > Asset Book Information > Define Tax/Depre Criteria
Step 1: Change trans date to Jan 1, 2009, Accounting date to Jan 31, 2009, SAVE
Step 2:Change trans date to Jan 2, 2009, Accounting date to Jan 31, 2009, SAVE

This created duplicate"BKS" (book adjustment) transactions with the same date/time stamp, but different Trans date. Run the depreciation calculation process AM_DEPR_CALC a unique constraint error occurred:
 

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