FUNCTIONALTOTAL Missing from Currency Type Value Set After Applying Patch 7373450 (Doc ID 975093.1)

Last updated on DECEMBER 16, 2009

Applies to:

Oracle Enterprise Performance Foundation - Version: 12.0.4 to 12.0.6 - Release: 12 to 12
Information in this document applies to any platform.
Financial Consolidation Hub - Version: 12.0.4 - 12.0.6
OGL EPF Integration

Symptoms

After applying Patch 7373450 "PSE(ONE-OFF) FOR THE BUG: 6795389" to an R12 instance, the Oracle General Ledger (GL) to Enterprise Performance Foundation (FEM) balance transfer code does correctly generate a new Currency Type Code of FUNCTIONALTOTAL in FEM_BALANCES but FUNCTIONALTOTAL is not added to the Currency Type dimension's value set.  As a result, the FUNCTIONALTOTAL dimension member does not appear in the interface and related balances are excluded from report results.

The FUNCTIONALTOTAL Currency Type created by Patch 7373450 should be added to the dimension's value set tables FEM_CURRTYPES_B and FEM_CURRTYPES_TL.

Steps To Reproduce:
  1. Apply <<Patch 7373450>> "PSE(ONE-OFF) FOR THE BUG: 6795389"
  2. Transfer balances from GL into FEM_BALANCES
  3. Run a report that includes the transferred balances
The balances with a Currency Type of FUNCTIONALTOTAL are not included in the report because FUNCTIONALTOTAL was not added to the dimension's tables FEM_CURRTYPES_B and FEM_CURRTYPES_TL.

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