Administration of Oracle Financials Cloud Connector
Before you use Oracle Financials Cloud Connector to write data to the Oracle Financials Cloud application, you must perform the following prerequisite tasks:
The following image shows the Oracle File-Based Data Import for Oracle Financials Cloud page:
2Select the required operation that you want to use that are listed under the File-Based Data Imports section .
The selected operation page appears.
3Click the XLSM template file link to download the XLSM template file of the operation from the File Links section.
The following images shows a sample XLSM template file link that you must download from the File Links section:
4Ensure that you have access to the machine where the Secure Agent is installed or to the directory path that you have specified in the IO Directory connection property.
5Place the XLSM template file in the following directory path that is specified in the IO Directory connection property: IO Directory/Writer/Schema
For the following write objects, you must place the XLSM template file and the CTL file in the directory:
- Billing Data Import
- Revenue Basis Data Import
Note: Retain the name of the XLSM template file or the CTL file when you create a mapping using the operation that you selected.
Obtain the ERP Endpoint URL
Before you create an Oracle Financials Cloud connection to read or write data from the Oracle Financials Cloud application, you must obtain the ERP Endpoint URL of the Oracle Financials Cloud application.
Perform the following steps to obtain the ERP Endpoint URL:
1In the Oracle Financials Cloud application, click Navigator.
2Click Developer Connect in the Tool section.
3In the WebServices section, type ERP Integration Service in the Find field.
The Web Service: ERP Integration Service: Summary page appears that displays the ERP Endpoint URL. The following example shows a sample ERP Integration Service end point URL: