Dimesion Loader Utility Completes Successfully But Does Not Load Members (Doc ID 445191.1)

Last updated on MAY 06, 2010

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 6-May-2010.

Symptoms

In Enterprise Performance Foundation Administrator 11i, you cannot load dimension members into a dimension using the Dimension Loader utility in the "Data Rules" screen.  While the request finishes successfully, you cannot see the dimension members in the "Configuration Rules" > "Dimension" > "Members" screen and no rows exist in the base dimension tables.  Additionally, the rows remain in the _T interface tables with a STATUS = LOAD.  The View Log and the Output log do not contain any errors.

Note: The following program is used to load the records: "FEM_DIM_HIER_LOADER module: Dimension Member and Hierarchy Loader".

Steps To Reproduce:

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