FAS402 Fully Reserved Assets Report Ends With Error: ORA-01652: unable to extend temp segment by 128. (Doc ID 2175749.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Symptoms

When attempting to run FAS402: Fully Reserved Assets Report,
the following error occurs.

ERROR
-----------------------
REP-0004: Warning: Unable to open user preference file.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP3
SELECT /*+ ORDERED */ DP . PERIOD_NAME PERIOD_NAME , DP . PERIOD_COUNTER PERIOD_COUNTER , dhcc.SEGMENT1 COMP_CODE , CB . ASSET_COST_ACCT GL_ACCOUNT , AD . ASSET_NUMBER || ' - ' || AD . DESCRIPTION ASSET_NUMBER , BOOKS . DATE_PLACED_IN_SERVICE START_
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: unable to extend temp segment by 128 in tablespace TEMP3
SELECT /*+ ORDERED */ DP . PERIOD_NAME PERIOD_NAME , DP . PERIOD_COUNTER PERIOD_COUNTER , dhcc.SEGMENT1 COMP_CODE , CB . ASSET_COST_ACCT GL_ACCOUNT , AD . ASSET_NUMBER || ' - ' || AD . DESCRIPTION ASSET_NUMBER , BOOKS . DATE_PLACED_IN_SERVICE START_

Cause

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