All About Connecting EPM Cloud Environments & Managing it via REST API!

Connections

Service Administrators can connect multiple EPM Cloud environments of the following types:

• Planning
• FreeForm
• Financial Consolidation and Close
• Tax Reporting
• Profitability and Cost Management
• Enterprise Profitability and Cost Management
• Account Reconciliation
• Narrative Reporting
• Oracle Strategic Workforce Planning Cloud

Once Service Administrators set up the connections, users who have access across EPM Cloud environments can navigate across them from a single access point with one login. 

Also, artifacts such as forms and dashboards, from across environments can be co-mingled within a cluster or within tabs on a card in navigation flows. Artifacts in the target environment are accessible based on the user's role.

All about Cross application data map in PBCS/EPBCS application!

Oracle released the cool feature of "CROSS APPLICATION SUPPORT FOR SMART PUSH IN DATA MAPS" in April 2022. 

Cross Application Smart Push feature enables customers with multiple applications to instantly move data, cell comments and supporting detail from a cube in a source application to a reporting or other cube in a remote target application

Applies to: Planning, Planning Modules (both as source and target), FreeForm (both as source and target),  Financial Consolidation and Close (target only), Tax Reporting (target only).

Fix - Capital data was not getting pushed into Financials!

We ran into an issue that the Capital data was not getting pushed to the Financials using the system-generated Data Map "Financial Statement Integration".  As this was working before but was not working since we added new accounts to the "Map Capital Account to FS"

There is no problem with data push and the members selected in the data map are set up correctly.

While running the Data Map it does give a warning stating as below,

[Data row: 4]

Skipping Smartlist(NumericToSmartList2Transformer (OCX_FinstatementAccounts)), Missing Label not defined.

One or more rows or columns was not converted due to missing members in the reporting application

Adding history Years in PBCS/EPBCS!

We all might have come across this request when we need to add a history year. The Years are populated using the parameters specified while creating the Planning application. 

It is pretty common where we created the Planning application starting from FY16 but later on the request was to add the FY15 too. 

Newly added users to PBCS/EPBCS cannot access the instance!

Newly added users to PBCS/EPBCS cannot access the instance!

You might have hit this issue that the recently added users to PBCS/EPBCS cannot access the instance, it gives an error message,

"User is not authorized on this service instance"