Connections > Oracle Financials Cloud V1 connection properties > Prerequisites
  

Prerequisites

Before you create an Oracle Financials Cloud V1 connection to read from or write to Oracle Financials Cloud application, be sure to complete the prerequisites.

Access the XLSM template files

To write to the Oracle Financials Cloud application, access the XLSM template files and CTL files for objects that require control files.
  1. 1Select the specific Oracle Financials Cloud instance version from the File-Based Data Import for Financials page in the Oracle documentation.
    2. For example, to access the XLSM template in the Oracle Financials Cloud instance 20A, go to the following URL:
    https://docs.oracle.com/en/cloud/saas/financials/20a/oefbf/overview.html#overview
  2. 2Select the required operation that you want to use that are listed under the File-Based Data Imports section.
    3. The selected operation page appears.
  3. 3Click the XLSM template file link to download the XLSM template file of the operation from the File Links section.
    4. The following image shows a sample XLSM template file link that you download from the File Links section:
  4. 4Ensure that you have access to the Secure Agent machine or to the directory path that you have specified in the IO Directory connection property.
  5. 5Place the XLSM template file in the following directory path that is specified in the IO Directory connection property: IO Directory/Writer/Schema
    6. For the following write objects, place the XLSM template file and the CTL file in the directory:
    Note: To create a mapping using the operation that you selected, retain the name of the XLSM template file or the CTL file as provided by Oracle. Only when you retain the file names, the file names appear in the Object Selection window.

Get the ERP endpoint URL

Get the ERP Integration Service end point URL to read from or write data to Oracle Financials Cloud application.
  1. 1In the Oracle Financials Cloud application, click Navigator.
  2. 2Click Developer Connect in the Tool section.
  3. 3In the WebServices section, type ERP Integration Service in the Find field.
    4. 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:
    https://adc-fap0011-fin.oracledemos.com:443/publicFinancialCommonErpIntegration/ErpIntegrationService
  4. 4Edit the URL by removing the following path: 443/publicFinancialCommonErpIntegration/ErpIntegrationService
    5. The following URL is a sample of the ERP Endpoint URL:
    https://adc-fap0011-fin.oracledemos.com