EAR 9.1+ ARUPDATE Abends With ARTEMP Space Issue At Step AR_POSTING.GROUP_WK.INACTAC (SQL) -- RC = 1652 (Doc ID 2121384.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, AR Update - Posting FSCM 9.1.35, PT 8.54.12, Oracle DB 12

ARUPDATE Abends with ARTEMP space issue at Step AR_POSTING.GROUP_WK.INACTAC (SQL) -- RC = 1652

ERROR
-----------------------
ABENDED at Step AR_POSTING.GROUP_WK.INACTAC (SQL) -- RC = 1652.
SQL error. Stmt #: 1703 Error Position: 100 Return: 1 652 - ORA-01652: unable to extend temp segment by 16 in tablespace PSTEMP Failed SQL stmt: UPDATE PS_PENDING_ITEM
SET AR_ERROR_CD = 'INACC' WHERE PROCESS_INSTANCE = 4799481 AND POSTED_FLAG = 'N' AND AR_ERROR_CD = ' ' AND EXISTS( SELECT 'X' FROM PS_GROUP_CONTROL GR , PS_PEN DING_DST D , PS_GL_ACCOUNT_TBL G WHERE GR.GROUP_BU = PS_PENDING_ITEM.GROUP_BU AND GR.GROUP_ID = PS_P ENDING_ITEM.GROUP_ID AND D.GROUP_BU = PS_PENDING_ITEM.GROUP_BU AND D.GROUP_ID = PS_PENDING_ITEM.GROU P_ID AND D.BUSINESS_UNIT = PS_PENDING_ITEM.BUSINESS_UNIT AND D.CUST_ID = PS_PENDING_ITEM.CUST_ID AND D.ITEM = PS_PENDING_ITEM.ITEM AND D.ITEM_LINE = PS_PENDING_ITEM.ITEM_LINE AND D.GROUP_SEQ_NUM = PS_ PENDING_ITEM.GROUP_SEQ_NUM AND G.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC U WHERE U.SETCNTRLVALU....

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Post transactions
2. Run Receivables Update

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete ARUPDATE.

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