Smartview

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

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.

by

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

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

Using the Oracle Smartview Planning Admin Extension to update Planning metadata

by

The Oracle Smartview Planning Admin Extension allows you to update Planning application (both Oracle PBCS and On-Premise Classic applications) metadata using Smartview. The SmartView Planning Admin Extension can be downloaded from within the Oracle EPM Workspace. Go to Tools->Install and select ‘Planning Admin Extension’. Download and install this utility. Once the utility is installed, connect to the Planning application using Smartview. Expand the Server and then the application (‘Vision’ in this case). You will notice … Read More

Smartview netRetryCount and netRetryInterval error

by

When querying databases with high dimensionality using Smartview, users may get the Smartview netRetryCount and netRetryInterval error. The exact text of the error is “The request timed out. Contact your administrator to increase netRetryCount and netRetryInterval” Smartview uses Internet Explorer query and time out settings for connections. Some queries take longer to execute and hence get a time out error. You need to update Internet Explorer registry settings to increase the time out thresholds. The … Read More