Installation

...

• Create new Generic Client

• Check “Allow Offline Access” checkbox

• Add Following Scopes:

  • User profile

  • User groups

• Add Redirect url(-s) in following format {OraclEPMAdapterUrl}/signin-oidc

• Add Post Logout Redirect URI’s in following format {OraclEPMAdapterUrl}/signin-oidc-auth

Warning: RedirectUri are case sensitive so it’s good practice to use lowercase in all urls.

...

CXO configuration and source creation

• Configure proper license key

  • Based on the client’s source, generate the right key using the License Key generator: Oracle EPM Planning / Oracle EPM Financial Consolidation and Close.
    Path to generator: \\cxo-fileserv\Data\Internal Tools\(not-released) LicenseKeyGenerator for B Licenses (with Oracle Cloud EPM adapter)

• Create a new source system in the SSM for the correct source type: Oracle EPM Planning / Oracle EPM Financial Consolidation and Close. This should create:

  • Fact database

  • SSAS cube

• Run configuration database creation command: e.g.
  .\CXO.Adapter.OracleCloudEpm.Cli.exe create-configuration-db server-name:cxo-dev-sql02 database-name:oracleEpmConfigTest authentication-type:Proprietary username:cxo password:somePassword
  Parameters:

  • server-name: name of the server on which the database should be created

  • database-name: name of the database to be created

  • authentication-type: windows / proprietary

  • username: SQL user name (if authentication-type == proprietary)

  • password: SQL user password (if authentication-type == proprietary)

...