My Oracle Support Banner

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

Last updated on AUGUST 09, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.