My Oracle Support Banner

Requisition Budget Checking Process Fails With Error- "PV_FS_BP Failing With ORA-01652: Unable To Extend Temp Segment By 16 In Tablespace PSTEMP" (Doc ID 2617158.1)

Last updated on MAY 10, 2021

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Budget checking process fails with below error when too many requisitions are processed in one run.

Error:

PV_FS_BP Failing with ORA-01652: unable to extend temp segment by 16 in tablespace PSTEMP
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 12 Return: 1652 - ORA-01652: unable to extend temp segment by 16 in tablespace PSTEMP
Failed SQL stmt: INSERT INTO PS_BP_REFD_TAO7 (PROCESS_INSTANCE, KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN, KK_REFD_ID, KK_REFD_DT, KK_REFD_LN) SELECT S.PROCESS_INSTANCE, S.KK_TRAN_ID, S.KK_TRAN_DT, S.KK_TRAN_LN, H.KK_TRAN_ID, H.KK_TRAN_DT, L.KK_TRAN_LN FROM PS_BP_PO_S_TAO7 S, PS_KK_SHDR_REQ H, PS_KK_SOURCE_LN L WHERE S.PROCESS_INSTANCE=12866018 AND S.KK_PROCESS_PRIOR='Y' AND S.BUSINESS_UNIT_REQ=H.BUSINESS_UNIT AND S.REQ_ID=H.REQ_ID AND S.REQ_LINE_NBR=L.LINE_NBR AND S.REQ_SCHED_NBR=L.SCHED_NBR AND S.REQ_DISTRIB_NBR=L.DISTRIB_LINE_NUM AND H.KK_SOURCE_TRAN='REQ_PREENC' AND H.KK_PROCESS_STATUS IN ('V','W') AND H.KK_ROLLED_SEQ = 0 AND H.KK_TRAN_ID=L.KK_TRAN_ID AND H.KK_TRAN_DT=L.KK_TRAN_DT.


Steps to reproduce the issue:

1. Run Budget checking for epro requisitions
2. Error

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


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