Unboxing Oracle EPBCS – Creating an EPBCS application

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

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

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

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.

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

Oracle PBCS December 2016 release updates

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

Using Planning Calc Manager Variables in Essbase Calculation script with SET RUNTIMESUBVARS command

On a recent project, I wanted to execute an Essbase Calc script with substitution variables set to accept values passed by Planning business rule run time prompts. In this specific case, I wanted a user to run a business rule in a planning application that would use the run time prompt values and pass on to a calculation script in a separate standalone Essbase database. I used a combination of CDF in business rule that … Read More

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

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

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

Quick Tip – Encrypt Oracle PBCS password using epm automate encrypt command

Epm Automate provides an encrypt command to encrypt Oracle PBCS password used in epm automate batch files. This can be very handy when using parameters files containing Oracle PBCS passwords. The syntax of the ‘encrypt’ command is: epmautomate encrypt password key <password file> Double click on the epmautomate.bat file found in C:\Oracle\EPM Automate\bin directory to start epm automate. At the command prompt you can type in epmautomate encrypt help to see information regarding the command. … Read More

Quick Tip – Launching Financial Reporting Web Studio from Oracle PBCS

Financial Reporting Web Studio is now available on Oracle PBCS Test Instances. This will be released on Production instances 2 weeks from now. Launch the Financial Reporting Web Studio from Oracle PBCS Workspace by navigating to Tools->Launch Reporting Web Studio. Please note that per Oracle release document, currently only a Service Administrator can save new report designs using this release of the Financial Reporting Web Studio.

Import Smart Lists into Oracle PBCS or Planning using a csv file

Here is an easy way to import Smart Lists in to Oracle PBCS or on premise Planning using a csv file. This has been tested on Oracle PBCS and Planning versions 11.1.2.3.500 and later. The first step would be to export the existing Smart Lists. When we do this we get the file format that we can modify and re-import. If you do not have any smart lists yet in your application, you can create … Read More