AMIF1000 ABEND AT AMIF_FIN_PHY 310020 STEP20- UNIQUE CONSTRAINT PS_ASSET_ACQ_DET (Doc ID 2036996.1)

Last updated on JANUARY 03, 2017

Applies to:

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

Symptoms

In release 9.0 bundle #46, after running PC_AM (which calls AMIF1000), the following error occurred:

09.31.14 Process 2263481 ABENDED at Step AMIF_FIN_PHY.310020.Step20 (Action SQL) -- RC = 805
ROLLBACK
/
-- 09.31.14 SQL Error: ORA-00001: unique constraint (SYSADM.PS_ASSET_ACQ_DET) violated

This is a regression from Bug# 17623504 - EAM:INCORRECT DEPRECIATION FOR MULTIPLE ADD ROWS FROM PC

Steps to replicate:
1. Add transaction in to proj resource with some data will be consolidated and some will not get consoliated
2. Assign this project a an asset
3. Run PC_AM
4. Run AMIF1000 - it will abend

 

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