My Oracle Support Banner

OGL EPF: Statistic Values Transferred as Negative from GL into FEM_BALANCES (Doc ID 854268.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
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')

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.