OGL EPF: Statistic Values Transferred as Negative from GL into FEM_BALANCES

(Doc ID 854268.1)

Last updated on JULY 21, 2009

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to 11.5.10.2
This problem can occur on any platform.
OGL EPF Data Integration

Symptoms

In Enterprise Performance Foundation Administrator (FEM) 11i, statistic values transferred from Oracle General Ledger (GL) into FEM_BALANCES using a Balance Rule are negative values when they should be positive.

Statistic values have CURRENCY_CODE = 'STAT' in both GL and FEM.

Example:

In GL: PERIOD_NET_DR: 3, PERIOD_NET_CR: 3
In FEM: XTD_BALANCE_E: -3, XTD_BALANCE_F: -3, PTD_DEBIT_BALANCE_E: 3, PTD_CREDIT_BALANCE_E: 3

You expect the statistic values in the XTD balance columns in FEM_BALANCES to be positive.

Steps To Reproduce:

  1. Go to the Enterprise Performance Foundation Administrator responsibility
  2. Go to Data Rules > Oracle Data Sources > GL Balances
  3. Run a Balance Rule that includes statistic values (currency_code = 'STAT')

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