OGL EPF: Dimension Rules Only Transfer Values from One Org Id / Ledger in Multi-Org Instance

(Doc ID 564376.1)

Last updated on NOVEMBER 24, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
GL EPF Integration

Symptoms

In Enterprise Performance Foundation Administrator, release 11i, you are using the dimension rules to transfer General Ledger (GL) values for a segment that references a multi-org view.  Only values associated with one Org Id are being transferred from GL.  Values from the other Org Ids are missing.

Example:

Ledger "Vision 101" is associated with Org 101.
Ledger "Vision 201" is associated with Org 201.

The profile option "MO: Operating Unit" is set to 101 at the site level.  When the dimension rules are run for the "Vision 101" Ledger, values associated with Org 101 are transferred.  When the dimension rules are run for the "Vision 201" Ledger, still only values with Org 101 are transferred.  No values for Org 201 are transferred.  No Org 201 values exist in the FEM_xxxxxx_B table.

Note: To determine if the GL segment uses a multi-org view, go to the following GL screen:

If a multi-org view is used, Validation Type is set to "Table" and points to the view.

Steps To Reproduce:

No dimension members associated with the 201 Org Id exist.

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