GLXIQFUN: R12 Encumbrances Not Considered In Funds Checking Calculation
(Doc ID 1401546.1)
Last updated on FEBRUARY 12, 2021
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.
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)
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