EAM: AMDPREPT unique constraint error after Retirement created by Disposal Worksheet (Doc ID 1452506.1)

Last updated on OCTOBER 27, 2016

Applies to:

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

Symptoms

In release 9.1 Bundle #19, test, after running AMDPREPT, we are getting the following error:
ORA-00001: unique constraint = (SYSADM.PS_DEPR_RPT)
...
ABENDED at Step AMDPREPT.DPRPT200.Step16 (SQL) -- RC =3D = 805 (108,524)

Business Impact:
Because of this, we cannot populate depr_rpt, nor run any AM reports which read off of this table.

Steps to replicate:
1. Add an asset.
2. Recategorize the asset.
3. Retire the asset via Disposal Worksheet.
4. Run AMDPCALC.
5. Run AMDPREPT.

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