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

Planning Member Formula Editor does not work after applying PSU 11.1.2.4.002

by

We applied Planning PSU 11.1.2.4.002 to fix a SmartView bug we had encountered during development. PSU 11.1.2.4.002 did not resolve the issue, however we also noticed that after applying PSU 11.2.2.4.002 the Planning Formula editor did not work. The page was stuck at the message ‘Loading Member Formula Editor..’ Planning was rolled back to PSU 11.1.2.4.001 so that the Planning member formula editor can be used.  We were using Internet Explore 9, however looks like … Read More

Access Control Report in Oracle EPM 11.1.2.4 Shared Services returns a 403 Forbidden error

by

I usually run access control reports for Planning application through Shared Services by right clicking the planning application and selecting ‘Access Control Report’. However on a recent EPM project working on version 11.1.2.4 when I attempted to run the report, I got a Error 403 Forbidden error. More research led me to Doc ID 2039157.1 on Oracle Support. The access control report feature in Shared Services has been discontinued from EPM v 11.1.2.4. You will … Read More

Maximum number of rows exceeded errror in Smartview

by

When using Smartview on Essbase, you may get a maximum number of rows exceeded error specifying a number for the rows exceeded. This number is the one specified in the Oracle Provider Services maximum number of rows setting. The default setting is 5000 rows. When the Smartview query result exceeds 5000 rows (or the number specified in the Provider Services settings) , you get an error which looks like: Essbase Error (1020011): Maximum number of … Read More

Form Formula in Planning 11.1.2.4 displays as #No ACCESS in Smartview for a non-admin user

by

On a recent Planning 11.1.2.4 implementation we encountered an issue where a formula in a Planning form displayed #No Access in Smartview when accessed by non-admin users. When we logged in as an admin, the formula worked fine. The same formula displayed correctly when accessed through the Planning web. Planning Patch Set Update (PSU): 11.1.2.4.002 did not resolve this issue either. We raised an SR with Oracle and after a few development iterations; Oracle confirmed … 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

New Features in Upcoming Oracle PBCS August Release v15.08

by

Given below are brief details of some of the new features/updates in Oracle Budgeting and Planning Cloud Service Oracle PBCS August Release v15.08 Announcements: New Financial Reporting Studio Release v 11.1.2.4.400. You would need to uninstall the current version and then install the new release. New Version of EPM Automate Utility – This version supports password encryption and file uploads to Data Management folders. New SmartView Version Release v 11.1.2.5.500. Support for Internet Explorer in … Read More