EAM: Transaction Loader (AMIF1000) abend 805 Unique Constraint / duplicate row error on PS_ASSET at Step AMIF_FIN_PHY.310000.Step21 (Doc ID 1985472.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After changing the physical information for 1 of 2 Voucher lines, the Transaction Loader program (AMIF1000) fails with the following error:

File: e:\pt854-903-r1-retail\peopletools\src\psappeng\aedebug.h
SQL error. Stmt #: 1703 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_ASSET) violated
Failed SQL stmt: INSERT INTO PS_ASSET (BUSINESS_UNIT, ASSET_ID, ASSET_TYPE, ASSET_SUBTYPE, PARENT_ID, COMPONENT_OF_ID, ASSET_ASSIGNED_TO, TAGGABLE_SW, TAG_NUMBER, DESCR, DESCRSHORT, ASSET_STATUS, FINANCIAL_ASSET_SW, REPLACE_SW, REPLACE_ASSET_ID, CONVERSION_ID, NEW_ASSET_SW, AVAIL_SW, AVAIL_CONTACT, AVAIL_PHONE, ACQUISITION_CD, ACQUISITION_DT, FINANCING_CD, REPLACEMENT_COST, REPLACE_COST_DT, LEASE_ASSET_ID, PROFILE_ID, ASSET_CLASS, CAP_NUM, CAP_SEQUENCE, MFG_ID, MANUFACTURER, MODEL, PROD_VERSION, SERIAL_ID, PRODUCTION_DT, PLANT, MANUFACTUR_CONTACT, BUSINESS _UNIT_JV, INDEX_NAME, INDEX_DETAIL_NAME, LAST_INDEX_VALUE, COMPOSITE_SW, COMPOSITE_ID, FERC_CD
Process 13981 ABENDED at Step AMIF_FIN_PHY.310000.Step21 (SQL) -- RC = 805

Steps to replicate:
1. Create a voucher with two asset rows, different cost and quantities. Check "Use One Asset Id".
2. Post the voucher.
3. Run the Load Asset Request process (INTFAPAM).
4. Go to Asset Management > Send/Receive Information > Preview AP/PO Information. On the Pre-AM Physical tab, change the Serial Id and Tag Number for the first row only to any value.
5. Run AMPS1000.
6. Run the Transaction Loader (AMIF1000).

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