/
Configuring Cloud Account for Oracle Transactional BI

Configuring Cloud Account for Oracle Transactional BI

Most OAC plugin operations require the FDOTBI_CLOUD_ACCOUNT_CODE target property since FlexDeploy 9.0.0.4. For more details, refer to the Configuring Cloud Accounts section. If upgrading from FlexDeploy 9.0.0.3 or lower, OracleSaaS cloud account will be automatically created from target properties (URL, Username, Password). Oracle Transactional BI and Oracle SaaS FSM Plugin share same cloud account.

Use Test Connection option on Integration instance to validate your configurations.

image-20250301-140537.png

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

Oracle SaaS URL

FDORACLESAASACCT_INSTANCE_URL

Yes

URL of the Oracle SaaS environment.

e.g. https://servername.fa.us2.oraclecloud.com

Auth Type

FDORACLESAASACCT_AUTHTYPE

Yes

Authentication method for connecting to Oracle SaaS environment. Additional properties may be required depending on selection.

Options: BasicAuth, OAuthResourceOwner, OAuthJWTAssertion

Username

FDORACLESAASACCT_USERNAME

Yes

The username for your Oracle environment. 

Password

FDORACLESAASACCT_PASSWORD

Conditional

The password. Required for BasicAuth and OAuthResourceOwner.

Oracle Identity Cloud Service URL

FDORACLESAASACCT_IDENTITY_BASE_URI

Conditional

 The Oracle Identity Cloud Service URL (IDCS).

e.g. https://idcs-1a2bc3de.identity.oraclecloud.com

Required for OAuthResourceOwner and OAuthJWTAssertion

Client Id

FDORACLESAASACCT_CLIENT_ID

Conditional

Client Id of OAuth application in Oracle Identity service. See more details below.

Required for OAuthResourceOwner and OAuthJWTAssertion

Client Secret

FDORACLESAASACCT_CLIENT_SECRET

Conditional

Client Secret of OAuth application in Oracle Identity service. See more details below.

Required for OAuthResourceOwner and OAuthJWTAssertion

Client Scope

FDORACLESAASACCT_SCOPE

Conditional

Client Scope. See more details below.

e.g. https://smpqp3ct4ogsgjzdkgsztq2ovgcylnga.analytics.ocp.oraclecloud.comurn:opc:resource:consumer::all

Required for OAuthResourceOwner and OAuthJWTAssertion

Private Key

FDORACLESAASACCT_PRIVATE_KEY

Conditional

Private Key to use for JWT Assertion. See more details below.

Required for OAuthJWTAssertion

See Private Key type Credential for information on how to generate Private Key with Certificate and upload to FlexDeploy credential.

Certificate

FDORACLESAASACCT_CERTIFICATE

Conditional

Certificate to use for JWT Assertion. See more details below.

Required for OAuthJWTAssertion

See Certificate type Credential for information on how to generate Private Key with Certificate and upload to FlexDeploy credential. Certificate also needs to be uploaded to Oracle Cloud, see more details below.

OAuth Configurations for Oracle Cloud

Related content

The following macros are not currently supported in the footer:
  • style