With the Oracle® ARCS connector, you can use commands in a chain to interact with Oracle Account Reconciliation® Cloud Service (ARCS). For example, with this connector, you can:
- Download, upload, or delete files in Oracle ARCS
- Import transactions, balances, and mappings
- Convert comma-separated values (CSV) files to the native Oracle Enterprise Performance Management® (EPM) planning file format, or vice versa
- Run data management batches, reports, and rules
To secure the connection to Oracle ARCS, the connector uses basic username and password authentication. To set up the connector, you'll need:
- A designated integration user set up in Oracle ARCS for the connector
- The integration user's authentication credentials
- The application to connect to in Oracle ARCS
- The service name, identity domain, and data center region of the ARCS environment to connect to
Note: The service name, identity domain, and data center region appear in the environment's URL, such as
Set Up the Oracle ARCS Connector
- From Chains, click Connections and Add Connection .
- Under BizApp Connection, select Oracle ARCS and the default CloudRunner.
- Under Basic Info, enter a unique name and description to help identify the connection.
- Under Properties, enter the connector's details:
Property Details Service Name Enter the service name of the Oracle ARCS environment to connect to. In the URL, the service name is the auto-generated string that immediately follows
Note: To distinguish test and production environments, Oracle appends
-testfor service names in test environments.
Domain Name Enter the name of the Oracle ARCS environment's identity domain. In the URL, the identity domain is the auto-generated string that follows the dash
-after the service name.
Data Center Enter the data center region that hosts the Oracle ARCS environment. In the URL, the data center region appears immediately before
oraclecloud.com, such as
User Name Enter the username of the connector's Oracle ARCS integration user. Password Enter the password for the User Name property. Application Name Enter the name of the application in Oracle ARCS to connect to.
Note: All sensitive credentials are automatically encrypted and stored at Advanced Encryption Standard (AES)-256 encryption.
- Select the environments to use with the connection, and click Save.
- To test the connection, create and run a chain with the connector's List Files command, and verify it returns a valid output.
If the connection to Oracle ARCS fails:
- Verify the authentication credentials of the connector's integration user.
- Check the service name, identity domain, and data center region from the Oracle ARCS URL.
- Check the name of the Oracle ARCS application to connect to.