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