EAM: AMIF1000 ABENDED at Step AMIF_FIN_PHY.210070.Step20 (SQL) -- RC 805 (108,524) (Doc ID 958144.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
Checked for relevance on 25-FEB-2013
***Checked for Relevance 16-June-24***

Symptoms


PeopleSoft Asset Management Information Center > Listing of AMIF1000 Error Messages and Troubleshooting Tips to Resolve Each Error > Note 958144.1


STEPS:
----------
1) An InterUnit Transfer (IUT) mass change is created to transfer assets from one Business Unit to another Business Unit.
2) The mass change is executed.
3) Then the transaction loader process AMIF1000 runs and goes to No Success.

ERROR:
----------
AMIF1000_No_Success.mht error message:
Return: 805 - ORA-00001: unique constraint =
(SYSADM.PS_BOOK) violated=20
Failed SQL stmt:INSERT INTO PS_BOOK (BUSINESS_UNIT, ASSET_ID, BOOK,

Process 1967040 ABENDED at Step AMIF_FIN_PHY.210070.Step20 (SQL) -- RC  805 (108,524)


 

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