Oracle Financial Cloud Spoke

Manage invoices, ledger, and records in an Oracle Financial Cloud instance from your ServiceNow instance.

Request apps on the Store

Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Integration Hub subscription

This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.

Spoke version

Oracle Financial Cloud spoke v1.1.0 is the latest version.

Supported versions

This spoke was built for Oracle Financial Cloud API version 11.13.18.05, but may be compatible with later versions.

Spoke dependencies

If you’re having trouble installing the app, ensure that these dependent plugins are installed:

• Utility Actions Spoke
• ServiceNow IntegrationHub Action Step - REST (com.glide.hub.action_step.rest)
• ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)
• ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs)
• Complex Object (com.glide.cobject)
• ServiceNow IntegrationHub Action Template - Data Stream (com.glide.hub.action_type.datastream)
• ServiceNow Flow Designer - Dynamic Outputs (com.glide.hub.dynamic_outputs)

Note:

Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation.

Spoke flows

The Oracle Financial Cloud spoke provides sample flows to demonstrate automating the Oracle Financial Cloud tasks. To customize a sample flow, copy it to a new application scope. Available sample flows include:

Flow	Description
Get Accounted AP Invoices	Retrieves information about the accounted AP invoices. This flow triggers the Get Accounted AP Invoice subflow and includes the Look up Record Details action.
Import Journals	Imports the journal records from your ServiceNow instance to Oracle Financial Cloud system. To import the journal records, you must create the required records in the GL Interface module.
Import AP Invoices	Imports accounts payable invoice line and accounts payable invoice records from your ServiceNow instance to Oracle Financial Cloud system. To import the accounts payable invoice line and accounts payable invoice records, you must create the required records in the AP Invoices Interface and AP Invoices Lines Interface modules respectively.

Note:

The success message displayed after flow executions during the data imports from ServiceNow instance to Oracle Financial Cloud system, only indicates that data has been successfully pushed to Oracle Financial Cloud system. You must verify that the data import is successfully completed by accessing the Oracle Financial Cloud system.

Spoke subflows

The Oracle Financial Cloud spoke provides sample subflow, Get Accounted AP Invoice, to demonstrate automating Oracle Financial Cloud tasks. The subflow retrieves the accounted AP invoice records and is used in the Get Accounted AP Invoices flow. To customize the sample subflow, copy it to a new application scope.

Spoke actions

The Oracle Financial Cloud spoke provides actions to automate Oracle Financial Cloud tasks when events occurs in your ServiceNow instance. Available actions include:

Category	Action	Description
All Record Management	Create Record	Creates an object.
	Look up Record Details	Retrieves record details in an object.
	Look up Record Details By ID	Retrieves details of the specified record in an object.
AP Invoice Management	Import AP Invoices	Imports the actionable payment invoices.
	Look up AP Invoice Lines	Retrieves information about the accounts payable invoice lines.
	Look up AP Invoices	Retrieves information about the actionable payment invoices.
Currency Conversion	Look up Currency Rates	Retrieves information about the currency rates.
General Ledger	Get Code Combinations Details	Retrieves information about the code combinations.
	Get Subledger Balances	Retrieves information about the subledger balances.
	Import Journals	Imports details about the journals.
	Look up Ledger Balance	Retrieves information about the ledger balances.
Supplier Record Management	Look up Suppliers	Retrieves information about the suppliers.

Spoke modules

The Oracle Financial Cloud spoke adds the Oracle Financial Cloud application to your instance and includes these modules:

Module	Description
Accounted AP Invoices	Displays information about the accounted AP invoices. This information is retrieved when the Get Accounted AP Invoices flow is triggered.
AP Invoices Interface	Displays the accounts payable invoice records. Admin must create these records in the ServiceNow instance in this module. The Import AP Invoices flow imports these invoices from your ServiceNow instance to Oracle Financial Cloud system.
AP Invoices Lines Interface	Displays the accounts payable invoice line records. Admin must create these records in the ServiceNow instance in this module. The Import AP Invoices flow imports these invoices from your ServiceNow instance to Oracle Financial Cloud system.
BI Report Paths	Displays information about the folder path where the required report is saved. The Get Subledger Balances and Get Code Combinations Details actions retrieve the subledger balances from these folder paths. Admin must create two records for the two actions and specify the folder path in this module.
Get Currency Rates	Displays information about the currency rates. The currency rates are retrieved from the remote table, Get Currency Rates [sn_ofc_spoke_st_get_currency_rates]. You can use the remote table as reference and create another remote table for currency rates as per your requirement.
GL Interface	Displays the journal records. The Import Journals flow imports these records from your ServiceNow instance to Oracle Financial Cloud system. Admin must create the required journal records in this module.

Connection and credential alias requirements

Integration Hub uses aliases to manage connection and credential information. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection. For more information, see Connections and Credentials.

Two connection and credential records are available along with the spoke. You must configure these alias record to use the spoke. See Set up the Oracle Financial Cloud spoke for more information.

Note:

Depending on the Oracle Financial Cloud policies and account settings, you may have to change or refresh the credentials in your credential record periodically.

For information about setting up the spoke, see Set up the Oracle Financial Cloud spoke.