My Oracle Support Banner

PC_RPO Performance with Process Error - ORA-01652: Unable To Extend Temp Segment by 1 6 in TABLESPACE PSTEMP Failed (Doc ID 1360379.1)

Last updated on APRIL 13, 2018

Applies to:

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


On :  9 version, Business Units

PC_RPO process is taking 4 hours to complete processing a subset of transactions

PC_RPO process is needs to complete in a reasonable time frame

The issue can be reproduced at will with the following steps:
1. Configure Report Summarization Options
2. Run Project Costing, Reports, Summary, Reporting Options, Reporting Options 

When the process is run for Monthly, the process takes more time to process. When the Process is run for an year worth of data, the following error is received

"Stmt #: 1603  Error Position: 12 Return: 1652 - ORA-01652: unable to extend temp segment by 1 6 in tablespace PSTEMP Failed SQL stmt:INSERT INTO PS _PC_RPO_TMP4 (BUSINESS_UNIT, P ROJECT_ID, ACTIVITY_ID, ANALYS "


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

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