Browser version script Skip Headers

Oracle® Fusion Accounting Hub Implementation Guide
11g Release 5 (11.1.5)
Part Number E20374-05
Go to contents  page
Contents
Go to Feedback page
Contact
Us

Go to previous page
Previous
Go to previous page
Next

11 Define Budget Configuration

This chapter contains the following:

Importing Budget Data: Explained

Oracle Hyperion Planning: Overview

Integration with Hyperion Planning: Overview

Importing Budget Data: Explained

Use the Load Budgets process to integrate budget information from other budgeting application such as Oracle Hyperion Planning, Fusion Edition. You can load your budget amounts to the General Ledger balances cube by populating the GL_BUDGET_INTERFACE table and running the Validate and Load 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 that the budget data is not loaded to the GL_BALANCES table and only loaded to the balances cube for variance reporting purposes.

Note

You can load data to interface tables using predefined templates and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud feature. For other implementations, optionally use this feature only if you have SFTP configured for it.

Assigning Values for Columns in the GL_BUDGET_INTERFACE Table

You must enter values in all the columns of the interface table that require values, which includes all of the not null columns, in order for the budget import to be successful.

Enter values in the following required columns of the interface table:


Column Name

Values

RUN_NAME

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

STATUS

Enter the value NEW to indicate that you are bringing new budget data.

LEDGER_ID

Enter the appropriate ledger ID value for the budget amount. You can view the ledger ID for your ledgers in 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 need to share the same chart of accounts.

BUDGET_NAME

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

PERIOD_NAME

Enter the period name that you are loading the budget data for. Note that you can load budget data regardless of the period status.

CURRENCY_CODE

Enter the currency code for your budget.

SEGMENT1 to SEGMENT30

Enter valid enabled account value for each segment in your chart of accounts.

ENTERED_DR

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

ENTERED_CR

Enter the credit amount in the ledger currency for account types, revenue, equity, and liability.

OBJECT_VERSION_NUMBER

For Oracle Cloud implementations, leave this field blank as the application will automatically populate this when you load the data from the secure FTP server to the interface table. For other implementations, you can default the column with a value of 1.

The following columns should be left as null as the budget import process uses these columns for internal processing or does not use them in the current release.

Loading Data to the Budget Interface Table: Explained

Load the budget amounts to the interface table by following the steps below.

  1. Export budget data from your budgeting application to a comma separated values (csv) file. You can use the sample csv file or xls file that is provided in Oracle Enterprise Repository (OER) for Oracle Fusion Applications as a reference.

  2. Upload the comma separated values (csv) file to the secure FTP server.

  3. Run the Load Interface File for Import process.

  4. After the data is loaded to the interface table, you can run the Validate and Load Budgets process to load the budget amounts to the General Ledger balances cube.

Oracle Hyperion Planning: Overview

Oracle Hyperion Planning, Fusion Edition is a comprehensive, web based, budgeting and planning application. Planning can be licensed and integrated with the Oracle Fusion Accounting Hub to provide expanded budgeting and planning functionality.

Oracle Hyperion Planning, Fusion Edition:

The following table provides installation and configuration activities and documentation references.


Activities

Documentation

Installation of Planning

Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide for Oracle Hyperion Enterprise Performance Management

Configuration of Planning

Oracle Hyperion Planning, Fusion Edition Administrator's Guide for Oracle Hyperion Planning

Integration of Planning

Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications Administrator's Guide

Integration with Hyperion Planning: Overview

For Oracle Cloud implementations, integrate with on-premise Oracle Hyperion Planning, Fusion Edition for advanced budgeting by loading actual balances from Oracle Fusion Accounting Hub to Oracle Hyperion Planning so you can use the actual data in the budgeting process. You can also load budget data from Oracle Hyperion Planning to Oracle Fusion Accounting Hub through the Budget Interface to perform budget variance reporting within Oracle Fusion Accounting Hub.

For other implementations, Oracle Fusion Applications provides integration between Oracle Fusion Accounting Hub and Oracle Hyperion Planning through Oracle Financial Data Quality Management ERP Integrator adapter. To complete the post-installation setup for the ERP Integrator adapter, see Oracle Hyperion Financial Data Quality Management ERP Integrator Adapter for Oracle Applications Administrator's Guide.