GL Budget Amounts Upload  Help

GL Budget Amounts Upload loads General Ledger budget amounts – by account, by period – into an open GL budget, from Excel. Depending on how the budget is configured, the upload either creates budget journals and runs Journal Import, or loads the amounts directly through the budget interface; either way it runs the standard Oracle program for you and reports the result for each row.

When to use it

• Seed or load annual budget figures for many accounts and periods at once.
• Update an existing open budget’s amounts for a new fiscal year.
• Replace budget amounts, or add to existing amounts, on the accounts that allow it.
• Load budgets that require budget journals – the upload creates the journals and runs Journal Import for you.
• Review current budget balances by downloading in Create, Update mode.

Before you start

• Blitz Report is installed and you are signed in to a General Ledger responsibility with access to the target ledger.
• An open budget, a budget organization, and accounts assigned to that organization already exist.
• The budget’s fiscal-year period range is open.
• For budgets that require journals, a valid Journal Source and Journal Category are available.

Step 1 – Choose a mode, set the parameters and download

In Blitz Report, open GL Budget Amounts Upload, choose an Upload Mode (Create for an empty template, or Create, Update to download existing amounts), and set the parameters:

For a Create, Update download, supply the Budget Organization, Budget and Currency. Run the upload to download and open the Excel file.

Step 2 – Enter the budget amounts

Each row is one account. Its identity – Ledger Name, Budget Organization, Budget Name, Currency Code, Fiscal Year and Account – is required and list-validated. Enter the amount in each Period column, and set Add Or Replace to control whether the amount replaces or adds to the existing balance. For budgets that require journals, also fill the Journal Source and Journal Category.

Step 3 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation (for example, that journal-required budgets carry a Journal Source and Category), then saves the file. Correct anything it flags before continuing.

Step 4 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which runs Journal Import (for budgets that require journals) or Upload Budget Amounts (for direct-update budgets). When it finishes, a result report opens showing each row as success or error, with a link to the Oracle request output.

What’s produced

• Budget amounts loaded into the chosen GL budget – posted as budget journals for journal-required budgets, or applied directly to the budget balances.
• A result report listing every row with a status and a message, with a link to the Oracle request output so you can review what was processed.

Common questions

Does it overwrite my existing budget amounts?
It depends on the Add Or Replace value you choose per row. Replace updates the balance; Add increments it. For budgets that require journals, only the Add option is available (changes are posted as budget journals).

Why are the Journal Source and Journal Category columns empty for my budget?
They apply only to budgets configured with Require Budget Journals. For direct-update budgets they are left blank.

What happens after I upload?
For journal-required budgets the upload submits Journal Import and reserves funds; for direct-update budgets it submits Upload Budget Amounts. The result row links to the request output so you can review it.

Can I run the same file twice?
Yes. The upload first removes its own prior interface rows, so a re-run replaces rather than duplicates.

Why can’t I pick my budget or account?
The lists show only open budgets, assigned budget organizations, the budget’s open fiscal-year periods, and postable detail accounts for the selected ledger, organization and currency.

Troubleshooting