Collectors
      Back to home
      1. Knowledge Base
      2. Connect & Transform
      3. Collectors

      Oracle Fusion Collectors

      Oracle Fusion Collector types:

      1. Collect Data

      2. Get Ledger Balances

      3. Get Reports

      Overview

      DataBlend currently collects the following Oracle Fusion data types:

      • Academic Form Library Items

      • Cash Bank Accounts

      • Contracts

      • Expense Report

      • Items

      • Ledgers

       

      Configuration

      Field

       

      Required/ Optional

       

      Comments

       

      Type

      Required

      Oracle Fusion

      Name

      Required

      Descriptive free-text name for the collector

      Data Source

      Required

      Choose a pre-configured data source from the drop down or click Create New to create a new data source.

      Schema Name

      Required

      Enter a name for the schema where the collected data will be stored. This can be a pre-configured schema or a new schema which will be created the first time the collector is run.

      Credential

      Required

      Choose a pre-configured Oracle Fusion credential from the drop-down.

      Oracle Fusion Collector Type

      Required

      Utilize the pre-populated Collector Type drop-down menu.

      dependency

      Optional

      Utilizing the dependency will set a constant and define a relationship between attributes.

      expand

      Optional

      Utilizing the expand field will return an expanded version of a specific subresource.

      fields

      Optional

      Utilizing fields will return the specified, comma-separated list of fields.

      finder

      Optional

      Utilizing the finder will return specific data based on the data supplied in the parameter field.

      Example: mode=Summary,accountingPeriod=Jun-22,currency=USD

      onlyData

      Optional

      Utilizing onlyData by default all resource children URLs are returned.

      Example:

      onlyData=true

      or

      onlyData=false

      orderBy

       

      Optional

      Utilizing the orderBy field can help users get data back in a specific order.

      q

      Optional

      Utilizing the q field will refine the users search. The query parameter may contain one or more expressions separated by a semicolon.

      Example:

      q=deptno>=10 and <=30;loc!=NY

      Path

      Required

      Select the desired path from the pre-populated drop-down. The desired path will identify the REST API resource which is collected.
       
      Get Reports
      When we collect data from Oracle Fusion report a client expected to create a report in Oracle Fusion and provide report location details to DataBlend. A default report type should be set to .csv in Oracle Fusion by the client.
      1

      When on home screen navigate to the Menu at the top left.

      2

      When in the Menu, expand Tools group and click on the Reports and Analytics.

      3

      To access the reports navigate to Browse Catalog button at the top right of the screen.

      4

      The report can be found following the patch provided by the client.

      5

      Report can be downloaded in HTML, PDF, RTF, Excel of PowerPoint formats.

      6

      Select the format you want to download report in.

      7

      To access report details click More and select Properties from drop-down menu.

      8

      In the report Properties locate report Name, report file name extension (.xdo in composite Signature on the screenshot below) and path to the report. This will be entered in DataBlend collector as Absolute File Path.

      9

      Create collector in DataBlend with Collector Type “Get Reports” and Absolute File Path to the report in Oracle Fusion.

      10

       To learn more about Oracle Fusion API requirements, please visit Oracle Financials 23B - Get Started.