My Oracle Support Banner

EAM: Depreciation Calculation SQR (AMDPCALC) Process Fails with "ORA-00001: unique constraint" Error on PS_DEPRECIATION Record (Doc ID 2718780.1)

Last updated on JANUARY 04, 2021

Applies to:

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

Symptoms


Depreciation Calculation SQR (AMDPCALC) process fails with the following error when processing a transfer with accounting date in a different year than the transaction date


Steps to Replicate:

1. Create asset. Trans date = 7/2014, accounting date 3/2018
2. Run AM_DEPR_CALC
3. Transfer asset to another dept. Trans date = 1/2019, accounting date 1/2019.
4. Run AM_DEPR_CALC
5. Transfer asset to a 3rd dept. Trans date = 7/2019, accounting date 6/2020.
6. Run AM_DEPR_CALC.

 

Please see replication screenshots for more details.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.