EAM: AMIF1000 ABENDED at Step AMIF_FIN_PHY.210120.Step10 (SQL) -- RC = 805 (108,524) (Doc ID 2015347.1)

Last updated on JUNE 05, 2017

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9 and later
Information in this document applies to any platform.

Symptoms

On :  9 version, Interface

When running Run Load Transactions to AM process (AMIF1000), the below error occured 


ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1603 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_COST) violated
Failed SQL stmt:INSERT INTO PS_COST (BUSINESS_UNIT, ASSET_ID, BOOK, DTTM_STAMP, CF_SEQNO, GROUP_ASSET_ID, MEM_IN_SERVICE_DT, IU_MAP_KEY, CONVENTION, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, PROJECT_ID, DEPTID, CATEGORY, COST_TYPE, TRANS_TYPE, TRANS_IN_OUT, TRANS_CODE, TRANS_DT, ACCOUNTING_DT, ACTIVITY_SW, RETIRE_SW, QUANTITY, TXN_COST, COST, TRANSFER_BU, TRANSFER_ASSET_ID, TRANSFER_BOOK, OPRID, TXN_CURRENCY_CD, FROM_CUR, ARCHIVE_ID, GRP_ACCUM_DEPR, GRP_DEPR_YTD, GRP_DEPR_CALC_STAT, SALVAGE_VALUE, RT_TYPE, RATE_MULT, RATE_DIV, RT_EFFDT) SELECT BUSINESS_UNIT, ASSET_ID, BOOK, DTTM_STAMP, CF_SEQNO, GROUP_ASSET_ID, NULL, IU_MAP_KEY, (CASE WHEN INTFC_TYPE = 'ADJ' OR INTFC_TYPE = 'ADQ' THEN ADJUST_CONVENTION ELSE CONVENTION END), OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, PROJECT_ID, DEPTID, CATEGORY, COST_TYPE, TRANS_TYPE, TRANS_IN_OUT, TRANS_CODE, TRANS_DT, ACCOUNTING_DT, ACTIVITY_SW, RETIRE_SW, QUANTITY, TXN_COST, COST, TRANSFER_BU, TRANSFER_ASSET_ID, TRANSFER_BOOK, OPRID, TXN_CURRENCY_CD, CURRENCY_CD, ARCHIVE_ID, DEPR, DEPR_YTD, GRP_DEPR_CALC_STAT, SALVAGE_VALUE, RT_TYPE, RATE_MULT, RATE_DIV, RT_EFFDT FROM PS_AMIF_COST_TMP4 WHERE BUSINESS_UNIT = :1 AND PROCESS_INSTANCE = 920241

Process 920241 ABENDED at Step AMIF_FIN_PHY.210120.Step10 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


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