Receipt Accrual PO_RECVACCR Abends At Step PO_RECVACCR.RACCR010.INS_ACCT (SQL) With RC = 805 Cannot Insert Duplicate Key Row (Doc ID 2812128.1)

Last updated on OCTOBER 04, 2021

Applies to:

Symptoms

On: 9.2, PUM#5, Tools: 8.54, Production Environment. Receipt Accrual

Receipt Accrual PO_RECVACCR process worked fine at end of last month (Aug 2021) but at this end of this month (Sept 2021) the process abended at step PO_RECVACCR.RACCR010.INS_ACCT (SQL) -- RC = 805 (108,524) so not able to complete the process.

ERROR MESSAGE:
File: e:\pt854-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 805 -
[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_RECV_LN_ACCTG' with unique index 'PS_RECV_LN_ACCTG'.
The duplicate key value is (00001, 0000027278, 5, 1, 1, DST, REC_ACCRUE, 11, 2021, N, Aug 31 2021
Failed SQL stmt: INSERT INTO PS_RECV_LN_ACCTG (BUSINESS_UNIT, RECEIVER_ID, RECV_LN_NBR, RECV_SHIP_SEQ_NBR, DISTRIB_LINE_NUM,
DST_ACCT_TYPE, APPL_JRNL_ID, ACCOUNTING_PERIOD, FISCAL_YEAR, ORIGINAL_TRANS, DT_TIMESTAMP, ACCOUNT, ALTACCT, DEPTID, BUSINESS_UNIT_GL,
MERCHANDISE_AMT, QTY_DS_ACCPT_SUOM, QTY_DS_ACCPT_VUOM, QTY_PO, BUSINESS_UNIT_PO, PO_ID, PO_RELEASE_ID, SCHED_NBR, LINE_NBR, PO_DIST_LINE_NUM,
STATISTICS_CODE, STATISTIC_AMOUNT, LEDGER_GROUP, ACCOUNTING_DT, JOURNAL_ID, JOURNAL_DATE, UNPOST_SEQ, CURRENCY_CD, MONETARY_AMOUNT, FOREIGN_AMOUNT,
OPEN_ITEM_STATUS, JRNL_LINE_STATUS, RT_TYPE, RATE_MULT, RATE_DIV, FOREIGN_CURRENCY, JOURNAL_LINE_DATE, JRNL_LN_REF, LEDGER, MONETARY_AMT_VCHR,
GL_DISTRIB_STATUS, BASE_CURRENCY, PROCESS_INSTANCE, JOURNAL_LINE, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF,
AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE,
RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE, USER_DIST_CHAR1, CUSTOM_C100_D1, CUSTOM_C100_D2, CUSTOM_C100_D3, CUSTOM_C100_D4, CUSTOM_DATE_D,
CUSTOM_C1_D, CANCEL_FLAG, ENTRY_EVENT, NEXT_PRD_REVERSAL, BUDGET_DT, BUDGET_LINE_STATUS, BUDGET_HDR_STATUS, KK_AMOUNT_TYPE, KK_TRAN_OVER_FLAG,
KK_TRAN_OVER_OPRID, KK_TRAN_OVER_DTTM, EE_PROC_STATUS) SELECT W.BUSINESS_UNIT, W.RECEIVER_ID, W.RECV_LN_NBR, W.RECV_SHIP_SEQ_NBR, W.DISTRIB_LINE_NUM,
W.DST_ACCT_TYPE, W.APPL_JRNL_ID, W.ACCOUNTING_PERIOD, W.FISCAL_YEAR, W.ORIGINAL_TRANS, W.DT_TIMESTAMP, W.ACCOUNT, W.ALTACCT, W.DEPTID, W.BUSINESS_UNIT_GL,
W.MERCHANDISE_AMT, W.QTY_DS_ACCPT_SUOM, W.QTY_DS_ACCPT_VUOM, W.QTY_PO, W.BUSINESS_UNIT_PO, W.PO_ID, W.PO_RELEASE_ID, W.SCHED_NBR, W.LINE_NBR,
W.PO_DIST_LINE_NUM, W.STATISTICS_CODE, W.STATISTIC_AMOUNT, W.LEDGER_GROUP, W.ACCOUNTING_DT, W.JOURNAL_ID, W.JOURNAL_DATE, W.UNPOST_SEQ, W.CURRENCY_CD,
W.MONETARY_AMOUNT, W.FOREIGN_AMOUNT, W.OPEN_ITEM_STATUS, W.JRNL_LINE_STATUS, W.RT_TYPE, W.RATE_MULT, W.RATE_DIV, W.FOREIGN_CURRENCY, W.JOURNAL_LINE_DATE,
W.JRNL_LN_REF, W.LEDGER, W.MONETARY_AMT_VCHR, W.GL_DISTRIB_STATUS, W.BASE_CURRENCY, W.PROCESS_INSTANCE, W.JOURNAL_LINE, W.OPERATING_UNIT, W.PRODUCT,
W.FUND_CODE, W.CLASS_FLD, W.PROGRAM_CODE, W.BUDGET_REF, W.AFFILIATE, W.AFFILIATE_INTRA1, W.AFFILIATE_INTRA2, W.CHARTFIELD1, W.CHARTFIELD2, W.CHARTFIELD3,
W.BUSINESS_UNIT_PC, W.PROJECT_ID, W.ACTIVITY_ID, W.RESOURCE_TYPE, W.RESOURCE_CATEGORY, W.RESOURCE_SUB_CAT, W.ANALYSIS_TYPE, W.USER_DIST_CHAR1, W.CUSTOM_C100_D1,
W.CUSTOM_C100_D2, W.CUSTOM_C100_D3, W.CUSTOM_C100_D4, W.CUSTOM_DATE_D, W.CUSTOM_C1_D, W.CANCEL_FLAG, W.ENTRY_EVENT, W.NEXT_PRD_REVERSAL, W.BUDGET_DT, W.BUDGET_LINE_STATUS,
W.BUDGET_HDR_STATUS, W.KK_AMOUNT_TYPE, W.KK_TRAN_OVER_FLAG, W.KK_TRAN_OVER_OPRID, W.KK_TRAN_OVER_DTTM, W.EE_PROC_STATUS FROM PS_RCV_LNACTG_TMP W WHERE W.PROCESS_INSTANCE = 2633195

Process 2633195 ABENDED at Step PO_RECVACCR.RACCR010.INS_ACCT (SQL) -- RC = 805 (108,524)

STEPS:
1. Run the PO_RECVACCR process from the Accrue Receipts run control page multiple times at end of previous month.
2. Then run the process from the Accrue Receipts run control page for end of current month.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.