Oracle® Fusion
Accounting Hub Implementation Guide 11g Release 5 (11.1.5) Part Number E20374-05 |
Contents |
Contact Us |
Previous |
Next |
This chapter contains the following:
Importing Budget Data: Explained
Oracle Hyperion Planning: Overview
Integration with Hyperion Planning: Overview
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.
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.
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
Load the budget amounts to the interface table by following the steps below.
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.
Upload the comma separated values (csv) file to the secure FTP server.
Run the Load Interface File for Import process.
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, 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:
Delivers global collection of data and financial consolidation
Enables entry, analysis, and reporting on data, including personalizing data entry forms
Facilitates budgeting collaboration, communication, and control across multidivisional global enterprises
Drives the planning process
Provides a framework for perpetual planning, with attention to managing volatility and frequent planning cycles
Promotes modeling using complex business rules and allocations
Integrates with Smart View so you can design worksheets in Microsoft Excel to enter, format, analyze, and report on data
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 |
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.