Best practices and performance tuning for using Hybrid BSO in EPBCS

by

I recently presented at ODTUG KSCOPE19 in Seattle. Thanks a ton to ODTUG content selection team for giving me this opportunity to present at such a great conference! I presented along with David DeLozier on Best Practices and Performance Tuning for using Hybrid BSO in EPBCS. I had a great audience with lots of questions being asked. Sincere thanks to Oracle’s Mark Rinaldi for attending this session and contributing to answer questions asked by the … Read More

Oracle Financials Cloud integration with Oracle Planning Cloud (PBCS) using Data Management

by

This post explains the process to setup Oracle Financials Cloud as a data source in Data Management and execute the initialization process. I encountered an error during the initialization process which I have given the details and resolution for it. Configure Cloud Financials as a Data Source in Data Management To add Oracle Financials Cloud as a data source, we need to create an user id in Oracle Financials Cloud with ‘General Accounting Manager’ responsibility … Read More

Oracle PBCS November 2018 release updates

by

The Oracle PBCS November 2018 update adds a few good features that you probably run into during your PBCS implementations. I have listed a few below. You can find Oracle’s November Updates release document here New EPM Automate Utility The new utility adds the following commands. These are particularly helpful when you want to perform automated security updates and have a source system that can provide you with security details via an extract file: addUsersToGroup: … Read More

Migrate on-premise Essbase applications to Oracle Analytic Cloud (OAC) using LCM and CLI utility

by

Oracle Analytic Cloud (OAC) Service provides a Life Cycle Management (LCM) utility that you can use to export on-premise applications and cubes and then import them to the cloud service with an utility called as OAC Essbase Command-Line Interface (CLI) These utilities are available to download from the cloud service on the Application home page in the Utilities section. Please note that both the utilities need the JDK 8 installed on the computer and JAVA_HOME … Read More

PBCS Bug Alert: LCM export contains planning security group xml file even if group has been deleted from Access Control

by

I was trying to automate a PBCS security update process where in I download existing security from PBCS, have the admin update specific groups xml files and then re-upload the security back to PBCS. The planning security download contains one xml file for each group that has been provisioned. The xml file contains the member level security that has been assigned to the group. After a clean up of unwanted groups, I noticed that the … Read More

Unboxing Oracle EPBCS – Creating an EPBCS application

by

I have been waiting to try out Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) and I finally got a chance to write about it. In this post we will create an EPBCS application with multi-currency enabled and go through the application defaults. When you login to your EPBCS pod for the first time, you are presented with the following screen: Click on ‘Start’ under Planning and Budgeting You are presented with 3 options: Standard … Read More

Essbase data loss and data shifting due to IMPLIED_SHARE setting

by

Per the Oracle technical reference for IMPLIED_SHARE the following steps must be performed any time the IMPLIED_SHARE setting is changed in essbase.cfg: Add IMPLIED_SHARE FALSE to essbase.cfg. Restart Essbase Server. Create a new application and database, with the IMPLIED_SHARE setting in place. Rebuild the outline, with the IMPLIED_SHARE setting in place. Reload the data. Run aggregation or calculation scripts. Restart the application. However, the technical reference does not say what would happen if the above … Read More

Financial Reporting Studio Related Content Error Number 2019

by

I encountered a FR Studio Related Content Error – ‘error number: 2019′ with error message: ‘Unable to connect to http://<servername>:8200/raframework/browse/listXML?sso_token=’ while attempting to add related content to a FR report. Specifically, this error occurred when I was attempting to create a related content connection by clicking on a folder in the add related content dialog box.   The issue was caused during the Financial Reporting configuration in which the FINANCIAL_REPORTING_LWA was set to port 8200 instead … Read More

Pass Planning Calc Manager variable run time prompt values to an Essbase Partition

by

I had a requirement to pass planning calc manager variable run time prompt values to an Essbase Partition to refresh a partition for a specific scenario and version. We know we can run a MaxL file from a planning business rule using CDF. Can we extend this further and pass on run time prompt values to the MaxL file as well so they can be used in a partition definition? Say for example that we … Read More

Planning Bug Alert: Data form column resizing does not work in Planning v11.1.2.4.005.08 when the columns contain more than one dimension.

by

Data form column resizing (using any of the options available) does not work in Planning v11.1.2.4.005.08 where data forms have more than one dimension in the columns. The width resets to the default value even after the column widths have been updated. This affects the form when opened in Workspace and Smartview. Oracle has identified this as a known bug and expected to be fixed in v11.1.2.4.006 Please note: The column does resize to ‘fit … Read More