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

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

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

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

Planning Member Formula Editor does not work after applying PSU 11.1.2.4.002

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

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

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