GL Summary Account Upload  Help

GL Summary Account Upload creates and deletes GL summary account templates from Excel – the rollup definitions you would otherwise enter one at a time in the Summary Accounts window. For each row the upload writes the template and then runs Oracle’s standard Add/Delete Summary Accounts program, which generates or removes the summary accounts and their balances.

When to use it

• Create a set of summary templates for a ledger in one pass.
• Roll out a standard set of summary templates across several ledgers (one run per ledger).
• Add rollups for new rollup groups across many segment combinations.
• Delete obsolete summary templates in bulk.

Before you start

• A responsibility whose GL data access set includes the target ledger.
• The rollup groups you reference exist and are assigned to the parent values of the segment.
• The concurrent managers are running: each row submits Add/Delete Summary Accounts and waits for it to finish.

Step 1 – Set the parameters

Open GL Summary Account Upload in Blitz Report and set the parameter:

Step 2 – Run to download the Excel file

Click Run. The Excel file downloads and opens with one row per completed summary template of the ledger. The segment columns are named after the ledger’s chart of accounts segments (for example Company, Department, Account).

Step 3 – Enter or change the data

Each row is one summary template. To create a template, add a row with the Template Name, the Earliest Period from which balances are maintained, an optional Description, and for every segment column a segment type: D (Detail, one summary account per detail value), T (Total, one summary account for all values) or the name of a rollup group of that segment (one summary account per parent value in the group). Add Or Delete defaults to Add, and Concatenated Description defaults to the segment types joined by the segment separator, for example T-T-Headcount-T-T.

On a downloaded row only Add Or Delete can be changed: set it to Delete to remove that template and its summary accounts. An existing template cannot be modified; delete it and add it again with the new definition.

To use summary-level funds checking, also enter Funds Check Level, Debit Or Credit, Amount Type, Boundary and Funding Budget on the new row.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and saves the file. Correct any rows it flags before uploading.

Step 5 – Upload the file

In Blitz Report click Upload and select the saved file. This submits the upload request, which writes each template and runs Add/Delete Summary Accounts for it, waiting for each request to finish.

Step 6 – Review the result report

When the request completes, a result report opens listing every uploaded row with its status and message. The Request Log column links to the log of the Add/Delete Summary Accounts request of each row.

What’s produced

• Summary templates added to or deleted from the ledger, with their summary accounts and balances generated or removed by Add/Delete Summary Accounts.
• A result report listing every row with a status, a message and a link to the request log.

Common questions

Does it generate the summary accounts, or only the template?
Both. After writing the template it runs Add/Delete Summary Accounts, and the row status reflects how that request completed.

How is a row matched to an existing template?
By the ledger and the exact combination of segment types, not by the template name.

Can I rename a template or change its earliest period or segment types?
No. These columns are read-only on downloaded rows. Delete the template and add it again.

Why were my funds checking options not created?
They are written only when a template is added, and only when all five values (Funds Check Level, Debit Or Credit, Amount Type, Boundary and Funding Budget) are entered. Otherwise the template is created without them.

Why does the upload take a while?
Each row submits Add/Delete Summary Accounts and waits for it to complete before the next row is processed. Templates with many detail segments over a long period range take longest.

Troubleshooting