- Revision History
- Overview
- Feature Summary
- Profitability and Balance Sheet Management
-
- Cash Flow Engine
- Asset Liability Management
- Profitability Analytics
- Funds Transfer Pricing
-
- Account Audit UI
- Breakage Charge Calculation
- Data Verification
- Economic Value Cost Calculation
- Group Filters Integration in Standard Process
- Hybrid Curve Generation API
- Rate Lock Option Cost Calculation
- Rate Lock Volatility Curve
- Replicating Portfolio – On Prem to SaaS Migration
- Standard and Original Term for add-On Rate Calculations
- Dimension Management
- Data File History
- Scan For and Create Invalid Members
- Data File Specification
-
- Profitability Management
January Maintenance Pack for 23.12.1.1
This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:
| Date | Module | Feature | Notes |
|---|---|---|---|
| 06 FEB 2024 | Created initial document. |
HAVE AN IDEA?
We’re here and we’re listening. If you have a suggestion on how to make our cloud services even better then go ahead and tell us. There are several ways to submit your ideas, for example, through the Ideas Lab on Oracle Customer Connect. Wherever you see this icon after the feature name it means we delivered one of your ideas.
GIVE US FEEDBACK
We welcome your comments and suggestions to improve the content. Please send us your feedback at oracle_fusion_applications_help_ww_grp@oracle.com.
DISCLAIMER
The information contained in this document may include statements about Oracle’s product development plans. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.
This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information. Refer to the Legal Notices and Terms of Use for further information.
Column Definitions:
Report = New or modified, Oracle-delivered, ready to run reports.
UI or Process-Based: Small Scale = These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.
UI or Process-Based: Larger Scale* = These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.
Features Delivered Disabled = Action is needed BEFORE these features can be used by END USERS. These features are delivered disabled and you choose if and when to enable them. For example, a) new or expanded BI subject areas need to first be incorporated into reports, b) Integration is required to utilize new web services, or c) features must be assigned to user roles before they can be accessed.
| Ready for Use by End Users Reports plus Small Scale UI or Process-Based new features will have minimal user impact after an update. Therefore, customer acceptance testing should focus on the Larger Scale UI or Process-Based* new features. |
Customer Must Take Action before Use by End Users Not disruptive as action is required to make these features ready to use. As you selectively choose to leverage, you set your test and roll out timing. |
|||||
|---|---|---|---|---|---|---|
| Feature |
Report |
UI or |
UI or |
|
||
Profitability and Balance Sheet Management
Interpolation lookup method in Prepayment Model
Business Benefits:
- Fixed issues in Prepayment Model when lookup method for dimension is interpolation.
- Resolves calculation issue
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Usage of placeholder columns in Cash Flow Edits
Business Benefits:
- Placeholder columns that are present in data model must be registered from Data Model Extension screen before they can be used to define Cash Flow Edits rule.
- Resolves issue with user interface
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Changed location of Balance Reconciliation in application menu
Business Benefits:
- Balance Reconciliation has been moved from Analytics to Data Management Tools in the application menu
- UX improvement
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Interpolation lookup method in Prepayment Model
Business Benefits:
- Fixed issues in the Prepayment Model when the lookup method for dimension is interpolation.
- Resolves calculation issue
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Usage of placeholder columns in Cash Flow Edits
Business Benefits:
- Placeholder columns that are present in data model must be registered from Data Model Extension screen before they can be used to define Cash Flow Edits rule.
- Resolves issue with user interface
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Currency and Account Type dimensions in output preferences
Business Benefits:
- Currency and Account Type dimensions are always used to aggregate static deterministic results. So users need not select them in output preferences of Static Deterministic Process.
- Resolves issue with user interface
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Solved VPAT issues
Business Benefits:
- Some accessibility related issues were resolved in User Interfaces
- UX improvement
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:
| Date | Module | Feature | Notes |
|---|---|---|---|
| 02 JAN 2024 | Asset Liability Management | Updated document. Added new feature in 23.12.1. |
|
| 02 JAN 2024 | Asset Liability Management | Dimension Management | Updated document. Added new feature in 23.12.1. |
| 02 JAN 2024 | Asset Liability Management |
Data File History | Updated document. Added new feature in 23.12.1. |
| 02 JAN 2024 | Asset Liability Management |
Scan For and Create Invalid Members | Updated document. Added new feature in 23.12.1. |
| 02 JAN 2024 | Asset Liability Management | Data File Specification | Updated document. Added new feature in 23.12.1. |
| 21 DEC 2023 | Created initial document. |
HAVE AN IDEA?
We’re here and we’re listening. If you have a suggestion on how to make our cloud services even better then go ahead and tell us. There are several ways to submit your ideas, for example, through the Ideas Lab on Oracle Customer Connect. Wherever you see this icon after the feature name it means we delivered one of your ideas.
GIVE US FEEDBACK
We welcome your comments and suggestions to improve the content. Please send us your feedback at oracle_fusion_applications_help_ww_grp@oracle.com.
DISCLAIMER
The information contained in this document may include statements about Oracle’s product development plans. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.
This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information. Refer to the Legal Notices and Terms of Use for further information.
Column Definitions:
Report = New or modified, Oracle-delivered, ready to run reports.
UI or Process-Based: Small Scale = These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.
UI or Process-Based: Larger Scale* = These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.
Features Delivered Disabled = Action is needed BEFORE these features can be used by END USERS. These features are delivered disabled and you choose if and when to enable them. For example, a) new or expanded BI subject areas need to first be incorporated into reports, b) Integration is required to utilize new web services, or c) features must be assigned to user roles before they can be accessed.
| Ready for Use by End Users Reports plus Small Scale UI or Process-Based new features will have minimal user impact after an update. Therefore, customer acceptance testing should focus on the Larger Scale UI or Process-Based* new features. |
Customer Must Take Action before Use by End Users Not disruptive as action is required to make these features ready to use. As you selectively choose to leverage, you set your test and roll out timing. |
|||||
|---|---|---|---|---|---|---|
| Feature |
Report |
UI or |
UI or |
|
||
Profitability and Balance Sheet Management
Market Value and related measure output at Account level.
In addition to cash flow level, certain Market Value measures are aggregated and stored at account level when the required parameter is selected in Cash Flow Process. These are present value, duration, modified duration, DV01, YTM and EIR.
Business Benefit:
Improved report capability.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Data Validation in Cash Flow Engine
New rules to validate Last Interest and Principal Payment Date
Business Benefits:
- Rules to validate correctness of the last interest and principal payment date has been added to Cash Flow Engine.
- Improved accuracy of calculation.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
User Interface to perform Data Adjustments
Business Benefits:
- Data present in Select Staging and Processing tables can be viewed and corrected using Data Verification user interface. New records can also be added from the user interface.
- The feature gives ability to correct/adjust data after they have been extracted from source system and loaded to the Cloud Service.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Access Requirements
New roles - Data Management Access, Data Management Write, Data Management Authorize, Data Management Read Only – can be mapped to users to enable this functionality.
Enhancements to Member User Interface
Business Benefits:
- At the time of saving new member in Dimension Management, user has an option to ‘Save and Add New’. This will keep user on the same page and avoid going to summary.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Delete Data from Processing
Business Benefits:
- Option to delete data from processing tables has been enabled in Data File History screen.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Scan for and Create Invalid Members
Scan instrument data to identify Invalid Members
Business Benefits:
- New capability is available that scans data in Staging tables to identify dimension members that are not present in respective dimension tables. The tool can optionally create new members if required.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Ability to upload Column Order
Business Benefits:
- List of columns in selected table can be downloaded, order changed and uploaded back while defining Data File Specification. Downloaded file can be used as template to create data files.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
MDBS (Multi-Dimension Balance Sheet)
Different members of separate dimensions are organized in manner useful for a user to visualize the company's balance sheet at any level of detail desired.
Business Benefits:
- Allow users to organize one or more dimensions that extend their balance sheet to finer levels of details. Allow users the maximum amount of flexibility in defining the forecasting structure without the possibility of conflicting intersections (replicating data).
- Organize one or more dimensions that extend their balance sheet to finer levels of details.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Auto Balancing with MDBSS for ALM DDP
Autobalancing with MDBSS enabled with more forecasting capabilities.
Business Benefits:
- Auto balancing is a feature that automatically plugs balances in the forecasted buckets to maintain a balanced balance sheet over time.
- Improved accuracy of calculation.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Target Average Method available as part of Forecast balance Method with MDBSS enablement.
Business Benefits:
- Target Average Method are supported at any level of the MDBSS. The Application will use a "bottom up" evaluation approach, time bucket by bucket making easy to configure at any desired level for forecasting purposes.
- Easy to configure at any desired level for forecasting purposes.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Access Requirements
New roles - Data Management Access, Data Management Write, Data Management Authorize, Data Management Read Only – can be mapped to users to enable this functionality.
Pricing Margin enhanced with MDBSS User Interface
Business Benefits:
- Pricing margin enhanced with LHS MDBSS User Interface with side-by-side allocation interface which makes visibility during allocation rule definition with a single window concept.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
User Interface to perform data adjustments
Business Benefits:
- Data present in select staging and processing tables can be viewed and corrected using Data Verification user interface. New records can also be added from the user interface.
- The feature gives ability to correct/adjust data after they have been extracted from source system and loaded to the Cloud Service.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Access Requirements
- New roles: Data Management Access, Data Management Write, Data Management Authorize, Data Management Read Only – can be mapped to users to enable this functionality.
- Map user to relevant Group and Roles
Enhancements to Member user interface
Business Benefits:
- At the time of saving new member in Dimension Management, user has an option to ‘Save and Add New’. This will keep user on the same page and avoid going to summary.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Delete Data From Processing
Business Benefits:
- Option to delete data from processing tables has been enabled in Data File History screen.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Scan For and Create Invalid Members
Scan instrument data to identify Invalid Members
Business Benefits:
- New capability is available that scans data in staging tables to identify dimension members that are not present in respective dimension tables. The tool can optionally create new members if required.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Ability to upload column order
Business Benefits:
- List of columns in selected table can be downloaded, order changed and uploaded back while defining Data File Specification. Downloaded file can be used as template to create data files.
- Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Batch names have been made more user friendly with a functional name.
Business Benefit:
The batch enhancements are designed to improve User Experience for back end persona like System Administrators.
Steps to Enable
You don't need to do anything to enable this feature.
This enhancement ensures that it is intuitive for the Business User to understand if the custom region is not defined or already defined, in which case it appears pre-filled in the drop down.
Business Benefit:
This enhancement is designed to improve User Experience for Business users who want to use the Custom Regional Reports.
Steps to Enable
You don't need to do anything to enable this feature.
SaaS to SaaS Object Migration Utility
Object Migration Utility has been enabled for the following UI’s:
- Geography Mapping
- Line Item Display Order
- Financial Element Mapping
- Segmentation
Business Benefit:
Object migration helps the customers to move changes from Non-Production environments, where changes are tested to Production environments.
Steps to Enable
You don't need to do anything to enable this feature.
Permissions have been introduced in the Instrument level subject areas so that other PBSM app users have access to the relevant RPD elements. Furthermore, a glossary of the PACS and PFT subject area specifications have been created including reporting metadata mapping and capability of RPD export for the subject areas.
Business Benefit:
These are part of the incremental enhancements in the BI Reporting to deliver a better analytics capability.
Steps to Enable
You don't need to do anything to enable this feature.
Customer Profitability Report Enhancements
Customer and Account dimension as well as As of Date filters based on time dimension have been included across the entire Customer Profitability Report.
Business Benefit:
These are part of the incremental enhancements in the BI Reporting to deliver a better analytics capability.
Steps to Enable
You don't need to do anything to enable this feature.
Enhancements to Account and Customer as well as Instrument Summary run charts to improve display times across Out of the Box reporting Layer.
Business Benefit:
Performance Improvement for Reporting display.
Steps to Enable
You don't need to do anything to enable this feature.
The Account Audit UI provides users a tool to validate engine calculations by displaying all details like input attributes, methods configured, IRC curve used, Cash flows generated in one single window.
Business Benefits:
Business user can access the following details:
- Transfer rates, Add-On rates, and Economic Cost results.
- Audit Information like method used for Transfer Rate and Add-On Rate calculation.
- Interest Rate curves used.
- Cash Flows generated for the accounts.
Steps to Enable
You don't need to do anything to enable this feature.
The gain or loss to the Bank from such early prepayments and withdrawals is the opportunity cost of not being able to replace the spread earned on the asset or deposit being lost.
Business Benefit:
The Economic Loss Breakage Charge method helps treasury to compute the cost to the organization (economic loss) incurred for terminating the transaction.
Steps to Enable
You don't need to do anything to enable this feature.
Data present in select staging and processing tables can be viewed and corrected using Data Verification user interface. New records can also be added from the user interface.
Business Benefit:
The feature gives ability to correct/adjust data after they have been extracted from source system and loaded to the Cloud Service.
Steps to Enable
You don't need to do anything to enable this feature.
Economic Value Cost Calculation
Economic Value calculations are based on future cash flows, which can be based on any of transfer/add-On rates along with all in TP rate. EV calculation tries to measure opportunity cost in given market scenario.
Business Benefit:
Treasury can measure the inherent value of the deal if it is closed before maturity.
Steps to Enable
You don't need to do anything to enable this feature.
Group Filters Integration in Standard Process
Group filters are used to join one or more data element filters. These play very instrumental role to define granular portfolio for which any individual data filter is not enough, then multiple data filters can be combined together.
Business Benefit:
This enables users to define granular portfolios.
Steps to Enable
You don't need to do anything to enable this feature.
Any external system can send underlying curves data to this API and in response it will share hybrid curve back to calling system.
Business Benefit:
Any type of forecasted rates can be used for hybrid curve generation.
Steps to Enable
You don't need to do anything to enable this feature.
Rate Lock Option Cost Calculation
The benefit granted to the user to receive the lower rate at time of settlement can be thought of as an option, specifically the bank sells the customer a European 'at the money spot' interest rate swaption. The cost of this option can be calculated, using rate lock option cost calculation feature.
Business Benefit:
This capability allows treasury to “lock-in” a Loan Funding Rate at a point in time prior to the actual loan funding.
Steps to Enable
You don't need to do anything to enable this feature.
User can define volatility curves across contractual and commitments terms which can be subsequently used for rate lock option cost calculations.
Business Benefit:
Business can correctly measure option cost for locked rate options.
Steps to Enable
You don't need to do anything to enable this feature.
Replicating Portfolio – On Prem to SaaS Migration
Allows to migrate the Replicating Portfolio for existing on-prem clients to their SaaS environments.
Business Benefit:
Business can save lot of cost/hassle involved in migrating objects from On-Prem to SaaS.
Steps to Enable
You don't need to do anything to enable this feature.
Standard and Original Term for add-On Rate Calculations
Standard Term and Original Term selections helps to calculate add-On rates for use TP methods, this plays critical role when user tries to calculate add-On rates like liquidity premium where user like to account for complete life of account even if it is an adjustable rate account.
Business Benefit:
Business can account for complete life of instrument using original life if it is being repriced at pre-defined frequency.
Steps to Enable
You don't need to do anything to enable this feature.
At the time of saving new member in Dimension Management, user has an option to ‘Save and Add New’. This will keep user on the same page and avoid going to summary.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Option to delete data from processing tables has been enabled in Data File History screen.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Scan For and Create Invalid Members
New capability is available that scans data in staging tables to identify dimension members that are not present in respective dimension tables. The tool can optionally create new members if required.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
List of columns in selected table can be downloaded, order changed and uploaded back while defining Data File Specification. Downloaded file can be used as template to create data files.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
List of columns in selected table can be downloaded, order changed and uploaded back while defining Data File Specification. Downloaded file can be used as template to create data files.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Scan for and Create Invalid Members
New capability is available that scans data in staging tables to identify dimension members that are not present in respective dimension tables. The tool can optionally create new members if required.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Option to delete data from processing tables has been enabled in Data File History screen.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
At the time of saving new member in Dimension Management, user has an option to ‘Save and Add New’. This will keep user on the same page and avoid going to summary.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
Data present in select staging and processing tables can be viewed and corrected using Data Verification user interface. New records can also be added from the user interface.
Business Benefit:
The feature gives ability to correct/adjust data after they have been extracted from source system and loaded to the Cloud Service.
Steps to Enable
You don't need to do anything to enable this feature.
Migration of Allocation Model containing Lookup Driver allocation rules is dependent on the migration status of the lookup table rule. Application intelligence has been added to mark the rules in target environment as Migration Successful.Migration of Allocation Model containing Lookup Driver allocation rules is dependent on the migration status of the lookup table rule. Application intelligence has been added to mark the rules in target environment as Migration Successful.
Business Benefit:
Ease of object migration as the legacy allocation models containing any lookup driver allocation rules need not be created from scratch in SaaS, unlike the rules.
Steps to Enable
You don't need to do anything to enable this feature.
Deprecation of a Task Scheduler Based Service
The "Delete Data Loader" component is made unavailable in the component drop-down in Task creation screen.
Business Benefit:
Replacement of the deletion service with an advanced delete option from the UI that enables deletion from all the three classes of processing tables - Ledger, Transaction Summary and Instruments.
Steps to Enable
You don't need to do anything to enable this feature.
Delete from Processing screen gives an option to delete data from the processing tables through the Data File History screen.
Business Benefit:
Improved user experience.
Steps to Enable
You don't need to do anything to enable this feature.
A set of more than a hundred columns has been added into PBSMCS Data Model to give users a wider set of seeded columns to be used for financial/banking measures.
Business Benefits:
- Increased ease of Legacy Data Migration as the added columns are similar to that of legacy version.
- A wider array of seeded columns minimizes the users’ need to create custom columns.
Steps to Enable
You don't need to do anything to enable this feature.
Engine Performance Testing and Benchmarking
Allocation Engine Performance has been drastically improved for a large set of uses cases for Management Ledger based allocations.
Business Benefit:
Improved/Reduced allocation execution timings.
Steps to Enable
You don't need to do anything to enable this feature.