You must calculate budget amounts whenever you define or revise your budget formulas, or if you change the accounts you use in your formulas.
Calculating budget amounts from budget formulas does not create journal entries; rather, it updates budget balances directly. General Ledger replaces, rather than increments, the account balances with the calculated amounts.
Data Access Sets
You must have Read and Write access to the ledger and the balancing segment value or management segment value used in the Budget Formula to update budget amounts. If you have insufficient access to the ledger and segment value, your Budget Formula will complete with an error status and no budget amounts will be updated. See Data Access Sets.
Prerequisites
Open a budget year.
Define a budget formula batch.
Navigate to the Calculate Budget Amounts window.
Enter the name of the Budget for which you want to calculate budget amounts. You cannot choose a frozen budget or a budget with no open years. General Ledger displays the Latest Open Year for your budget.
General Ledger displays the name of each Recurring Batch you have defined for this budget, including frozen batches. Select the unfrozen formula batches you want to use to calculate budgets amounts.
Note: If your Budget Formula has been secured using definition access sets, you must have Use access to the Budget Formula to calculate budget amounts.
Enter the accounting Period From and To which you want to calculate budget amounts. General Ledger displays the Last Run Date for each chosen formula batch.
Choose Calculate.
General Ledger submits a concurrent process to validate your Budget Formula, calculate budget amounts, and update account balances. General Ledger automatically produces the Budget Formula Execution Report to display the status of your Budget Formula and notifies you of any errors. Refer to the Request ID of the concurrent process to view the output of this report.
Budget Formula Execution Report Errors
The following table lists the common errors detected by the Budget Formula Execution Report:
| Error Code | Description | Possible Causes |
|---|---|---|
| EA01 | You do not have write access to all of the lines in this formula. | Your data access set does not provide Read and Write access to the ledger and balancing segment value or management segment value used in the Budget Formula entry lines. Check your data access set security to verify which ledger and balancing segment value or management segment value you can write to. If you use reporting currencies (journal or subledger level), then check your data access level for the reporting currency. |
| EA02 | The balancing segment or management segment value specified is not assigned to this ledger. | Your Budget Formula entry lines contain balancing segment values or management segment values that have not been assigned to your ledger. Check your balancing segment value assignments or management segment value assignments in Accounting Setup Flow Manager to ensure that the segment values have been assigned to your Legal Entity and Ledger. |
| WA01 | You do not have read access to all of the calculation lines in this formula. | Your data access set does not provide read access to one ore more accounts listed as a step in your Formula. In order to read a balance from an account that is used in a step in your formula, you must have at least Read access as defined by your data access set. |
| EB01 | Budget Organization is frozen. | This formula is using a budget that has been frozen. You cannot update or write to budgets that have been frozen. |
| EB02 | Account is frozen for this budget organization. | This formula is using an account that has been frozen. You cannot update budget balances to frozen budget accounts. |
| EB03 | The budget is invalid for this ledger. | The budget entered at calculation time is not a budget defined for the ledger you are writing budgets to. |
You can generate your Budget Formula batch according to schedules in Oracle Applications, schedules you define in Oracle Applications, or schedules you define in General Ledger.
If your Budget Formula has been secured using definition access sets, you must have Use and View access to the Budget Formula you want to schedule.
Navigate to the Budget Formula Parameters window.
Complete the following fields:
Name: Enter or choose a name from the list of values for the Budget Formula batch you want to schedule.
Period: Enter an accounting period or choose from the list of values.
Budget: Enter a budget or choose from the list of values.
Choose the Schedule button.
The Oracle Applications Submit Request window opens.
Choose the Schedule button.
The Schedule window opens.
You can create your own schedule by completing the regions in this window. For more information, see: Oracle E-Business Suite User's Guide.
Or, choose the Apply a Saved Schedule button to select from a set of pre-defined Oracle Applications or General Ledger schedules.
Return to the Submit Request window and submit your request.
Note: If your Budget requires Budget Journals, you will not be able to use this feature.