My Oracle Support Banner

OBIA 11g: SDE_FUSION_ACCRUAL_TRANSACTION_FACT_SDS Utilising More Tablespaces and Running for Long Duration (Doc ID 2471473.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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

Symptoms

On Oracle Business Intelligence Applications Consumer (OBIA) 11.1.1.10.2 version,

  1. The Accrual Fact Stage step is taking more than 24 hours and still running.
  2. The above step failed couple of times due to tablespace issues due to utilisation of more tablespace.
  3. Same step failed after increasing tablespace with below error:

Error:
ODI-1226: Step SDE_FUSION_Accrual_Transaction_Fact_SDS.W_ACCRUAL_XACT_FS fails after 1 attempt(s).

ODI-1240: Flow SDE_FUSION_Accrual_Transaction_Fact_SDS.W_ACCRUAL_XACT_FS fails while performing a Integration operation. This flow loads target table W_ACCRUAL_XACT_FS.

ODI-1228: Task SDE_FUSION_Accrual_Transaction_Fact_SDS.W_ACCRUAL_XACT_FS (Integration) fails on the target ORACLE connection BIAPPS_DW.

Caused By: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace XXXX_DW_TEMP

Environment Details:

  1. OBIA Version: 11.1.1.10.2
  2. Source System and its version: Fusion R13
  3. Load Plan: Full Load
  4. Scenario failed: SDE_FUSION_Accrual_Transaction_Fact

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.