My Oracle Support Banner

EPY: PSPPYRUN Fails With Error ORA-1652: Unable To Extend Temp Segment on PSTEMP (Doc ID 2584818.1)

Last updated on SEPTEMBER 04, 2019

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version


PSPPYRUN pay calculation process fails with the following error.

Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 01652
Error Message : ORA-01652: unable to extend temp segment by 512 in tablespace PSTEMP
Stored Stmt : PSPTARRY_S_YTD
SQL Statement : SELECT A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.ADDL_NBR ,C.COMPA NY ,C.STATE ,C.LOCALITY ,C.TAX_CLASS ,C.WORK_PSD_CD ,C.RES_PSD_CD ,C.BALANCE_QTR ,C.BALANCE_PERIOD ,C.TXGRS_YTD ,C.TAX_YTD ,C.TXGRS_QTD ,C.TAX_QTD ,C.TXGRS_MTD ,C.TAX_MTD ,C.NLGRS_
  YTD ,B.COMMON_PAY_IND ,C.TIPS_MTD ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE FROM PS_PAY_EARNINGS A ,PS_STATE_TAX_TBL B ,PS_TAX_BALANCE C WHERE A.COMPANY=:1 AND A.PAYGROUP=: 2 AND A.PAY_END_DT=:3 AND A.OFF_CYCLE=:4 AND A.SINGLE_CHECK_USE IN ('N','C') AND A.OK_TO_PAY='Y' AND A.PAY_LINE_STATUS IN ('I', 'P', 'U') AND A.EMPLID=C.EMPLID AND C.BALANCE_ID=:5  AND C.BALANCE_YEAR=:6 AND C.STATE NOT IN ('$UAS','$UGU','$UPR','$UVI') AND B.STATE=A.STATE AND B.EFFDT= (SELECT MAX(D.EFFDT) FROM PS_STATE_TAX_TBL D WHERE D.STATE=B.STATE AND D.EFFDT<=:7) ORDER BY A.COMPANY ASC ,A.PAYGROUP ASC ,A.PAY_END_DT  ASC ,A.OFF_CYCLE ASC ,A.PAGE_NUM ASC ,A.LINE_NUM ASC ,A.SEPCHK ASC ,A.ADDL_NBR ASC ,C.COMPANY ASC ,C.STATE ASC ,C.LOCALITY ASC ,C.TAX_CLASS ASC ,C.BALANCE_QTR DESC ,C.BALANCE_PERIOD DESC?


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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