AMIF1000 ABENDED at Step AMIF_FIN_PHY.310020.Step20 (SQL) -- RC = 805 (108,524) (Doc ID 652474.1)

Last updated on APRIL 27, 2017

Applies to:

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

This document was previously published as Customer Connection Solution 201032529


***Checked for relevance on 26-FEB-2013***
***Checked for relevance on 27-APR-2017***



Symptoms


PeopleSoft Asset Management Information Center > Listing of AMIF1000 Error Messages and Troubleshooting Tips to Resolve Each Error > Note 652474.1


AMIF1000 abends after following the steps below:.

1. Create an asset voucher.
2. Interface the voucher to AM and create asset.
3. The voucher was unposted and posted again after updating the voucher discount.
4. Two voucher transactions were sent to AM INTFC_PRE_AM table in the same day and one of the transactions is "RET".
5. After AMPS1000 was run, a new record was created in the INTFC_FIN and INTFC_PHY_A tables with the old asset id. and INTFC_TYPE = 'ADQ'.
6. AMIF1000 abended with the unique constraint error.

SQL error. Stmt #: 1604  Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_ASSET_ACQ_DET) violated

INSERT INTO PS_ASSET_ACQ_DET (
 BUSINESS_UNIT, ASSET_ID, SEQUENCE_NBR_6, SYSTEM_SOURCE, DESCR, CAPITALIZATION_SW,
 BUSINESS_UNIT_PO, PO_ID, PO_LINE_NBR, PO_DIST_LINE_NUM, SCHED_NBR, REFERENCE_ID,
 BUSINESS_UNIT_AP, VOUCHER_ID, VOUCHER_LINE_NUM, DISTRIB_LINE_NUM, INVOICE_DT,
 VENDOR_ID, VENDOR_NAME, INVOICE_ID, TXN_CURRENCY_CD, CURRENCY_CD, TXN_AMOUNT,
 AMOUNT, QUANTITY, SALETX_AMT, SALETX_AMT_BSE, SALETX_CD, USETAX_AMT,
 USETAX_AMT_BSE, USETAX_CD, FREIGHT_AMT, FREIGHT_AMT_BSE, 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, BUSINESS_UNIT_PC, MASTER_PROJECT, ACTIVITY_ID,
 ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT,
 BUSINESS_UNIT_RECV, RECEIVER_ID, RECV_LN_NBR, RECV_DIST_LINE_NUM,
 RECV_SHIP_SEQ_NBR, DISTRIB_SEQ_NUM, INV_ITEM_ID, INCENTIVE_ID, MERCHANDISE_AMT,
 MERCH_AMT_BSE, MISC_AMT, MISC_AMT_BSE, VAT_INV_AMT, VAT_INV_AMT_BSE,
 VAT_NRCVR_AMT, VAT_NRCVR_AMT_BSE, VAT_RCVRY_AMT, VAT_RCVRY_AMT_BSE,
 ADJUSTMENT_DT, VAT_TRANS_TYPE, RT_TYPE, RATE_MULT, RATE_DIV, RT_EFFDT)
SELECT DISTINCT
 A.BUSINESS_UNIT, A.ASSET_ID, A.SEQUENCE_NBR_6, A.SYSTEM_SOURCE, A.DESCR,
 A.CAPITALIZATION_SW, A.BUSINESS_UNIT_PO, A.PO_ID, A.PO_LINE_NBR,
 A.PO_DIST_LINE_NUM, A.SCHED_NBR, A.REFERENCE_ID, A.BUSINESS_UNIT_AP,
 A.VOUCHER_ID, A.VOUCHER_LINE_NUM, A.DISTRIB_LINE_NUM, A.INVOICE_DT,
 A.VENDOR_ID, A.VENDOR_NAME, A.INVOICE_ID, A.TXN_CURRENCY_CD, A.CURRENCY_CD,
 A.TXN_AMOUNT, A.AMOUNT, A.QUANTITY, A.SALETX_AMT, A.SALETX_AMT_BSE,
 A.SALETX_CD, A.USETAX_AMT, A.USETAX_AMT_BSE, A.USETAX_CD, A.FREIGHT_AMT,
 A.FREIGHT_AMT_BSE, A.OPERATING_UNIT, A.PRODUCT, A.FUND_CODE, A.CLASS_FLD,
 A.PROGRAM_CODE, A.BUDGET_REF, A.AFFILIATE, A.AFFILIATE_INTRA1,
 A.AFFILIATE_INTRA2, A.CHARTFIELD1, A.CHARTFIELD2, A.CHARTFIELD3, A.PROJECT_ID,
 A.DEPTID, B.CATEGORY, A.COST_TYPE, A.BUSINESS_UNIT_PC, A.MASTER_PROJECT,
 A.ACTIVITY_ID, A.ANALYSIS_TYPE, A.RESOURCE_TYPE, A.RESOURCE_CATEGORY,
 A.RESOURCE_SUB_CAT, A.BUSINESS_UNIT_RECV, A.RECEIVER_ID, A.RECV_LN_NBR,
 A.RECV_DIST_LINE_NUM, A.RECV_SHIP_SEQ_NBR, A.DISTRIB_SEQ_NUM, A.INV_ITEM_ID,
 A.INCENTIVE_ID, A.MERCHANDISE_AMT, A.MERCH_AMT_BSE, A.MISC_AMT, A.MISC_AMT_BSE,
 A.VAT_INV_AMT, A.VAT_INV_AMT_BSE, A.VAT_NRCVR_AMT, A.VAT_NRCVR_AMT_BSE,
 A.VAT_RCVRY_AMT, A.VAT_RCVRY_AMT_BSE, A.INVOICE_DT, ' ', A.RT_TYPE, A.RATE_MULT,
 A.RATE_DIV, A.RT_EFFDT
  FROM PS_AMIF_IPA_TMP4    A,
       PS_PROFILE_DET_TBL  B
 WHERE A.PROCESS_INSTANCE = 241231
   AND A.INTFC_TYPE = :1
   AND A.GROUP_ASSET_ID = :2
   AND A.BUSINESS_UNIT = :3
   AND B.SETID = :4
   AND A.PROFILE_ID = B.PROFILE_ID     AND B.BOOK = :5
   AND B.EFFDT = (SELECT MAX(I.EFFDT)
                    FROM PS_PROFILE_DET_TBL I
                   WHERE I.SETID = :6
                     AND I.PROFILE_ID = B.PROFILE_ID
                     AND I.BOOK = :7
                     AND I.EFFDT <= A.ACQUISITION_DT)
                     AND A.CAPITALIZATION_SW IN ('1','2','3','4')
                     AND A.DEFAULT_PROFILE_SW = 'Y'

Process 241231 ABENDED at Step AMIF_FIN_PHY.310020.Step20 (SQL) -- RC = 805 (108,524)


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