Amit Sahasrabudhe

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

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

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

Oracle PBCS December 2016 release updates

by

Here is a quick update on Oracle PBCS December 2016 proposed updates. More details can be found on Oracle’s release control document New REST API’s You can now use REST APIs to get and set substitution variables. Access logs that list user activity You can now download a daily access log, a Comma Separated Value (CSV) file, which provides detailed information on the resources that users accessed, duration of user activity, the IP addresses from … Read More

Setting up FDMEE Source Accounting Entity Group to extract data from multiple accounting entities in a single data load rule

by

An accounting entity group is a grouping of multiple accounting entities and is used to extract data from multiple source accounting entities using a single data load rule. The snapshots and content used in this post relate to Oracle EBS. The same concept would apply when using other source systems or ERP’s. On a recent project, I came across a requirement to load multiple accounting entities. The source system was Oracle EBS and FDMEE had … Read More

Oracle PBCS June release updates

by

Per Oracle’s RCD for June 2016, the Oracle PBCS release is expected to have the following updates. Some of these updates are a huge improvement over the current version. New User Interface: A new feature that allows current customers to switch the default user interface for all end users to the improved Simplified Interface. Smart View release 11.1.2.5.600: This release contains new features such as support for attribute calculation across planning dimensions, attribute based dynamic … Read More