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 NOVEMBER 01, 2016

Applies to:

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

Symptoms

On :  9 version, Business Units

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

EXPECTED BEHAVIOR
-----------------------
PC_RPO process is needs to complete in a reasonable time frame

STEPS
-----------------------
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 "

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