EAM: AMDPREPT unique constraint error after Retirement created by Disposal Worksheet
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms