How General Ledger Budget Balance Import Data Is Processed

Use the Import General Ledger Budget Balances file-based data import (FBDI) to load budget data from external sources for upload to the GL balances cube. You can download a budget spreadsheet template to use to prepare your budget data.

The template contains an instruction sheet to help guide you through the process of entering your budget information.

To access the template, complete the following steps:

1. Navigate to the Oracle Fusion Cloud Financials File-Based Data Import (FBDI) for Financials guide.

2. In the table of contents, click General Ledger.

3. Click Import General Ledger Budget Balances.

4. In the File Links section, click the Excel template.

Follow these guidelines when preparing your data in the worksheet:

• Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

• Don't change the order of the columns in the template.

• You can hide or skip the columns you don't use, but don't delete them.

Settings That Affect the General Ledger Budget Balances Import Process

The Import General Ledger Budget Balances template contains an instructions tab and a tab that represents the table where the data is loaded.

The Instructions and CSV Generation tab contains information about:

• Preparing the budget data.

• Understanding the format of the template.

• Entering budget data.

• Loading the data into the interface table and the GL balances cube.

The GL_BUDGET_INTERFACE tab is where you enter information about the budget data that you adding, such as the ledger, budget name, periods, segment values, and amounts.

How General Ledger Budget Balance Import Data Is Processed

To load the data into the interface table:

1. Click the Generate CSV File button on the instructions tab to create a CSV file in a .zip file format.

2. Save the .zip file locally.

3. Navigate to the Scheduled Processes work area.

4. Select the Load Interface File for Import process.

5. For the Import Process parameter, select Validate and Upload Budgets.

6. For the Data File parameter, select the file that you saved in step 2.

To load the data from the interface table to the balances cube:

1. Navigate to the Scheduled Processes work area.

2. Select the Validate and Upload Budgets process.

3. Enter values for the Run Name parameter.

4. If the process ends in error or warning:

   1. Review the log and output files for details about the rows that caused the failure.

   2. Navigate to the General Accounting Dashboard work area.

   3. Select the Correct Budget Import Errors task to download the budget corrections worksheet.

   4. Correct the entries in the worksheet and resubmit the Validate and Upload Budgets process.