Using ODI to Load Data into a Staging Table in Oracle Database, the Data Appears One Column to the Left with Respect to the Headers (Doc ID 1526583.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

An Essbase BSO application with a plan type of 9 dimensions is being used. The plan type has Account (1469 level0 members) & Cost_Center (310 level0 members) as the Dense dimensions.

An ODI interface is used to extract the data using a calculation script and load the data into the staging table of Oracle.

The data extract is fine as per Essbase. However, the data load to the staging table are misplaced with the different Cost_Centers in the table, the data appears one column to the left with respect to the headers.

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