Oracle EPM ARCS Account Reconciliation and Bank Statement Verification updates

Oracle Account Reconciliation update for New Bank Statement Verification option

NEW BANK STATEMENT VERIFICATION OPTION FOR ACCOUNT RECONCILIATION BAI STATEMENT BALANCES

- Account Reconciliation customers can now verify that the correct bank statement is being loaded using the Bank Statement Verification feature in Data integration. 

- When enabled, the system compares the current period expected ending balance to the ending balance provided in the BAI file being loaded.

- To calculate the current period expected ending balance, the system adds the net total of the current day transactions to the previous period ending balance for the Account ID.  

- If a difference is detected or any error is encountered, the transactions remain in the Workbench; however, they are not exported to transaction matching.

- Business Benefit: Bank Statement Verification enables you to identify duplicate transactions and duplicate data loads, missing balances or transactions, statements loaded in the incorrect order (that is, non-chronological order), and incorrect currency codes.

Oracle EPCM Update July 2024

NEW CALCULATION SEGMENTATION OPTION IN CUSTOM CALCULATION RULES

You can now apply calculation segmentation to custom calculation rules. If the Calculation Segmentation option is selected when defining a custom calculation rule target, rules are segmented into smaller rules to execute separately.

Business Benefit: Calculation segmentation enables the calculation to process rules with a very large data range, which would otherwise be too large for Essbase to process.

ADDITIONAL CALCULATION DETAILS AND MODEL SNAPSHOT DOCUMENTATION REPORT AVAILABLE ON THE CALCULATION CONTROL PAGE

The Properties pane on the Calculation Control page now shows whether all rules were included when a model was calculated. In addition, you can now generate a Model Snapshot Documentation report from the Actions menu on this page.

Business Benefit: Having the additional calculation information and quick access to the Model Documentation report on the Calculation Control page eliminates the need to go to the Calculation Analysis page to get this information.

MIGRATION BACKUP ENHANCED TO EXPORT FAILED CALCULATION RUNS FROM THE LAST SEVEN DAYS

When Migration Export runs in full backup mode, in addition to exporting the details of the latest calculation run for each POV, any failed calculation runs from the last seven days are now  exported as well. That is, any calculation runs from the last seven days that end in a status other than "Completed" or "Completed With Warnings" will be included in the export.

Business Benefit: Details of recent failed calculation runs are useful for Oracle Support when analyzing customer issues with calculation runs. Keeping them in the export also gives customers better context when their snapshots are restored.

Oracle EPM and REST API update June 2024

NEW ROLE ASSIGNMENT REPORT FOR GROUPS (V2) REST API

A new Role Assignment Report for Groups (v2) REST API is available that generates a Role Assignment Report of groups in the environment. 

The report lists the roles assigned to groups. It identifies the group’s name, description, type and assigned roles. 

The report can be created for a specific group or a role or a combination of groups and roles. The report includes:

Predefined roles (such as Service Administrator)

Application roles (such as Approvals - Assign Ownership, Approvals - Supervise, Approvals - Administer, and Approvals - Design Process)

VIEW THE CURRENT THEME FOR THE APPLICATION IN THE GET APPLICATIONS REST API

You can now use the Get Applications REST API to view the current theme for the application.

OPTION TO USE EXISTING USERS WITH THE SIMULATE CONCURRENT USAGE REST API

The Simulate Concurrent Usage REST API has been enhanced to use existing users in the identity domain while running concurrent operations on an environment. 

To use existing users in the identity domain with this REST API, you use test mode 4, which includes users defined in the users.csv file included in the input ZIP file. 

In this mode, the REST API does not create the simulated users.

EPM Cloud EPCM Calculation options for June 2024 update

 NEW CALCULATION SEGMENTATION OPTION IN CUSTOM CALCULATION RULES

- You can now apply calculation segmentation to custom calculation rules. 

- If the Calculation Segmentation option is selected when defining a custom calculation rule target, rules are segmented into smaller rules to execute separately.

- Business Benefit: Calculation segmentation enables the calculation to process rules with a very large data range, which would otherwise be too large for Essbase to process.

ADDITIONAL CALCULATION DETAILS AND MODEL SNAPSHOT DOCUMENTATION REPORT AVAILABLE ON THE CALCULATION CONTROL PAGE

- The Properties pane on the Calculation Control page now shows whether all rules were included when a model was calculated. In addition, you can now generate a Model Snapshot Documentation report from the Actions menu on this page.

- Business Benefit: Having the additional calculation information and quick access to the Model Documentation report on the Calculation Control page eliminates the need to go to the Calculation Analysis page to get this information.

MIGRATION BACKUP ENHANCED TO EXPORT FAILED CALCULATION RUNS FROM THE LAST SEVEN DAYS

- When Migration Export runs in full backup mode, in addition to exporting the details of the latest calculation run for each POV, any failed calculation runs from the last seven days are now  exported as well. 

- That is, any calculation runs from the last seven days that end in a status other than "Completed" or "Completed With Warnings" will be included in the export.

- Business Benefit: Details of recent failed calculation runs are useful for Oracle Support when analyzing customer issues with calculation runs. 

- Keeping them in the export also gives customers better context when their snapshots are restored.

NEW PARAMETER IN THE "UPDATE DIMENSIONS AS A JOB" REST API AND THE EPM AUTOMATE LOADDIMDATA COMMAND

- A new parameter is available in the "Update Dimensions as a Job" REST API and in the EPM Automate loadDimData command. 

- The opional acceptableDecreasePercentage specifies the percentage difference in member count that is allowed for the operation.

- Business Benefit: This parameter provides a mechanism to safeguard against data loss that can happen during a subsequent cube deployment if one or more dimensions did not get fully updated due to missing data in the input file