ETL 9.2: Time Administration Process Abends In DEMO With ORA-01652: Unable To Extend Temp Segment By 16 In Tablespace PSTEMP

(Doc ID 1560004.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, Time Administration

When attempting to run Time Admin process,
the following error occurs.


-- Row(s) affected: 0
-- 12.03.35 Process 1123 ABENDED at Step TL_TA001100.DA000.Step180 (Action SQL) -- RC = 1652
-- 12.03.35 SQL Error: ORA-01652: unable to extend temp segment by 16 in tablespace PSTEMP

The issue can be reproduced at will with the following steps:
1. Run Time Admin process
2. Got the error


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