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

Last updated on MARCH 08, 2017

Applies to:

Oracle Assets - Version 12.2.4 and later
Information in this document applies to any platform.

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

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