Connect to Oracle Financials Cloud

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
Use secret Vault	Stores sensitive credentials for this connection in the secrets manager that is configured for your organization. This property appears only if secrets manager is set up for your organization. This property is not supported by Data Ingestion and Replication. When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured. For information about how to configure and use a secrets manager, see Secrets manager configuration.
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

PGPSIGNED

Encrypts and signs the data using the PGP encryption method.

The following table describes the basic connection properties for PGP encryption method:

Property	Description
PassPhrase	The passphrase to encrypt the private key.
PrivateKey Path	The file path of the private key. Store the private key on the Secure Agent machine. Provide the private key corresponding to the public key that you uploaded in the Oracle Financials Cloud application.
ERP Public Key Path	The file path of the fusion public key. Store the fusion public key on the Secure Agent machine. You can use the file path of the fusion public key when you run a mapping to write data to a target. Raise a service request to Oracle Financials Cloud to get the fusion public key. For more information about the fusion public key, see 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 provided when you uploaded the public key in the Oracle Financials application.

PGPUNSIGNED

Encrypts data using the PGP encryption method. Use the same encryption key that you configured in the Oracle Financials Cloud application.

The following table describes the basic connection properties for PGP encryption method to read from Oracle Financials Cloud:

Property	Description
PassPhrase	The passphrase to encrypt the private key.
PrivateKey Path	The file path of the private key. Store the private key on the Secure Agent machine. Provide the private key corresponding to the public key that you uploaded in the Oracle Financials Cloud application.
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.

The following table describes the basic connection properties for PGP encryption method to write to Oracle Financials Cloud:

Property	Description
PassPhrase	The passphrase to encrypt the private key.
ERP Public Key Path	The file path of the fusion public key. Store the fusion public key on the Secure Agent machine. You can use the file path of the fusion public key when you run a mapping to write data to a target. Raise a service request with Oracle Financials Cloud to get the fusion public key. For more information about the fusion public key, see 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.

Connect to Oracle Financials Cloud

Before you begin

Connection details

Encryption mode

PGPSIGNED

PGPUNSIGNED

Related links