Amit Sahasrabudhe

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

by

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

by

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.

Oracle PBCS February Updates

by

Per Oracle’s RCD for February 2016, the Oracle PBCS release will have the following updates: New Financial Reporting Web Studio: The March update of the service will include the new Financial Reporting Web Studio. This release includes about 85% of the functionality currently available in the Windows Financial Reporting Studio. The existing Windows Financial Reporting Studio will still be available. Because the report definitions remain the same, you can edit existing reports using the Windows … Read More

Oracle PBCS EPM Automate utility fails when password contains ‘^’ or ‘!’ special character

by

On a recent PBCS project, I happened to run into an issue when using EPM Automate available with PBCS version 16.01.49. My EPM Automate batch failed, returning an’ EPMAT-9: Invalid credentials’ error. The same credentials worked fine when logging in PBCS Workspace. After a few iterations playing around with passwords with special characters, I found out that EPM Automate fails when the password contains ‘^’ or ‘!’ special character. It works fine with other special … Read More

Setting up Valid Intersections in Oracle PBCS

by

If you have been implementing on-premise Hyperion Planning applications, you would have a missed a very good feature, that of putting in a rule to mark certain member intersections as valid combinations for data entry. Oracle has provided this feature in Oracle PBCS called as Valid Intersections. However this feature is limited to the ‘Simplified’ interface within Oracle PBCS. After valid intersections are defined, cells containing invalid data are made read-only. On a recent PBCS … Read More

Quick Tip – Login format for Financial Reporting Studio on Oracle PBCS

by

The login format for Financial Reporting Studio on Oracle PBCS is slightly different compared to the on-premise one. Here is the format: User Name is in identitydomain.userid format. For example, if the identity domain is usxyzcorp and user id is admin@xyzcorp.com then the user id should be entered as usxyzcorp.admin@xyzcorp.com If the service instance URL is https://usxyzcorp.pbcs.us1.oraclecloud.com/workspace, you should use the following server URL format: https://usxyzcorp.pbcs.us2.oraclecloud.com in FR Studio.

Using Smart Push to synchronize plan types in Oracle PBCS

by

Oracle PBCS offers a feature called Smart Push that allows you to push data i.e. synchronize data between plan types when a form is saved. For example, you can setup Smart Push so that data from the BSO plan type is pushed to the ASO plan type whenever a form is saved thus ensuring that the ASO reporting plan type is always consistent with the BSO plan type. Please note that by default only the … Read More

Oracle PBCS September Updates

by

What’s new in Oracle PBCS September Updates : Delay in deprecating Standard Interface – Oracle had previously announced that the Simplified Interface will become the standard interface starting with the November release. This transition will be delayed to allow more adoption of the simplified interface by customers Removal of Internet Explorer 9 Support – The cloud service will work with IE9. However, Oracle will not fix any Internet Explorer 9 specific issues Smartview 11.1.2.5.500 – … Read More

How to fix Calc Manager Business Rule error: Business Rule execution time has exceeded the maximum configured wait time. Business Rule will now be executed in the background.

by

By default, Business rules wait until 3 minutes (180000 milliseconds) before moving the execution to the background. When the wait time threshold is reached the user gets the following warning/error message: Business Rule execution time has exceeded the maximum configured wait time. Business Rule will now be executed in the background. To check Business Rule execution status, open the Job Console Page. This is inconvenient especially when users do not get to know if a … Read More

Oracle PBCS Automation Using EPM Automate and File Transfer Utility EPMCopy.exe

by

Oracle PBCS offers two utilities for automating tasks for PBCS. EPM Automate utility is used for uploading data or metadata files to the PBCS inbox folder, loading data to PBCS and refreshing the planning database. The File Transfer Utility EPMCopy.exe is more geared towards uploading a file to data management, running data management rules etc. The following sections describe each utility in detail. This post assumes the reader is familiar with the data load requirements … Read More