FEM_BALANCES Showing Duplicate Amounts for Budget Balance Rules
Last updated on DECEMBER 05, 2008
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
-- 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.
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