My Oracle Support Banner

EAM: 取引データローダー(AMIF1000)がステップ AMIF_FIN_PHY.210120.Step10 (SQL)で異常終了する (Doc ID 2054313.1)

Last updated on JANUARY 31, 2019

適用範囲:

PeopleSoft Enterprise FIN Asset Management - バージョン 9 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

リリース: 9/インターフェイス

取引データローダー(AMIF1000)を実行した時、以下のエラーが発生する。:

エラー
-----------------------
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

プロセス 920241 がステップ Step AMIF_FIN_PHY.210120.Step10 (SQL) で異常終了しました。RC = 805 (108,524)

変更点

 

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.