Thursday, August 29, 2024

Oracle EPM update for ENTERPRISE PCM (EPCM)

MIGRATION ENHANCED TO EXPORT FAILED CALCULATION RUNS

In addition to exporting the details of the latest calculation run for each POV, any failed calculation runs will now be exported as well. 

That is, any calculation runs ending in a status other than "Completed" or "Completed With Warnings" will be included in the export.

UPGRADING TO HYBRID ESSBASE

Starting with this update, Oracle will begin the process of upgrading EPM Cloud environments that currently use a non-hybrid Essbase version to a hybrid Essbase version.

In this monthly update, the Profitability and Cost Management Cloud environments on a non-hybrid Essbase version are upgraded to a hybrid Essbase version. 

This upgrade will occur when the 24.05 updates are applied to your Profitability and Cost Management Cloud environments.

This upgrade affects only the Essbase version used in EPM Cloud; it does not affect the cube configuration of the application. For example, if the application is configured to use non-hybrid cubes, this update will not change it to use hybrid cubes. 

For detailed information on the use of Essbase in EPM Cloud, see About Essbase in EPM Cloud in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

To check whether your environment is on a hybrid or non-hybrid Essbase version, look at the value of Essbase Version supports Hybrid Block Storage Option in the Activity Report. 

If the value is Yes, it means that your environment is on hybrid Essbase version. 

If the value is No, it means that your environment is on a non-hybrid Essbase version.


Saturday, August 24, 2024

Oracle Release Updates for PLANNING EPBCS

CUSTOM TEMPLATE IN WORKFORCE NOW SUPPORTS MORE TEMPLATES FOR EASIER CUSTOMIZATION AND UPDATES

The Workforce custom template, OWP_Custom Template, now supports more templates.

The following additional templates now support OWP_Custom Template and will read any of the modifications you make to the custom script blocks:

OWP_Calculate Employee Compensation_Te

OWP_Process Loaded Data_T

OWP_Synchronize Defaults_T

OWP_Synchronize Definition_T

Additionally, OWP_Custom Template was updated to include three blank script blocks for each supported rule, instead of only two.

TIPS AND CONSIDERATIONS

If you've already modified OWP_Custom Template, it is not automatically updated to support the newly added third script block. If you have a use case that requires the third script block, restore the OWP_Custom Template to its original state so that it is updated, and then re-apply your modifications.

WORKFORCE BATCH RULES UPDATED TO IMPROVE PERFORMANCE

The performance of Workforce batch rules is improved.
WORKFORCE NOW LIMITS THE NUMBER OF EDITABLE ROWS IN MASS UPDATE FORMS

Workforce now limits the number of rows that can be edited at one time in the Mass Update forms. If you attempt to edit more rows than the limit, you'll receive an error message. If you see this message, you can reduce the number of rows you are editing and re-submit the form.
PREDICTIVE CASH FORECASTING SIMPLIFIES LOADING THE OPENING BALANCE

Predictive Cash Forecasting now supports an easier option for loading the opening balance, which supports use cases where you can load data for any historical periods, for example, if a new bank is added within the last 365 days.

Oracle Smart View for Office (MAC and Browser) update

SUBMIT NUMERIC ZERO AS REPLACEMENT FOR MISSING VALUES IN SMART VIEW (MAC AND BROWSER)

With the new Submit Zero option, you can choose to submit numeric zero values in place of #Missing label.

To enable submitting zeros as replacement for missing values:

Open the Smart View Option panel, and then go to the Data Options tab.

Under Replacement, enter #NumericZero in the #Missing/NoData Label field.

Select the Submit Zero check box.

ADD MORE DIMENSION ROWS IN FUNCTION BUILDER IN SMART VIEW (MAC AND BROWSER) 

For HsGetValue and HsSetValue functions, you can now add more dimension rows to the Members List in the Function Builder.

Earlier, the number of rows in a function were limited to 10. Now, you can add more rows and enter additional dimensions as per your requirement. Click the Add button to add a new row at the bottom of the Member List.

USER INTERFACE IMPROVEMENTS IN SMART VIEW (MAC AND BROWSER)

User interface improvements have been done in the Home panel and User Preferences panel in Smart View (Mac and Browser).

Right-click menu in Smart View Home panel: You can now right-click on forms, ad hoc grids, and other artifacts in the Smart View Home panel to open forms or ad hoc grids and launch other functionalities such as Job Console, Copy Version, Business Rules, Task List, Approvals, and User Preferences. These options are additionally available under the Action menu in the Smart View Home panel.

Variables tab in User Preferences panel: The associated dimension of a user variable is now seen up-front below the user variable name, instead of as a tool tip. Earlier, the user variable name acted as a button to open the Member Selector dialog, which was not intuitive. Now, a dedicated ellipses menu is introduced for opening the Member Selector dialog.

DISPLAY MEMBER NAMES AND ALIASES IN SEPARATE COLUMNS IN SMART VIEW (MAC AND BROWSER) AD HOC GRIDS

A new Member display option, Member Name and Alias, allows you to display both the member names and their aliases in separate columns on row dimensions in ad hoc grids.