My Oracle Support Banner

EAM:AMIF1000 ABEND AMIF_FIN_PHY.310000.STEP21 ORA-00001 UNIQUE CONSTRAINT PS_ASSET (Doc ID 2398213.1)

Last updated on MAY 14, 2018

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Functionality

AMIF1000 Unique Constraint Error

When there are multiple lines for an asset in the INFTC_FIN/PHY tables (Asset Management > Send/Receive Information > Interface Transactions > Review), system user must apply the Tag Number to all lines for that asset, or the AMIF1000 process runs to No Success, with a unique constraint error. Possible issue with AMIF1000 process.

ERROR
-----
ABENDED at Step AMIF_FIN_PHY.310000.Step21 (Action SQL) -- RC = 805
SQL Error: ORA-00001: unique constraint (EMDBO.PS_ASSET) violated

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot interface assets from PC.

REPLICATION STEPS
=================
1. Asset, with two rows, sent to INTFC_FIN/PHY table in AM from Project Costing
2. Both rows for the Asset are in a Pending Status and Auto Approve Status box is checked. Applied a unique Tag Number to row one of Asset and left the Tag Number field on row two blank.
3. Ran the AMIF1000 process to load Asset and received a Unique Constraint error.

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!


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