EAM: AMDPREPT unique constraint error after Retirement created by Disposal Worksheet
(Doc ID 1452506.1)
Last updated on NOVEMBER 18, 2020
Applies to:PeopleSoft Enterprise FIN Asset Management - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
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)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!