Data Integration Connections > Connection properties > Oracle Financials Cloud connections properties
  

Oracle Financials Cloud connections properties

The following table describes the Oracle Financials Cloud connection properties:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
Authentication
Select Oracle Financials Cloud.
ERP Endpoint URL
The endpoint URL of ERP server of the Oracle Financials Cloud application.
Authentication Type
Select the authentication method that the connector must use to login to the Oracle Financials Cloud application.
You can 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 on the machine where the Secure Agent is installed.
You must click the Test button after you create an Oracle Financials Cloud 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 are 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. You must 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-directories that contains the staging files before loading.
Encryption Mode
Method you want to use to encrypt or decrypt the data based on the encryption method. Select one of the following options:
NONE
The data is not encrypted.
PGPUNSIGNED
Select this option to encrypt the data using the PGP encryption method.
You must use the same encryption key that you configured in the Oracle Financials Cloud application.
PGPSIGNED
Select this option to encrypt and sign the data using the PGP encryption method.
Note: Use this property when you run a mapping to write data to a target.
PassPhrase
Provide the passphrase that you use to encrypt the private key.
Note: Use this property when you use the PGPSigned encryption method and run a mapping to write data to a target.
PrivateKey Path
The file path where the private key is stored on the machine where the Secure Agent is installed.
You must provide the private key corresponding to the public key that you uploaded in Oracle Financials Cloud application.
Note: Use this property when you use the PGPSigned encryption method and run a mapping to write data to a target.
ERP Public Key Path
The file path where the fusion public key is stored on the machine where the Secure Agent is installed.
You must raise a service request to Oracle Financials Cloud to retrieve the fusion public key.
Note: Use this property when you run a mapping to write data to a target.
For more information about the fusion public key, refer the Oracle documentation.
ERP Private Key Alias Name
The fusion key alias name that you have generated with the Private-Public key pair in the Oracle Financials application.
Note: Use this property when you run a mapping to write data to a target.
Customer Public Key Alias Name
The customer public key alias name that you have uploaded with the public key in the Oracle Financials application.
Note: Use this property when you use the PGPSigned encryption method and run a mapping to write data to a target.