IGI Dossier Maintenance Upload  Help

IGI Dossier Maintenance Upload creates and maintains dossier transactions – budget transfers – in Oracle Public Sector Financials International (IGI), directly from Excel. A dossier moves budget amounts from one or more source budget lines to one or more destination budget lines, using the seeded IGI dossier maintenance logic.

When to use it

• Create budget-transfer dossiers in bulk instead of keying them one by one.
• Reallocate budget between accounts and periods within a ledger.
• Build multi-line dossiers (several source and destination lines) from a spreadsheet.

Before you start

• Blitz Report is installed and Oracle Public Sector Financials International (IGI) is implemented and configured.
• You are signed in to a responsibility with dossier maintenance access for the ledger.
• The dossier types, budgets, budget periods and accounts you will reference already exist.

How a dossier is structured

Each dossier has a header (the ledger, dossier type, name and description) and one or more budget-transfer lines. Every row of the upload carries the header fields plus a source budget line and a destination budget line. To build a dossier with several lines, enter several rows that share the same transaction – the header is taken from the first row and each row adds its source and destination amounts.

Step 1 – Open the upload and download the template

Run IGI Dossier Maintenance Upload from the Blitz Report menu and set the parameters:

Step 2 – Enter the dossier header

On the first row of each dossier, enter the Ledger, Dossier Type, a Dossier Transaction Name and a Description. Leave Transaction Number blank to have it numbered automatically, or enter an existing number to maintain that dossier. Optionally reference a Parent Transaction Number.

Step 3 – Enter the source budget line(s)

Specify where the budget comes from: Source Budget, Source Period, Source Account and Source Budget Amount. The Source Funds Available and Source New Balance columns are calculated for reference and do not need to be entered.

Step 4 – Enter the destination budget line(s)

Specify where the budget goes: Destination Budget, Destination Period, Destination Account and Destination Budget Amount. As with the source, the Destination Funds Available and New Balance columns are reference only.

Step 5 – Save and upload

Save the workbook and use the Upload button. Each row is validated – ledger, dossier type, budgets, periods and accounts – and the dossier transactions are created or updated. Results are written back to the same workbook with a Status and Message per row.

What’s produced

• Dossier transactions in IGI with their source and destination budget lines.
• Auto-generated transaction numbers where the number was left blank.
• A result workbook with a Status and Message on every row.

Common questions

How do I create a dossier with several source or destination lines?
Enter several rows that share the same transaction. The header is taken once; each row contributes its source and destination amounts.

Do I have to supply a transaction number?
No. Leave it blank and it is numbered automatically from the dossier type’s numbering scheme. Enter an existing number to maintain that dossier.

What is the Parent Transaction Number for?
It links a dossier to a parent dossier where your configuration uses dossier hierarchies. Leave it blank if not applicable.

Do I need to fill the Funds Available / New Balance columns?
No – those are calculated for reference so you can see the effect of the transfer.

Troubleshooting