Oracle Financials Cloud V1 Connector > Oracle Financials Cloud V1 connections > Connect to Oracle Financials Cloud
  

Connect to Oracle Financials Cloud

Let's configure the Oracle Financials Cloud V1 connection properties to connect to Oracle Financials Cloud.

Before you begin

Before you configure a connection, access the XLSM template file and obtain the ERP Endpoint URL of the Oracle Financials Cloud application.
Check out Prerequisites to learn more about these tasks.

Connection details

The following table describes the basic connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
Oracle Financials Cloud V1
Runtime Environment
The name of the runtime environment where you want to run tasks.
Specify a Secure Agent, Hosted Agent, or serverless runtime environment.
ERP Endpoint URL
The endpoint URL of the Oracle Financials application server.
Note: To validate the ERP Endpoint URL, type the following URL in the web browser:
<ERP Endpoint URL>/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL
The URL should open a WSDL file that indicates that the ERP Endpoint URL is valid.
Authentication Type
The type of user authentication to connect to the Oracle Financials Cloud application.
Select Basic Authentication type.
Username
User name of the Oracle Financials Cloud account.
Password
Password for the Oracle Financials Cloud account.
IO Directory
The directory path where the schema files and data are stored. Store the schema files in the Secure Agent machine.
Click the Test button after you create an Oracle Financials Cloud V1 connection.
The Secure Agent creates following directories under the IO directory:
  • - Reader: The reader directory contains an Output sub-directory. The .csv file that you download from the Oracle Financials Cloud application is downloaded as a ZIP file and stored in the following directory: IO Directory\Reader\Output
  • Note: You can override the directory path where you download the .csv file in the Outbound_Output_Directory advanced property field.
  • - Writer: The writer directory contains Logs and Schema sub-directories. Place all the XLSM and CTL files after you download them in the following directory: IO Directory\Writer\Schema
  • - Temp: The temp directory contains a WorkingDirectory sub-directory that contains the staging files.

Encryption mode

To access Oracle Financials Cloud, configure PGPUNSIGNED and PGPSIGNED encryption modes. Default is None.
Select the required encryption mode to encrypt or decrypt the data when you run a mapping to write data to a target.

Related links