21 Complete Oracle Fusion Applications Accounting Hub Post-Installation Tasks

This section describes the Oracle Fusion Applications Accounting Hub post-installation tasks that should be reviewed and completed before starting working with an Oracle Fusion Applications Fusion Accounting Hub implementation.

This section contains the following topics:

21.1 Set Up the Financial Reporting Center

To setup the Financial Reporting Center, follow the steps detailed in Set Up the Financial Reporting Center.

21.2 Integrate with Other Products

Oracle Fusion Applications provides a coexistence strategy that allows to continue to use the Oracle E-Business Suite or Oracle PeopleSoft General Ledgers and subledgers while using Oracle Fusion Applications Accounting Hub for financial reporting.

21.2.1 Integrate with Oracle E-Business Suite and Oracle PeopleSoft: Overview

Coexistence includes the ability to transfer balances from the Oracle E-Business Suite General Ledger and journal entries from Oracle PeopleSoft General Ledger to the Oracle Fusion Applications Accounting Hub.

For more information on completing the post-installation setup for coexistence with Oracle E-Business Suite General Ledger see:

  • Details in Configuring Oracle Golden Gate to Integrate the E-Business Suite Ledger with Fusion Accounting Hub on My Oracle Support.

  • Define Applications Coexistence Configuration for E-Business Suite in the Oracle Fusion Accounting Hub Implementation Guide

  • Integrating with Oracle Fusion Applications in the Oracle General Ledger Implementation Guide Release 12.2: This guide contains information about loading and transferring data from Oracle E-Business Suite to the Oracle Fusion Applications Accounting Hub.

For more information on completing the post-installation setup for coexistence with Oracle PeopleSoft General Ledger, see:

  • Define Applications Coexistence Configuration for PeopleSoft in the Oracle Fusion Accounting Hub Implementation Guide

  • Integrating PeopleSoft General Ledger with Oracle Fusion Accounting Hub inPeopleSoft General Ledger 9.1 Documentation Update

The Oracle Data Integrator (ODI) component (extract file for manual import) is currently available via My Oracle Support only in note id: 1365971.1.

21.2.1.1 Register Applications Coexistence Instances

Register applications coexistence instances to indicate in Oracle Fusion General Ledger which Oracle E-Business Suite and Oracle PeopleSoft instances are integrated with the Oracle Fusion Applications Accounting Hub. A user interface enables to perform this registration. For each E-Business Suite or PeopleSoft instance, provide a unique system identifier. This identifier must also be registered in the corresponding Oracle E-Business Suite or Oracle PeopleSoft instance.

Specify a unique journal source per instance. For Oracle E-Business Suite, limit which instance and balancing segments may post to a particular Oracle Fusion General Ledger.

For Oracle E-Business Suite, determine the Function ID to move data from Oracle Fusion General Ledger to Oracle E-Business Suite General Ledger. Include the Function ID at the end of the drill down URL that is provided during the registration of the Oracle E-Business Suite instance.

To find the Oracle E-Business Suite Function ID:

  1. Login as a System Administrator and navigate to the Function page.
  2. Query for the function name: GL_FUSION_EBS_DRILL.
  3. From the Help menu, click Diagnostics, and then click Examine.
  4. Select the FUNCTION_ID field. The value box shows the value of the Function ID.

For Oracle E-Business Suite: The URL format for the non-dynamic portion needs to be in the following format: http://<domain>:<port>/OAA_HTML/RF.jsp?function_id=<function_id>.

In the above URL format, the domain, port, and function_id are for the Oracle E-Business Suite Instance.

For Oracle PeopleSoft: The URL format for the non-dynamic portion needs to be in the following format: http://server/servlet_name/SiteName/PortalName/NodeName/c/PROCESS_JOURNALS.FUS_DRILLBACK_JRNL.GBL

In the above URL format:

  • http://server/: Scheme (http or https) and the web server name.

  • servlet_name/: Name of the physical servlet that the web server invokes to handle the request.

  • SiteName/: Site name specified during Oracle PeopleSoft Pure Internet Architecture setup.

  • PortalName/: Name of the portal to use for this request.

  • NodeName/: Name of the node that contains the content for this request.

21.2.2 How to Integrate with Data Relationship Management: Overview

Oracle Fusion Applications provides integration between Oracle Fusion Applications Accounting Hub and Oracle Hyperion Data Relationship Management. The integration is included with Oracle Fusion Applications Accounting Hub, Oracle Hyperion Data Relationship Management to store corporate charts of accounts values and hierarchies, and then update this information to both Oracle Fusion Applications Accounting Hub and the Oracle E-Business Suite General Ledger.

21.2.3 How to Integrate with Hyperion Planning: Overview

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

For other implementations, Oracle Fusion Applications provides integration between Oracle Fusion Applications Accounting Hub and Oracle Hyperion Planning through Oracle Financial Data Quality Management ERP Integrator adapter.

21.3 Next Steps

If the Oracle Fusion Human Capital Management product offering has been installed, go to Complete Oracle Fusion Human Capital Management Post-Installation Tasks . Otherwise, go to the section that corresponds to the product offering that is installed.