Tuesday, August 9, 2022

EPM CLOUD - FCCS / EPBCS / PBCS - NEW SAVE AS OPTION FOR JOBS

The new "Save As" option for jobs enables you to create a duplicate of an existing job, and then update it to avoid starting over making selections each time you create a new job.

"Save As" is supported for the Export Data, Import Data, Export Metadata, Import Metadata, Refresh Database, Clear Cube, and Import Exchange Rates job types.

To duplicate a job, click Application, then Overview, click Actions, and then select one of the following actions:

Export Data

Import Data

Export Metadata

Import Metadata

Refresh Database

Clear Cube

Import Exchange Rates

On the listing page, click the ellipses icon (...) in the Actions column next to the job that you want to duplicate. 

Click Save As, enter a name for the new job, and then click OK. 

After the duplicate job is created, you can then open the job and update it. 

The error file for the duplicate job will automatically use the new job name as a prefix.

 

DISPLAY MEMBER NAMES AND ALIASES IN SEPARATE COLUMNS IN SMART VIEW AD HOC GRIDS

A new Member display option in Oracle Smart View for Office, Member Name and Alias, allows you to display both the member names and their aliases in separate columns on row dimensions in ad hoc grids.

The Member Name and Alias display option allows users to see the member name and the alias side by side during adhoc zoom interactions within the grid. 


In Smart View, place an ad hoc grid on a worksheet. You may have more than one row dimension in the grid.

In the Smart View ribbon, select Options.

In the Member Options tab, Member Name Display, select Member Name and Alias, then click OK.

In either the Smart View ribbon or the provider Ad Hoc ribbon, click Refresh.

For row members, both member names and their corresponding aliases are displayed in the ad hoc grid.


STEPS TO ENABLE

To enable the Member Name and Alias option for Smart View users working with ad hoc grids, the business process application option, Smart View Ad Hoc Behavior, must be set to Standard.

All new and recreated applications are automatically set to Standard.

For existing and migrated applications, to set the application option, Smart View Ad Hoc Behavior, to Standard:


Click Application, and then click Settings.

For the Smart View Ad Hoc Behavior option, select Standard.

Click Save.


NOTE

The Member Name and Alias option is supported with:

Standard-mode applications only

Smart View 22.100 and later

Thursday, August 4, 2022

ORACLE NETSUITE – ORACLE EPM CLOUD Integration

 
NetSuite Adapter
https://docs.oracle.com/middleware/12213/adapter-netsuite/using-netsuite-adapter/GUID-C7EBFF8A-13CF-4F5A-ABAE-5032E9A31386.htm


Oracle NetSuite Adapter Capabilities
https://docs.oracle.com/en/cloud/paas/integration-cloud/netsuite-adapter/oracle-netsuite-adapter-capabilities.html


Integrating Oracle NetSuite
https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/erpia/netsuite_intro_100xbda13a64.html


Using the Oracle NetSuite Adapter with Oracle Integration
https://docs.oracle.com/en/cloud/paas/integration-cloud/netsuite-adapter/preface.html#GUID-7E890AB2-AA82-4D33-82FC-0080971DB08B


Getting Started with the Oracle NetSuite Adapter
https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icsns/getting-started-oracle-netsuite-adapter.html


Using the Oracle NetSuite Adapter with Oracle Integration
https://docs.oracle.com/en/cloud/paas/integration-cloud/netsuite-adapter/using-oracle-netsuite-adapter-oracle-integration.pdf


Youtube

https://www.youtube.com/embed/vX3RGihxXO0?rel=0&autoplay=1

Other Links
https://system.eu2.netsuite.com/pages/customerlogin.jsp
https://brovanture.com/connecting-two-clouds-netsuite-to-oracle-pbcs-cloud-to-cloud-integration/
https://netsuitehub.com/forums/topic/saved-search-for-ytd-sales/

Oracle EPM FCCS - ICP Eliminations - points to remember

In preparing consolidated financial statements, we need to eliminate transactions between companies or entities included in the group for consolidation and only report results arising out of transactions with third parties. This is achieved through intercompany elimination.

To perform Intercompany Elimination in Oracle Financial Consolidation and Close Cloud Service (FCCS) below pre-requsites should be met,

Prerequisites to perform intercompany eliminations in Oracle Financial Consolidation and Close Cloud Service (FCCS)

1. Intercompany feature should be enabled while creating the application.
2. Account must be set as an Intercompany account.
3. The account must have a Plug account assigned to it.
4. Entity must be set as an Intercompany entity.
5. Run a consolidation.
6. Intercompany transactions are eliminated automatically after running consolidation in Oracle Financial Consolidation and Close Cloud Service (FCCS).

How to extract Alias details using EPM Cloud Data management in EPBCS/PBCS/FCCS Applications

Now it is possible to extract a member of a dimension and its Alias information using EPM Cloud Data management in EPBCS/PBCS/FCCS Applications.

Follow the process to use the option > Data Export to File, A target application gets created as Data Target type and complete the setup process,

For extracting the Alias - which is part of metadata use the below SQL command to extract the details 

Like Mapping -- * to #SQL 

(

SELECT DISTINCT ALIAS FROM AIF_TARGET_APPL_MEMBERS WHERE UDX = MEMBER_NAME 

)

--- Note: Replace UDX with the actual UD number from the target application dimension class.

Wednesday, June 22, 2022

Unable to load Dates to EPBCS application using Oracle EPM Cloud Data Management

Issue Description 

There might be a scenario where you are trying to load Dates into EPBCS application and you end up with dates not getting loaded, and for the dates column you get a Blank value.

But in Data load workbench it shows that the data is loaded successfully.

The Import and Export process also shows success.

Root Cause

The Format for the column which holds the Date information is not correct.

Solution

Data management supports loading date in two formats

MM-DD-YYYY     &      DD-MM-YYYY

Based on the date format set in your EPBCS application the date format can be selected

Most preferably MM-DD-YYYY

So while designing the source file which is a CSV file, ensure you select the entire Date column

Right Click > Format Cells > Select Custom > and in the TYPE: section enter MM-DD-YYYY  or DD-MM-YYYY based on what is defined in your application.

Note: 

Ensure the value entered in the Type section should be in CAPS, Data management will not throw an error if you use Lower case, but the Date information wont get loaded to the EPBCS application.

Monday, April 25, 2022

Cloning Applications between environments using Clone Environment option in Oracle EPM Cloud

 Cloning Applications between environments using Clone Environment option in Oracle EPM Cloud  

Click on Navigate > Under Tools section > Click on Clone Environment  


Enter the details of your Target environment where you need to clone this application

Target environment URL, Target environment Username, Target environment Password

Roles Required

You must have either a Service Administrator or a Service Administrator with Identity Domain Administrator predefined role.

For Oracle Cloud Classic to OCI cloning, you must sign in as a Service Administrator, who also has the Identity Domain Administrator predefined role to ensure that users and their roles are cloned to the OCI environment.


For cloning artifacts, you can choose the options as per your requirements



  1. Optional: Select the Users and Predefined Roles check box to clone users and their predefined role assignments.

If you are performing an Oracle Cloud Classic to OCI migration, you must select this check box.

  1. Optional: for environments other than Oracle Enterprise Data Management Cloud and Narrative Reporting only: Deselect the Data Management check box if you do not want to clone Data Management records. Cloning of Data Management records may take a long time if the staging tables contain a very large number of records.

Clone Data Management records only if both the source and target environments are on the same monthly update or the target environment is one update newer than the source environment. For example, you can clone 22.01 Data Management records to another 22.01 environment or to a 22.02 environment only.

  1. Optional: for Planning, Planning Modules, Free Form, Financial Consolidation and Close, and Tax Reporting only: Deselect the Job Console check box if you do not want to clone Job Console records.
  2. Optional: for Planning, Planning Modules, and Free Form only: Deselect the Application Audit check box if you do not want to clone application audit records.

Note: Application audit data of Financial Consolidation and Close, and Tax Reporting is, by default, included in the snapshot.

  1. Optional: Select the Stored Snapshots and Files check box if you want to clone the contents of inbox and outbox, and stored snapshots. This process may take a long time depending on the number and size of stored snapshots and files in inbox and outbox.
  2. Click Clone to initiate the process.

Tasks to Perform After Cloning Environments

1.       Daily Maintenance Start Time

The daily maintenance start time of the target environment is automatically reset to that of the source environment from which the snapshot was cloned, ensure to change the time in the target environment accordingly.

2.       Update EPM Automate Scripts

If you have written any script to perform an activity, ensure the script is updated with the target environment URL with identity domain name updated.

Also, if you are using native accounts then ensure password is updated In the scripts.

3.       Smart View URLs

Modify the public and private connection Smart View URLs so that they point to the cloned environment. Also, update connection URLS as needed.

4.       Integrated Business Process

a.       Single Sign On

If you are moving multiple instances in an integrated business process to a new domain, SSO between instances will not work until all instances are migrated.

If you had setup SSO to authenticate the users and the migration resulted in a change in the identity domain being used, for example, after Oracle Cloud Classic to OCI migration, you must reconfigure SSO.

While cloning between same domains SSO need not be reconfigured, instead update the PROD application in the list.

b.      Updating Integrations and Connections details

There are places where you need to update the connection details, like updating data management target application connections, source system connections, ensure the URL`s, Usernames and password are updated accordingly.


Thursday, March 10, 2022

EPM Cloud Data management / FDMEE / Troubleshooting steps

 


Required Roles for Loading Data

If you have an issue with loading data to Oracle Enterprise Performance Management Cloud using Data Integration, Data Management, EPM Automate or REST APIs, make sure that the user loading the data has one of the following roles:

  • Service Administrator predefined role
  • Power User predefined role and Run Integration application role

How to trace issues  using ERROR log

  • The process details log in data management is the key log to trace any issues
  • Ensure the Log level is set to 5 under System Settings tab > select Profile type to ALL
  • Open the process details log in Notepad / Notepad++
  • Find (Ctrl+F) for the key word "error"

How to determine the load status from DATA LOAD  WORKBENCH

In the Workflow tab > Data load workbench > there are four icons (fish icon) > Import , Validate , Export , Check

If the Import fish is grey, then the import step is failed the source system level 

  • Ensure the source system connection is setup correctly 
  • Ensure the file name is defined correctly in the data load rule 
  • Ensure the data is available in the source combination in which it is extracting 
  • Ensure the source filters are defined properly 

If the Import fish is Orange and Validate fish is Grey

  • Go the Data load workbench > click on Validation errors 
  • You will find the details of the missing mapping members 
  • Ensure the mappings are defined correctly for those members and re-run the validate step

If the Import fish is Green, Validate fish is Green but the Export fish is Grey

  • Ensure the connection is available and the properties of the target system is defined properly for the target system
  • In the error log you will find an error code "Error: 3303", "Error: 3335" - it describes that the member is not available in the target 
  • In those scenarios we need to manually create the members in the target system if it valid

Known error codes and solution

3303 Member not found in database.

3304 Insufficient access to store data.

3333 Bad data value supplied.

3335 Record rejected because of duplicate member names.

3336 Member/Data unknown.

3337 Record rejected because of dimension conflicts with Header Name


How to Verify that Microsoft Active Directory Federation Service is Working

 

1.  Access the Microsoft Active Directory Federation Service Sign In page: https://adfs.example.com/adfs/ls/IdpInitiatedSignOnPage (replace adfs.example.com with your Microsoft Active Directory Federation Service hostname)

2.  If required, select Sign in to this site and click Sign In.

3.  Enter the Microsoft Active Directory credentials for a user that exists on both Microsoft Active Directory Federation Service and Oracle Identity Cloud Service (in this example, csaladna@example.com) and click Sign In.

  1. Confirm that the message You are signed in is displayed.

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 

Tuesday, March 8, 2022

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 






Thursday, March 3, 2022

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



Tuesday, February 22, 2022

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##????")




Other posts

How is the data size calculated for a EPM Cloud service instance?

The total size of data used by your EPM Cloud service instance is the sum of the following: Application data stored in Essbase Artifact...