5.13 Create and use an Oracle Fusion Accounting Hub Connection

Oracle Fusion Accounting Hub (FAH) is part of Oracle Fusion Cloud Applications that provides accounting services to various applications and ERPs. You can use Data Transforms to load accounting-related data and submit jobs to automate data import and Accounting Engine execution.

You need to store the financial data in ZIP format in Object Storage, create an Oracle FAH Connection, and then use the Oracle Fusion Import step in the Workflow editor to load the ZIP files to FAH.

The newly created connections are displayed in the Connections page. See View and Manage Connections.

This topic has the following sections:

Creating an Oracle Fusion Accounting Hub Connection

You can use this connection only as a target to load data from ZIP files stored in Object Storage. See Loading Data to Oracle Fusion Accounting Hub.

To create an Oracle Fusion Accounting Hub connection:

  1. From the left pane of the Home page, click the Connections tab.

    Connections page appears.

  2. Click Create Connection.

    Create Connection page slides in.

  3. Do one of the following:
    • In the Select Type field, enter the name or part of the name of the connection type.
    • Select the Applications tab.
  4. Select Oracle Fusion Accounting Hub as the connection type.
  5. Click Next.
  6. The Connection Name field is pre-populated with a default name. You can edit this value.
  7. In the Service URL text box, enter the URL pointing to the Oracle Fusion Accounting Hub Service.
  8. Enter the user name and password to connect to the service.
  9. Click Test Connection, to test the established connection.
  10. After providing all the required connection details, click Create.

Loading Data to Oracle Fusion Accounting Hub

You can use the Oracle Fusion Import step that is available in the Workflow editor as a step to load data from Object Storage to the Oracle FAH tables.

When the workflow runs, Data Transforms validates the ZIP files, converts them to Base64, uploads the Base64 files to Universal Content Management (UCM), and submits an Enterprise Scheduler Service (ESS) job to FAH to import the files and invoke the Accounting Engine.

Before you use this step, make sure that you have:
  • A ZIP file that includes the transaction header file, the transaction lines file, and the metadata definition file. Make sure that the files are generated using the correct Fusion Accounting Hub templates.

    The file name of the ZIP file should have the XlaTransaction prefix, which is the format that FAH requires. For example, XlaTransaction_Acc_Exp.zip.

  • A source Object Storage connection that contains the ZIP file. See Create an Oracle Object Storage Connection for instructions about creating an Object Store connection.
To load data into Oracle Fusion Accounting Hub Service tables:
  1. On the Home page, click the required Project title and then click Workflows in the left pane.
  2. On the Workflow page, click Create Workflow.

    The Create Workflow page appears.

  3. In the Name field provide a name for the new workflow and click Create. The Workflow editor opens.
  4. Drag and drop Oracle Fusion Import on the canvas.
  5. Double click the Oracle Fusion Import step to open the step properties page.
  6. Under Target Connection do the following:
    1. From the Fusion Type drop-down select Oracle Fusion Accounting Hub.
    2. Select the connection you created in Creating an Oracle Fusion Accounting Hub Connection.
  7. Under Source Connection do the following:
    1. From the Object Storage drop-down select the connection where the ZIP file is located.
    2. The File Selection (ZIP) drop-down is populated with the ZIP files available in that Object Storage. Select the file you want to use to load the data.
  8. Click save icon to save the created/designed workflow.
  9. Click execute icon to execute the created workflow.
  10. [Optional] To check the status of the workflow, see the Status panel on the right below the Properties Panel. For details about the Status panel, see Monitor Status of Data Loads, Data Flows, and Workflows. This panel shows the link to the Job ID that you can click to monitor the execution status on the Jobs page. For more information about jobs see Create and Manage Jobs.

    You can also track detailed progress of the process in Fusion Accounting Hub in the Scheduled Processes work area.

  11. [Optional] You can set a schedule to run the workflow. See Schedule Data Flows or Workflows for instructions about creating a schedule.

Parent topic: Connections