My Oracle Support Banner

R2: FCEXEC_JOB Fails With Extending Temp Tablespace (Doc ID 2986480.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

The batch FCEXEC_JOB fails in POM and when checked in the COST_EVENT_RESULT table, all the assigned threads fail with the below error:

Error: @0PACKAGE_ERROR@1ORA-01652: unable to extend temp segment by 128 in tablespace TEMP@2FUTURE_COST_SQL.EXPLODE_TMP_RELATIONSHIP_CHG
Query : select * from cost_event_result where ERROR_MESSAGE is not null and COST_EVENT_PROCESS_ID=######;

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


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