OBIA 11g: Essbase Load Plan Failed with ODI-1232: Procedure TLP_Financials_Essbase_Integration_Dimension_Build execution fails

(Doc ID 2098942.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

When running OOTB load plan ESSBASE , it failed in the following step TLP_FINANCIALS_ESSBASE_INTEGRATION_DIMENSION_BUILD with an error that may be similar to the following:


ODI-1519: Serial step "EBS_R1213 (InternalID:1489883040)" failed because child step "Essbase Load (InternalID:1489954040)" is in error.
ODI-1519: Serial step "Essbase Load (InternalID:1489954040)" failed because child step "TLP_FINANCIALS_ESSBASE_INTEGRATION_DIMENSION_BUILD (InternalID:1489955040)" is in error.
ODI-1217: Session TLP_FINANCIALS_ESSBASE_INTEGRATION_DIMENSION_BUILD (10154500) fails with return code 7000.
ODI-1226: Step TLP_Financials_Essbase_Integration_Dimension_Build fails after 1 attempt(s).
ODI-1232: Procedure TLP_Financials_Essbase_Integration_Dimension_Build execution fails.

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