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 NOVEMBER 23, 2019
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).
Changes
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! |