EAM:AMIF1000 ABEND AMIF_FIN_PHY.310000.STEP21 ORA-00001 UNIQUE CONSTRAINT PS_ASSET
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.
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.
ABENDED at Step AMIF_FIN_PHY.310000.Step21 (Action SQL) -- RC = 805
SQL Error: ORA-00001: unique constraint (EMDBO.PS_ASSET) violated
The issue has the following business impact:
Due to this issue, users cannot interface assets from PC.
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.
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