EAM:PC fields incorrectly put on PS_COST after using Acquisition Detail page in Basic Add (Doc ID 1600720.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

In release 9.1 MP11 (bundle #23), production, after running amdprept, the following error occurred:

Abend at AMDPREPT.DPRPT200.Step16 (SQL) ORA-00001 - unique constraint PS_DEPR_RPT) 

Note: Oracle Software Support (OSS) got the above error, but the customer reporting the original issue did not.  However both OSS and the customer got a row inserted to PS_COST which had the PC fields on them, but the CF_SEQNO did not increment, hence the AMDPREPT error. 



Business Impact:
Unable to populate the reporting table depr_rpt to create accurate reports.

However, if amdprept is run against the original add, it does not error.

Steps to replicate:
1. Thru Basic Add, cost 28,152.92, create a new asset with no value in the Acquisition Detail PC Category field.
2. Capitalize the asset.
3. Run am_depr_calc.
4. Run amdprept.
5. Pull up the same asset in Basic Add, Acquisition Detail, hit the plus sign. Put in an amount of $360. Click on the Interfaces info link - in the Acquisition Detail PC Category field, enter any value. Save.
6. Capitalize /Save.
7. Run am_depr_calc.
8. Run amdprept which errors.

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