FEM_BALANCES Showing Duplicate Amounts for Budget Balance Rules (Doc ID 560369.1)

Last updated on DECEMBER 05, 2008

Applies to:

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

Symptoms

When attempting to review budget results found the amount larger than expected. When checking the records in FEM_BALANCES found repeated amounts for the record.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Run Budget Balance Rule.
2. Review FEM_BALANCES.

Example of query:

select * from FEM_BALANCES a Where a.dataset_code =13001 and a.ledger_id=1002 and a.financial_elem_id=455 and a.natural_account_id=42842 and a.USER_DIM1_ID = 42559 and a.USER_DIM3_ID = 42547 and a.cal_period_id =(select b.cal_period_id from fem_cal_periods_tl b where b.cal_period_name='Feb-07' and source_Lang ='US')

3. See duplicate records.

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