Installation
Update CXO to version 20.4.??? (or higher)
Install Identity Provider (Restart server after installing .NET core hosting bundle)
Install Oracle EPM Cloud Adapter
Install pre-requisites .NET 5.0 Hosting Bundle:
https://dotnet.microsoft.com/download/dotnet/5.0Run installer
Create IIS website for Oracle Epm (Application Pool should have "No Managed Code")
Create Client in CXO Identity Provider
...
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)
...