PO Receipt Accrual Process Runs To No Success at Step PO_RECVACCR.RACCR010.DELMXAC6 (Doc ID 2205867.1)

Last updated on NOVEMBER 21, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Error:-
/vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 89 Return: 1427 - ORA-01427: single-row subquery returns more than one row
Failed SQL stmt: SELECT DISTINCT B.BUSINESS_UNIT , A.ACCOUNTING_PERIOD , A.FISCAL_YEAR , A.CALENDAR_ID ,( SELECT DISTINCT X.FISCAL_YEAR FROM PS_CAL_DETP_TBL X WHERE X.CALENDAR_ID = A.CALENDAR_ID AND ((A.BEGIN_DT) + (-1)) >= X.BEGIN_DT AND ((A.BEGIN_DT) + (-1)) <= X.END_DT) AS PRE_YR , ( SELECT DISTINCT Y.ACCOUNTING_PERIOD FROM PS_CAL_DETP_TBL Y WHERE Y.CALENDAR_ID = A.CALENDAR_ID AND ((A.BEGIN_DT) + (-1)) >= Y.BEGIN_DT AND ((A.BEGIN_DT) + (-1))<= Y.END_DT) AS PRE_PRD FROM PS_RCV_LNACTG_TMP B ,PS_PO_LINE_DISTRIB D ,PS_BUS_UNIT_INTFC G ,PS_BU_LED_GRP_TBL L ,PS_PO_HDR H ,PS_CAL_DETP_TBL A ,PS_SET_CNTRL_REC C WHERE B.PROCESS_INSTANCE = 51786041 AND D.BUSINESS_UNIT = B.BUSINESS_UNIT_PO AND D.PO_ID = B.PO_ID AND G.BUSINESS_UNIT = D.BUSINESS_UNIT_GL AND L.BUSINESS_UNIT = D.BUSINESS_UNIT_GL AND L.DEFAULT_LEDGER_GRP = 'Y' AND H.BUSINESS_UNIT = B.BUSINESS_UNIT_PO AND H.PO_ID = B.PO_ID AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.RECNAME = 'CAL_DETP_TBL' AND A.SETID = C.SETID AND A.CALENDAR_ID = L.CALENDAR_ID AND TO_DATE('2016-10-05','YYYY-MM-DD') >= A.BEGIN_DT AND TO_DATE('2016-10-05','YYYY-MM-DD') <= A.END_DT

Process 51786041 ABENDED at Step PO_RECVACCR.RACCR010.DELMXAC6 (Do Select) -- RC = 1427 (108,524)

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

Steps To Reproduce the Issue:-
The issue can be reproduced at will with the following steps:
1) Tableset Control: In Set Control Value SHARE, Record Group FS_02 points to SetID SHARE
2) Tableset Control: In Set Control Value US001, change Record Group FS_02 to point to SetID US001
3) Delivered Calendar period 01 for SetID SHARE
4) Create another Calendar period 01 for SetID US001
5) Create a PO in BU US001. Make sure receiving and matching are required.Save and Dispatch.
6) Create a receipt from the PO.
7) Run Receipt Accrual (PO_RECVACCR).
8) Now create a Voucher from the Receipt and perform matching such that match status is "Matched"
9) Now again Run the Receipt Accrual Process.Process goes to No Success.

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