My Oracle Support Banner

EAM: AMFI1000 ABENDED At Step AMIF_FIN_PHY.310000.Step31 (SQL) -- RC = 805 (Doc ID 2291153.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.
*** Currency Review on 10-Jan-2019 ***

Goal

After consolidating interface rows via the online components, the customer attempted to update the consolidated row at Asset Management > Send/Receive Information > Approve Physical > Review - A. Upon submitting Load Transactions into AM (AMIF1000), the following abend occurred:

AMFI1000 Process 5270820 ABENDED at Step AMIF_FIN_PHY.310000.Step31 (SQL) -- RC = 805 (108,524 with error Cannot insert duplicate key row in object 'dbo.PS_ASSET' with unique index 'PS_ASSET'. The duplicate key value is (SDUSD, 000000232949).

 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.