Error "ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP Statement: INSERT INTO PS_CM_VARADJ_TMP" when Running the 'Cost Accounting Creation' Process (CM_CSTACCTG) (Doc ID 2038964.1)

Last updated on AUGUST 12, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.1 and later
PeopleSoft Enterprise SCM Manufacturing - Version 9.1 and later
PeopleSoft Enterprise SCM Cost Management - Version 8.4 SP2 and later
Information in this document applies to any platform.
This Knowledge Document applies to Cost Management releases >= 9.1

Symptoms

The 'Cost Accounting Creation' process (CM_CSTACCTG) (navigation: Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation) is failing with the below error:

SQL error. Function:  SQLExec Error
Position:  0 Return:  1652 - ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP Statement:  INSERT INTO PS_CM_VARADJ_TMP

  

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