Setup Data Import and Export for Oracle Accounting Hub Cloud

These sections describe the manual tasks that you must complete as part of the setup data export and import processes for the Oracle Accounting Hub Cloud offering.

This table contains manual tasks that must be completed as part of the setup data export and import processes for the Oracle Accounting Hub Cloud offering.

Section

Description

Setup tasks performed before export

You must perform these tasks prior to initiating export processes for the Oracle Accounting Hub Cloud offering.

Setup tasks performed before import

You must perform these tasks prior to initiating import processes for the Oracle Accounting Hub Cloud offering.

Setup tasks performed after import

Setup data for these tasks is not imported from the source instance. Review and perform the manual setups steps on the target instance as required.

Refer to the Oracle Applications Cloud Using Functional Setup Manager guide for the steps to perform setup data export and import processes.

Setup Tasks Performed Before Export

Prior to initiating export processes from the source instance, you must verify and update setup for this task. Required to ensure that data is correctly imported into the target instance.

This table contains setup tasks performed before export.

Activity Name

Task Name

Setup Steps

Define Chart of Accounts

Manage Account Combinations

Account combinations are not exported from the source instance. Before exporting, navigate to the Manage Chart of Accounts Instance page on the source instance and verify that dynamic insertion is enabled for your charts of accounts. As long as dynamic insertion is enabled, account combinations are created automatically as needed on the target instance.

Setup Tasks Performed Before Import

Prior to initiating import processes into the target instance, you must verify and update setup for this task.

This table contains setup tasks performed before import.

Activity Name

Task Name

Setup Steps

Define Common Applications Configuration for Oracle Accounting Hub Cloud

Define Implementation Users

The import process does not include implementation users and roles associated with them.

For more information, see Oracle Fusion Middleware Enterprise Deployment Guide for Oracle Identity Management (Oracle Fusion Applications Edition).

Setup Tasks Performed After Import

Setup data for the following tasks are not imported. Review these tasks for relevance to your implementation. For relevant tasks, open the corresponding setup pages from your implementation project to create the setup on the target instance as needed.

This table contains setup tasks performed after import.

Activity Name

Task Name

Define General Ledger Options

  • Manage Journal Approval Rules

  • Manage Document Sequences

Define Document Sequences

Manage Document Sequences

Define Approval Management for Financials

  • Manage Task Configurations for Financials

  • Manage Approval Groups for Financials

Setup data for the following tasks are not imported from the source instance. Review the steps in the following table to create the setup on the target instance as needed.

This table contains steps to create the setup on the target instance as needed.

Activity Name

Task Name

Setup Steps

Define Accounting Transformation Configuration

Import Supporting Reference Initial Balances

This task enables upload of initial subledger balances for supporting references. These balances are not imported from the source instance, but can be loaded directly to the target instance.

For more information, see Oracle Financials Cloud Implementing Accounting Hub Guide, Define Accounting Transformation.

Define Financial Reporting

Configure Smart View Client for Users

Manually reconfigure the Smart View client to point to the production instance.

For more information about configuring the Smart View client for users, refer:

  • Oracle Financials Cloud Implementing Accounting Hub Guide, Define Financial Reporting

  • The Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com

Define Financial Reporting Center Configuration

Define Essbase Database Connection in Workspace

Manually reconfigure the Essbase database connection in Hyperion Workspace.

For more information about configuring the Hyperion Workspace Database Connection, see Oracle Financials Cloud Implementing Accounting Hub Guide, Define Financial Reporting,

Define Financial Reporting Center Configuration

Configure Financial Reporting Studio Client for Users

Manually reconfigure the Financial Reporting Studio client to point to the production instance.

For more information about configuring the Financial Reporting Studio client for users, refer:

  • Oracle Financials Cloud Implementing Accounting Hub Guide, Define Financial Reporting

  • The Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com

Define Financial Reporting

Create Financial Statements

Export the financial report definitions from Workspace in the source environment.

When exporting, you can export a single report, multiple reports in a .zip file, or an entire folder structure in a .zip file.

  1. Navigator > General Accounting: Financial Reporting Center > select link: Open Workspace for Financial Reports.

  2. Navigate to Applications > BI Catalog.

  3. Navigate to File > Export.

  4. Save the file to the local desktop.

Import the file into Workspace in the target environment.

  1. Navigator > General Accounting: Financial Reporting Center > select link: Open Workspace for Financial Reports.

  2. Navigate to Application > BI Catalog.

  3. Navigate to File > Import.

  4. Select the file you had saved during the export.

If you import the folder structure, the entire structure from the source instance is imported into the existing structure on the target instance. This could result in some redundant folders. In this case, you can reorganize child folders in the structure on the target instance and delete any unneeded folders.

Define Period Close Components

Manage Allocations and Periodic Entries

Export the allocation rules, rule sets, variables, and runtime prompt definitions from Calculation Manager in the source environment.

When exporting, you can export at the application level or at a single rule or rule set level.

Note: You must export and import rules for each application on the Essbase server separately.
  1. Navigator > General Accounting: Journals > select link: Create Allocation Rules.

  2. Navigate to File > Export.

  3. Save the file to the local desktop.

Import the file into Calculation Manager in the target environment.

  1. Navigator > General Accounting: Journals > select link: Create Allocation Rules.

  2. Select the specific application in which to import the rules.

  3. Navigate to File > Import.

  4. Select the file you saved during the export.

Define Hyperion Financial Management Integration

Define Hyperion Financial Management Configuration

Manually import the rules using the Oracle Enterprise Performance Management Life Cycle Management tool.

For more information, refer to the Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com.

Define Hyperion Financial Management Integration

Define ERP Integrator Configuration for Hyperion Financial Management

Manually import the rules using the Oracle Enterprise Performance Management Life Cycle Management tool.

For more information, refer to the Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com.

Define Budget Configuration

Define Budget Configuration in Hyperion Planning

Manually import the rules using the Oracle Enterprise Performance Management Life Cycle Management tool.

For more information, refer to the Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com.

Define Budget Configuration

Define ERP Integrator Configuration for Hyperion Planning

Manually import the rules using the Oracle Enterprise Performance Management Life Cycle Management tool.

For more information, refer to the Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com.