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.
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