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

Last updated on FEBRUARY 20, 2018

Applies to:

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