Overview of Budget Uploads

In Oracle General Ledger, you can load budget data to perform variance reporting.

If you use a third-party budgeting application or don't use a budgeting application, there are two ways to load budgets into the GL Balances Cube.

• Importing Budget Data from a Flat File: Export budget data from your budgeting application to a comma separated values .csv file. Use the Import General Ledger Budget Balances file-based data import (FBDI) to prepare and generate flat files in a .csv format. You can use Oracle ADF Desktop Integrator correction worksheets to correct validation errors, delete rows with errors, and resubmit the corrected error rows.

  Note: For more information about FBDI, see the Oracle Fusion Cloud Financials File-Based Data Import (FBDI) for Financials guide.

• Importing Budget Data from a Spreadsheet: You can access the budget load spreadsheet from the General Accounting Dashboard. Enter, load, and correct budget data in the ADF Desktop Integrator spreadsheet tool. Use this tool to prepare and load budget data for multiple ledgers and periods with a common chart of accounts instance. The list of values and the web picker help you select valid values. This simplified data entry reduces errors and alerts you to errors as you enter the data in the spreadsheet. Error correction is done in the same spreadsheet.

Here are some points to consider when preparing your budget data.

• You can maintain budget amounts only for detail accounts. However, if you're also using budgetary control, you can configure your setup to maintain budget amounts for summary accounts.

  Note: For more information about budgetary control setup, refer to the Budgetary Control chapter, Enterprise Options section in the Oracle Fusion Cloud Financials Using Financials for the Public Sector guide.

• If you already uploaded your budget and you perform another upload using the same criteria, the upload process overwrites the existing amounts with the amounts from the new upload.

The following figure shows the process flow for budget upload. Prepare your budget data, upload it using a spreadsheet or flat file, and report on the budget data.

Caution: When the GL Balances Cube is rebuilt, the process retains the budget balances as well as the actual balances. Only the budget balances loaded using the spreadsheet or flat file through the GL Budget Balances interface table are retained.Create reports in Smart View or Financial Reporting to verify that the budget data was loaded correctly.