GL Summary Account Upload  Help

GL Summary Account Upload creates and deletes GL summary account templates from Excel – the rollup definitions you would otherwise set up one at a time in the GL Summary Accounts form. For each row the upload writes the template and then runs Oracle’s standard Add/Delete Summary Accounts program to generate or remove the underlying summary accounts.

When to use it

• Mass-create summary account templates for a ledger in one pass.
• Roll out a standard set of summary templates across several ledgers (run once per ledger).
• Add rollups for a new rollup group or segment hierarchy across many combinations.
• Bulk-delete obsolete summary templates.

Before you start

• Blitz Report is installed and you are signed in to a General Ledger responsibility with access to the target ledger.
• The rollup groups and segment hierarchies you reference already exist in the chart of accounts.
• The Add/Delete Summary Accounts program and its concurrent managers are available – the upload submits it and waits for it.

Step 1 – Set the parameter and download

In Blitz Report, open GL Summary Account Upload and choose the Ledger (limited to your GL access set). Run the upload to download and open the Excel file – it includes the ledger’s existing summary templates for reference.

Step 2 – Define the summary templates

Each row is one summary template. Enter the Template Name, the Earliest Period and a Description, and a segment type for each GL Segment column – a rollup group, a segment hierarchy, or detail / all, per account segment. Set Add Or Delete to Add to create the template, or Delete to remove an existing one. The optional budgetary-control columns (Funds Check Level, Debit Or Credit, Amount Type, Boundary, Funding Budget) set up summary-level funds checking when all of them are supplied together.

Step 3 – Validate and Save

Click Validate and Save. This checks for missing required values and validates your segment values against the chart of accounts, 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 writes each template and then runs Oracle’s Add/Delete Summary Accounts program to generate or remove the summary accounts, waiting for it to finish. When it completes, a result report opens showing each row as success or error.

What’s produced

• Summary account templates created or deleted in the chosen ledger, with the underlying summary accounts generated or removed by Oracle’s Add/Delete Summary Accounts program.
• A result report listing every row with a status and a message, including the Oracle request id for each template.

Common questions

Does it actually generate the summary accounts, or just the template?
Both. It writes the template, then runs Oracle’s Add/Delete Summary Accounts program, which generates (or removes) the underlying summary accounts. The row’s status reflects how that program finished.

How does it know whether a row is new or existing?
By matching the ledger plus the exact set of segment-type values – not by the template name. An exact match is treated as the same template.

What is the difference between Add and Delete?
Add creates a new template (or refreshes a matching active one); Delete marks a matching existing template for removal. Delete on a row that matches no template is rejected.

Why didn’t my budgetary-control options get created?
They are written only on Add, and only when all five (Funds Check Level, Debit Or Credit, Amount Type, Boundary and Funding Budget) are supplied. If any is missing the template is still created, but the budgetary-control row is skipped.

Why does each row take a while?
Each processed row submits a concurrent request and waits for it to finish before reporting status, so timing depends on your GL concurrent managers.

Troubleshooting