EAM: AMIF1000 ABENDED at Step AMIF_FIN_PHY.210070.Step20 (SQL) -- RC 805 (108,524)
(Doc ID 958144.1)
Last updated on OCTOBER 30, 2023
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.
Symptoms
The Transaction Loader Process (AMIF1000) fails at Step AMIF_FIN_PHY.210070.Step20 (SQL) -- RC 805 (108,524) with Error "805 - ORA-00001: unique constraint" after performing InterUnit Transfer (IUT) using Mass Change.
The issue can be reproduced at will using the following replication 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) goes to No Success with the following error:
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)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |