1. Implementing Enterprise Structures and General Ledger
  2. Import Budget Data from a Flat File

Import Budget Data from a Flat File

Use the upload budgets processes to integrate budget information from other budgeting applications such as Oracle Hyperion Planning.

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 load your budget amounts to the General Ledger balances cube by populating the GL_BUDGET_INTERFACE table and running the Validate and Upload Budgets process. You can load budgets for multiple periods and for multiple ledgers with the same chart of accounts in a single load process.

Note: Budget data isn't loaded to the GL_BALANCES table and only loaded to the balances cube for variance reporting purposes.

Assigning Values for Columns in the GL_BUDGET_INTERFACE Table

For budget import to be successful, you must enter values in the columns of the interface table that require values.

The following table describes the columns that require values.

Name

Value

RUN_NAME

Enter a name to identify the budget data set being imported.

STATUS

Enter the value NEW to indicate that you're loading new budget data.

LEDGER_ID

Enter the appropriate ledger ID value for the budget amount. You can view the ledger ID for your ledgers on the Manage Primary Ledgers page. The ledger ID column is hidden by default, but you can display it from the View Columns menu. If you enter multiple ledgers for the same run name, all of the ledgers must share the same chart of accounts.

BUDGET_NAME

Enter the appropriate budget name value for the budget line. You define the budget names in the Accounting Scenario value set.

PERIOD_NAME

Enter the period name that you're loading the budget data for. You can load budget data to Never Opened, Future Enterable, and Open periods only.

CURRENCY_CODE

Enter the currency for the budget.

SEGMENT1 to SEGMENT30

Enter valid and enabled account values for each segment in the chart of accounts.

BUDGET_AMOUNT

Enter the amount in the ledger currency for account types, expense and assets.

OBJECT_VERSION_NUMBER

For Oracle Cloud implementations, leave this field blank as the application automatically populates this when you load the data from the secure FTP server. For other implementations, you can set the column to a value of 1.

These columns remain blank because the budget import process either uses these columns for internal processing, or doesn't currently use them.

  • CHART_OF_ACCOUNTS_ID

  • CODE_COMBINATION_ID

  • ERROR_MESSAGE

  • CREATION_DATE

  • CREATED_BY

  • LAST_UPDATE_DATE

  • LAST_UPDATE_LOGIN

  • LAST_UPDATED_BY

  • REQUEST_ID

  • LOAD_REQUEST_ID

Related Topics