Oracle Fusion Financials

Oracle Fusion Cloud Financials gives your finance team better data to increase forecasting accuracy, shorten reporting cycles, simplify decision-making, and better manage risk and compliance. Oracle Fusion Cloud Financials is a global financial platform that connects and automates your financial management processes, including payables, receivables, fixed assets, expenses, and reporting, for a clear view into your total financial health. DLH.io is your best option to synchronize your Oracle Fusion Financials data to other target destination systems like Snowflake, Databricks, and Oracle Data Warehouse.

Setup Instructions

DLH.io securely connects to your Oracle Fusion Cloud system. Using the form in the DLH portal you'll complete the following basic steps. To capture the information from your Oracle Cloud account follow these initial steps:

In order to configure the REST API the following checklist should be followed:

• You have created your Oracle Fusion Application Instance (see how, if needed)
• Create a new Oracle Fusion service account user specifically for the DLH integration
• Assign the appropriate permissions to the new service account
  • The user should have the ORA_ASM_APPLICATION_IMPELEMNTATION_CONSULTANT_JOB role
  • See the Oracle Fusion HCM REST API Security Role Concepts (alt), as needed
• Capture the new permissions credentials and information to be used in configuring the connection in DLH.io
• Create an Oracle Fusion App (ex: HCM, Finance, etc.) connection in DLH.io (DLH.io) by applying the correct connection information and credentials.
• Select the desired tables/entities that you wish to synchronize to your target destination
• Connect your target connection in DLH and build a DLH Sync Bridge
• Run the DLH Sync Bridge
• Review your landed data in your selected target destination connection
• Query and build on the data from your target destination.

Create New DLH.io Connector to Oracle Fusion Financials

In your DLH.io account click on Sources and locate or search for the Oracle Fusion Financials connector and click on the corresponding Add Source button:

1. Enter a Name or Alias for this connection, in the Name/Alias field, that is unique from other connectors.
2. Enter in the Target Schema Prefix field, a name which will be the prefix for the schema at the target destination to where your data will sync.
3. Enter in the Server URL your unique Oracle Fusion app account URL.This will the first part of the URL in your Oracle Fusion Application in your address bar, for example, https://xxxxxxx.fa.us2.oraclecloud.com
4. Enter in the User field your username for Oracle Fusion
5. Enter in the Password field your Oracle Fusion password
6. Click the Authorize Your Account button.
7. Once your credentials are accepted you should see a successful connection confirmation message. If you require a different authorization method please contact the DLH support and customer success teams for assistance.

Supported Features

This table lists out some of the features supported and potential roadmap items for this connector. If you have any questions please reach out to our Customer Support team.

Schema Information

Provided upon requests. Request Oracle Fusion Schema Information.

We talk data for breakfast, lunch, and dinner. So, if you have any questions please send us a note on our Support Portal.