R12: Encumbrances Not Considered In Funds Checking Calculation (Doc ID 1401546.1)

Last updated on OCTOBER 21, 2015

Applies to:

Oracle Public Sector Financials - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle General Ledger - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 05-Sep-2013***

Symptoms

Budgetary Control funds checking should use this formula:
Budget - Encumbrances -Actuals = Funds Available

Noticed that this formula is not considered and Encumbrances are not used in the calculation at all.
As a result, funds checking is wrong and funds reservation is possible even when sufficient funds are not available. This allows the funds to go negative even for Absolute funds checking.
This could affect Summary, Detail level funds checking, or both, depending on existing setup.
Further the users noticed that for some specific cases the Funds inquiry form (GLXIQFUN) shows different funds available if compared to 'view results' html page (Budgetary Control Results - BudgetaryControlResultsPG) opened from inside a journal using 'view results' button in GLXJEENT - Journal Entry form.

Budgetary control group (GLXSTBCG) does not allow Tolerance or Override Amount for this case.
<Patch 12359561> Critical Bug fixes for Public Sector Customer  and
<Patch 9328734> THE FUNDS VERIFICATION FAILS EVEN WHEN FUNDS ARE AVAILABLE
were applied but did not resolve the issue.
No datafix was applied as per
<Note 1115496.1> When Do Summary Budget All Transactions Fail Funds Checking Even Though Sufficient Funds Exist 


Identified the following STEPS to reproduce the issue (might not be limited to this sequence of steps)
1. Create new account in value set
2. Create summary template for this account
3. Enter budget value for this account
4. Create manual actual journal (check funds and 'view results' from inside the journal to review the calculation)
4. Create Encumbrance journal with reserve funds (check funds and 'view results' from inside the journal to review the calculation)
5. Create another actual journal (check funds and 'view results' from inside the journal to review the calculation)
6. Post Encumbrance journal
Re-check funds in the last actual journal (check funds and 'view results' from inside the journal to review the calculation-here the calculation is no longer correct)

Changes

None

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