My Oracle Support Banner

Unable to Use Budget with Less Periods than Year Calendar Periods (Actuals for Previous Periods Consume Funds) (Doc ID 2571931.1)

Last updated on AUGUST 02, 2019

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Year calendar defined as following: ADJ-start period + 12 non-Adj periods(Jan-Dec). 

A budget was defined starting Jan period so excluding the starting Adj period. Summary accounts were defined just the same, starting Jan period,  so excluding the starting Adj period.

 

Attempt to create transactions within the budget periods (eg. Jan period), observe the funds are negative already hence transactions fail funds check. 

Funds Inquiry for YTD-extended confirm negative funds too. 

This is problematic especially for Assets accounts where the initial balance was loaded in the start-Adj period.

 

ERROR:

APP-SQLGL-08204: Your transaction(s) failed funds check. 

 

Observe that transactions created for periods not included in the budget (eg. ADJ-start period) are considered as "Actuals" for Budget periods (eg. Jan) YTD extended query even if those periods are not included in the Budget.

 


STEPS:
The issue can be reproduced at will with the following steps:
1. Gl responsibility > create ADJ+12 periods calendar
2. Define Budget, Jan-Dec periods 
3. For Asset account, enter opening balance of 1000 in ADJ starting period

4. Enter Budget of 100 for Jan period

5. Try to enter a transaction of 100 in Jan period, observe this fails funds check 

6. Query Funds Inquiry YTD-extended Jan period for the budget and account, note Budget = 100, Actuals = 1000, Funds available = -900

7. Verify that ADJ transactions are shown in Funds Inquiry and consume funds even if the period is not included in the budget



Changes

 New setup

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.