EPM SSO Configuration - IDP metadata File and Setting Attributes

 

EPM Cloud supports only Service Provider (SP) initiated SSO; it does not support Identity Provider (IdP) initiated SSO.

Reference : https://docs.oracle.com/en/cloud/get-started/subscriptions-cloud/csimg/configuring-oracle-cloud-service-provider.html

 

1. SSO PROTOCOL : Available are HTTP POST, HTTP Artifact - ___________________
2. User Identifier : Available are User ID, User Email Address - _____________________
3. Contained in : _________ (If the User Identifier value is the user ID, then the contained in field must be the SAML attribute and you must specify the name of the SAML attribute for the contained in field such as SamAccountName in the case of Microsoft Active Directory Federation Services. If it is selected as Email Address then the contained in will be Name ID by default)
4. Provider Metadata : Users can export the provider metadata file by default will be sha2.0 we can leverage to get sha256 methodology as well from oracle support, Partner Active Directory admin team has to import that file into MSAD and provide us back the “Federation.xml” file.
5. This Federation file will be imported in oracle my services for further setup and configuration.

Configuring SSO (Single Sign On) : From Cloud ADFS server to Oracle EPM applications (Old generation)

 

Login to my services console and click on Navigate icon>Users

Click on SSO configuration

Under - Configure your Identity Provider Information - click on EXPORT METADATA

Create an SR with oracle if you require sha256 metadata file

If you require sha2.0 file you can download directly using the download option

Provide the exported metadata file to Oracle 

Get the modified "sha256 methodology" file from Oracle (Get the requirement from MSAD / AD team)

Submit the file to MSAD team

And get the modified Federation file from MSAD team

Then import the file to my-services in Configure SSO tab

Click on EDIT

And upload the file provided by MSAD team

Click on TEST SSO

In the next screen click on START SSO

It will redirect to a page to confirm the connection to MSAD is successful

Click on ENABLE SSO 

The SSO will be configured 

How to bring specific URL`s as Shared connection in Excel smartview

Requirement 

There are two URL`s which needs to be used and connected  as shared connection in excel smartview.

Users don`t have to enter the URL manually when they want to connect to that environment.

Rather they want an option where if they click on Shared connection and click on the drop down it should list those two required URL`s

Create a XML file in the below format, Save and name that file as "SharedConnection"

<?xml version="1.0" encoding="UTF-8"?>

<res_GetProvisionedDataSources>

<Product id="HP" name="name" displayVersion="version">

<Server name="ENVIRONMENT 1" context="https://<URL>/SmartView"></Server>

</Product>

<Product id="HP1" name="name" displayVersion="version">

<Server name="ENVIRONMENT 2" context="https://<URL>/SmartView"></Server>

</Product>

</res_GetProvisionedDataSources>

Save the file to the location where smartview is installed "C:\Oracle"

Then Close Excel and reopen - You will find those two URL as shown below 

Configuring SSO : Other sources with Oracle (Oracle Fusion General Ledger)

 Quick links

OPC IDP File Gneration  -  

https://<POD NAME>.login.<DC>.oraclecloud.com/fed/IDP/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

Eg : 

https://EGUP-DEV5.login.us2.oraclecloud.com/fed/idp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

OCI SP File Generation  -  

https://login-<POD Name>-saasfaprod1.fa.ocs.oraclecloud.com/fed/sp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

Eg  :  

https://login-esax-test-saasfaprod1.fa.ocs.oraclecloud.com/fed/idp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

OCI IDP File Generation  -  

https://login-<POD Name>-saasfaprod1.fa.ocs.oraclecloud.com/fed/idp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

Eg  :  

https://login-esax-test-saasfaprod1.fa.ocs.oraclecloud.com/fed/idp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

Oracle Cloud EPM : How to Export and Import Period mapping in Data management / Data exchange

NEW FEATURE

As we all know that using epm cloud data management we cannot export and import the period mapping, we need to manually add the periods in the Global mapping by referencing the prior period key and the period key and then define the application and source mapping accordingly.

But now the "DATA EXCHANGE" feature in Oracle EPM Cloud FCCS / PBCS / EPBCS has an option to add periods using excel. 

We can export the current mapping and then we can add our required mapping and then import the file back to data exchange which in turn gets updated to the Global mapping in data management.

STEPS

Go to Navigate > Data exchange 

Click on Actions > Period Mapping 

    Here you can import, export, delete period mappings 

Oracle EPM Cloud Data Management : How to define a Sub-String in Import format

 Requirement

        From a source dimension (Ex. Cost center), during the import to data load workbench, we need only the values starting from 5th position, and 6 characters from that. Rest all we need to ignore during import.

Example : CCWER500047TY - this is a cost center member
                    I need only 500047 to be imported to data load workbench

Solution

    In the import format use the expression shown below 

                        substr(UD2, 5, 6)

Oracle EPM Cloud - Data Management : How to use special characters, Prefix/Suffix, replace characters using Multi-Dimensional mapping

Source

Map only specific entities (IND, EUR, JAP)

Cost center* dimension begins with (03****) 

Target

Map to target Cost center dimension - 

1. Add a prefix CC 
2. Members begins with 03**** in source should map to 04**** in target

Example

Source 

Entity : IND, EUR, JAP 

Cost Center : 03MCHJ, 03JIUY, 03KIJY

Target

Cost Center : CC04MCHJ, CC04JIUY, CC04KIJY

SOLUTION

In the Target value define     #FORMAT("CC04##????")