Installation

• Update CXO to version 20.4.??? (or higher)

• Install Identity Provider

• Install Oracle EPM Cloud Adapter

  • Install pre-requisistes: .NET 5.0 runtime => FIND URL

  • Run installer

• Create IIS website for Web API

• Create Client in CXO Identity Provider

Identity Provider configuration

• 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

...

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

  • Oracle EPM configuration database

  • SSAS cube

• Configure connection string to configuration database in appsettings.json for CLI/WebApi

• Run database migration command on CLI: CXO.Adapter.OracleCloudEpm.Cli.exe migrate-database

• (While story for bootstrapping a source in the adapter is not yet done):

  • Create a source record in the Source table in the configuration database

  • Create default dimension mapping records in the Dimension Mappings table in the configuration database

...