Connections > Connection properties > Oracle Financials Cloud V1 connections properties
  

Oracle Financials Cloud V1 connections properties

The following table describes the Oracle Financials Cloud V1 connection properties:
Connection Property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
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 which indicates that the ERP Endpoint URL is valid.
Authentication Type
The type of user authentication to connect 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. You must store the schema files in the machine on which the Secure Agent is installed.
You must 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 .cvs 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
The encryption type you want to use to encrypt or decrypt the data when you run a mapping to write data to a target. Select one of the following options:
NONE
The data is not encrypted.
PGPUNSIGNED
Select this option to encrypt the data when you run a mapping to write data to a target 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 when you run a mapping to write data to a target using the PGP encryption method.
PassPhrase
The passphrase that you use to encrypt the private key.
Note: Use this property when you use the PGPSigned encryption method.
PrivateKey Path
The file path of the private key. You must store the private key in the machine on which 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.
ERP Public Key Path
The file path of the fusion public key. You must store the fusion public key in the machine on which the Secure Agent is installed. You can use the file path of the fusion public key when you run a mapping to write data to a target.
You must raise a service request to Oracle Financials Cloud to retrieve the fusion public key.
For more information about the fusion public key, refer the Oracle documentation.
ERP Private Key Alias Name
The fusion key alias name that you provided when you generated the private-public key pair in the Oracle Financials application. You can use the fusion key alias name 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 provided when you uploaded the public key in the Oracle Financials application.
Note: Use this property when you use the PGPSigned encryption method.