OBIA 11g: SIL_MfgLotGenealogyFact Throws ORA-01652: Unable To Extend Temp Segment By 128 In Tablespace TEMP

(Doc ID 2277774.1)

Last updated on NOVEMBER 21, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

OBIA : 11.1.1.10.2 version
EBS   : 12.2

SIL_MfgLotGenealogyFact runs for hours and then fails with the following

How to improve the performance of the job for full load?

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