EAM:PC fields incorrectly put on PS_COST after using Acquisition Detail page in Basic Add
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.
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.
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.
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