OGL EPF: Statistic Values Transferred as Negative from GL into FEM_BALANCES
Last updated on JULY 21, 2009
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10 to 220.127.116.11
This problem can occur on any platform.
OGL EPF Data Integration
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.
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:
- Go to the Enterprise Performance Foundation Administrator responsibility
- Go to Data Rules > Oracle Data Sources > GL Balances
- Run a Balance Rule that includes statistic values (currency_code = 'STAT')
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms