To complete a budget worksheet:Enter budget details for the line items in your budget using the Worksheet window. Or, delegate the budget worksheet to another manager in your organization hierarchy.
See: Delegating Budget Worksheets
To complete a budget worksheet:Define the properties of a budget worksheet in the Worksheet Characteristics window or open an existing worksheet from your inbox.
Edit the name of the Worksheet, if necessary.
Enter the date you will post the budget to the application in the Action Date field.
Enter the Start Date and End Date of this budget version.
Choose the Worksheet Characteristics button to review the properties of the budget worksheet in view-only mode.
Choose OK to dismiss the Worksheet Characteristics window.
Enter the Allocated amount for each budget measurement unit. As you allocate resources to budget line items, the application calculates the amount available for allocation.
Note: You can enter budget values without first entering the total allocated amount.
Choose the Budget tab.
Choose the Populate All button to load all line items into the worksheet for the primary budget entity.
Choosing Populate All does not load position transactions into the worksheet. You can add position transactions to the worksheet by selecting the position transaction from the list of values. If the application has not updated the position transaction to the application when you apply the budget worksheet, the Apply Budgets process writes an error to the Process Log Navigator.
For budgets with a primary entity of job or grade, the Populate All button loads all entities of the selected type in the Business Group.
Line items for which you can budget are limited by organization hierarchy if you select an organization hierarchy when defining the characteristics of the budget.
Note: If the worksheet mode is Edit and Make a New Version or Correct Old Version, the Populate All button loads the line items from the selected budget version into the worksheet. Choose the Populate All button before selecting any line items into the worksheet.
Use the Folder Tool to change the order and width of the columns in the worksheet, hide fields, or rename prompts.
Note: You can use the same folder for multiple worksheets if the budget is of the same primary entity, measurement unit, and budget style.
Select one or more line items to include in your budget.
Note: For example, select a position if you are budgeting by position.
Enter a budget amount for each line item, or enter a percentage of the total amount allocated for the budget measurement unit.
The application supports the entry of currency values of any length with variable decimal point placement.
Note: You can divide the budget amount for the line item by budget periods in the Budget Details window.
You cannot budget for the same line item twice. Selecting a line item into the worksheet removes the item from the list of available entities.
Choose the Apply button to propagate any changes to the total allocated amount throughout the worksheet based on the propagation method you select.
Note: If you change the allocated amount, but do not apply the changes, the application automatically calculates the new totals the next time you open the worksheet after saving it to your inbox, or when you post the completed budget to the application.
You can divide entries in the budget worksheet into periods. For example, you could divide a position budget of 40,000 into 10,000 per fiscal quarter.
You define budget periods when you set up your budget calendar.
To enter budget values by period:Enter a value for each budget line item in the Worksheet window.
Choose the Periods button to open the Budget Details window.
Choose the Periods tab.
De-select the coordination check box if you do not want this window to query the detail records for the budget period when you open the window.
Select the Start Date and End Date of the budget period.
Enter the budget amount or percentage of the allocated amount for each period.
Choose the Next Budget Unit or Previous Budget Unit button to move between budget line items.
Attention: While it is theoretically possible to define budget periods, commitment calculations, and payroll periods independently, without considering the relative sizes of the date ranges, this approach does not reflect best practice. Oracle recommends sizing the date ranges to one another proportionaltely. Define the budget period as the largest, then commitment calculation and payroll frequency in decreasing order of size.
For example, you can set up quarterly budget periods of three months in length, calculate commitments on a monthly schedule, and set up a bimonthly payroll frequency. This approach avoids rounding errors, yields the most meaningful results in reports, and is essential when you implement Workforce Intelligence reporting, such as Workforce Budget Management.
See Calculating Budget Commitments
See: Defining a Payroll
Save your work.
You can link budget entries for a period to budget sets. Within a budget set, you can distribute budget values by element and by cost allocation flexfield.
To enter budget values by budget set:Enter a value for each budget line item in the Worksheet window.
Choose the Periods button to open the Budget Details window.
Enter the budget amount or percentage of the allocated amount for each period.
Choose the Budget Sets tab.
Select a Budget Set.
Enter the budget amount or percentage of the allocated amount for each budget measurement unit in the budget set.
Choose the Budget Set Distribution button to open the Funding Distribution window where you can enter the percentage of the budget measurement unit amount that is distributed to an element in the budget set.
Choose the Elements tab.
Select an Element Set and Distribution percentage for the element.
Choose the Next Budget Set and Previous Budget Set buttons to move between budget sets.
Choose the Funding Source tab.
Do one of the following:
If this element is funded from your GL, then click in the Cost Allocation field to open the Cost Allocation Flexfield window and enter the cost allocation code combination by selecting a value for each applicable field
See: Writing Formulas for Default Assignment Costing
If this element is funded by a grant, then enter the Project, Task, Award, Expense, Organization (PTAEO) combination by selecting a value for each applicable field. In future releases of Oracle HRMS, this combination will be validated against your Oracle Grants setup.
Note: The PTAEO fields are only displayed if Oracle Grants is installed.
Enter a distribution percentage for each funding source record.
Choose the Next Element and Previous Element buttons to move between elements in the budget set.
Save your work.
Note: When you create or update a position, you can add it to a control budget version and enter budget data to the period level on the Budgets tab.