Oracle Financial Services Treasury Application Pack Release v8.0.0.0.0 Minor Release # 1 (8.0.1.0.0)

This readme has the following sections:

·         Description

·         Prerequisites

·         How to Apply This Release

·         Oracle Financial Service Analytical Applications Infrastructure

·         Oracle Financial Services Treasury Risk

Description

OFS TR Application Pack v8.0.0.0.0 Minor Release #1 8.0.1.0.0 (ID 21032371)

This release of OFS TR Application Pack is cumulative of all enhancements and bug fixes done since v8.0.0.0.0 release

Prerequisites

The minimum patch set level should be OFS TR Application Pack v8.0.0.0.0.

How to Apply This Release?

For detailed instructions on installing this OFS TR Minor Release, please refer OFSTR 8.0.1.0.0 Installation Guide.

Oracle Financial Services Analytical Applications Infrastructure

This section includes the following sub-sections:

·         New Features in This Release for OFSAAI

·         Known Issues/ Limitations in This Release for OFSAAI

New Features in This Release for OFSAAI

Following is the list of new features incorporated in this release. For detailed information on usage of these features, refer to OFSAAI 8.0.1.0.0 User Guide.

1.       Business Restructure

·         Business Restructuring in corporate management is act of reorganizing Ownership, Operational or other structures of the company for making it more profitable or better organized for its present needs. Other reasons for restructuring include demerger or a response to major change in the business such as repositioning or buyout.
A module has been introduced in this release to configure and manage the restructuring process across the organization.

2.       Process Orchestration Framework

·         A new module has been introduced to support built-in tooling for orchestration of human, automatic workflow interfaces as well as various OFSAA Processes.

o    Support for visual modeling of the Workflow and Processes.

o    Support for registration of Process /Activity/ Transition Logic implementation, separated from the modeling process itself.

o    Built-in orchestration engine (included within OFSAAI’s runtime) for workflow execution (interactive model as opposed to the batch model supported through Rule Run Framework).

o    Published interface for abstraction of workflow task implementation. 

o    Representation of the workflow-routing rule logic in Java/ PL-SQL / Web-service.

o    Process Monitoring Admin Tool to view and control the Execution Process Instances.

3.       Data Management Tools

·         Ability to preview Database details while creating Data Sources has been introduced.

·         Ability to preview data of the source/ target entities has been provided while defining Data Mapping and Data File Mapping.

·         For Data Mapping, there is no default limit set for Rejection Threshold and the value needs to be set if it is required.

·         Data Sources creation has been modified to pick up the connection details created from the Database Details screen.

4.       Data Quality Framework

·         Data Quality rules can be defined on Data Management Sources. 

·         Data Quality checks can be performed based on Unique Identifier Columns other than Primary Key columns.

·         In the Data Quality Reports, the Primary Key columns or Unique Identifier Columns are displayed.

5.       Mapper

·         Copy feature of Mapper definitions is introduced.

·         While defining a Mapper, an option to create Database View has been provided.

6.       Business Metadata Management

·         Ability to preview the query and the data from the Dataset definition is introduced.

7.       Object Migration

·         Command Line Migration now supports Security Management System (SMS) objects such as Users, Usergroups, Functions, Roles, and Profiles along with the mappings.

·         The Object Migration Command Line Utility (offline option) supports wildcard (*) feature.

8.       Run Rule Framework

·         The Use Descendants option for a Parent Child hierarchy has been provided to apply self/ descendants to a Run/Process condition implicitly.

·         The Process engine has been enhanced to support “Select Insert” and “Partition Swap” query along with the “Merge” query.

·         The Rule engine has been enhanced to support “Select Insert” and “Partition Swap” query along with the “Merge” query.

9.       Model Upload

·         A command line utility has been introduced to perform Object Registration independently for an Information Domain where model upload is done successfully.

10.   DEFQ

·         From the Excel Entity Mappings and Excel Upload screen, you can download the Excel template which is used in the mapping.

11.   System Configuration and Identity Management

·         Create New Application feature has been introduced, which enables to create an Application using the standard platform frameworks.

·         The Database details screen has been enhanced to support for heterogeneous database.

·         Users can be created with an option to authenticate through SMS even when LDAP or SSO authentication is enabled.

·         SSO authentication using SAML v2 is introduced. This release supports only 1-way SAML authentication.

·         User Provisioning API is provided so that User Objects can be provisioned in OFSAAI using web service call.

·         An option to reinstate the deleted users has been introduced.

12.   Forms Framework

·         Flexible Key Business Dimensions(KBDs)

o    Configuring Flexible KBDs is supported, which provides centralized configuration approach to KBD usage in the Applications, other than the seeded KBDs.

·          Other Enhancements

o    Spell check feature can be enabled for Text Box, Text Area, and Rich Text controls.

o    A new feature is provided to pick the list of values for radio button and check box dynamically.

o    Dynamic Filtering of drop-down for multi-select control has been introduced.

o    Tool tips are provided for the wrap and unwrap buttons when the Image text is blank.

o    Auto-fit feature is provided for Editable grid with multiple grids.

o    Special characters are supported in multi-select control.

o    Document delete feature is provided.

13.   Metadata Browser

·         Data Mapping along with User Defined Properties (UDPs) can be exported to Excel.

·         An option to display Data Mapping with the selected UDPs is provided.

·         The following objects are supported:

o    Data Sources

o    Data Source Entity

14.   Link Analysis

·         Single click option has been provided for Nodes.

·         If multiple links (different types) are shared between two nodes, then the link is considered as complex link instead of duplicate link.

·         Link Analysis graph has been enhanced to display with scroll bars for large graphs. Additionally, when a graph is zoomed out, the scroll bars will be displayed.

Known Issues/ Limitations in This Release for OFSAAI

Component

Sub Component

Bug No

Subject

Administration

-

21423196

OFSAAI does not allow to enter the special characters such as '~!@#$%^&*()_+' in SFTP / FTP details screen

Data Entry Forms and Queries

Excel Upload

21354370

The Description of an Excel-Entity mapping definition is not getting updated in edit mode.

Model Upload

 

21207454

Model upload summary grid does not display the status of Object Registration process.

Rules Framework

Rule Execution Engine

21335353

Execution log does not provide detailed steps of execution if Execution mode is set as SELECT or PARTITION SWAP at Rule/Process/Run Level.

System Configuration

Database Details

21341795

No field restriction is given for the Name field in the Database details. Validation is done only after user clicks Save.

Unified Metadata Manager

Business Metadata Management

21205832

When a multi level hierarchy is used and the same hierarchy is repeated in more than one level, Pushdown operation is failing.

Data Quality Group

21297551

Data Quality Group Summary grid does not display whether the DQ group is defined on Data Source or Infodom.

Data Quality Definition

21421824

Java script error occurs when user clicks the online help icon from DQ Rule Summary page.

21297543

Data Quality Rule Summary grid does not display whether the DQ Rule is defined on Data Source or Infodom.

21216533

If you are defining Data Quality check on a Data Management Source, only quality check will be done; data correction will not be done since it is an external source. The UI does not restrict to perform any assignments on such DQ rules.

Import Business Model

21422610

Model Upload log file provides incorrect information about indices.

Metadata Archive Restore

21178745

From the Object Migration> Restore Metadata, when you click Browse to select the DMP file, the folders are not displayed.

Technical Metadata Management

21229361

Table Logical name is empty for Data File Mapping screen.

21420020

Saving Data Mapping definition takes long time if an entity containing many attributes (>100 columns) is selected as Source entity.

21201150

Show Details/ Data Preview should be available under selected Members tree.

Forms Framework

Forms Manager

21221027

Forms Manager application expects IE 11 Compatibility Mode setting from every client browser.

Link Analysis

-

20920008

Link Analysis context menu is going out of page and user has to scroll to view it.

Oracle Financial Services Treasury Risk

This section includes the following sub-sections:

·         New Features in This Release for OFS TR

·         Known Issues/ Limitations in This Release for OFS TR

New Features in This Release for OFS TR

Following are the list of enhancements incorporated in this release. For detailed information on usage of these enhancements, refer to OFSTR 8.0.1.0.0 User Guide.

·         Compliance with Liquidity Coverage Ratio calculation as per the Regulation WW Final Rule issued by US Federal Reserve

·         Pre-configured FR2052a template for compliance with 5G liquidity requirements of US Federal Reserve

·         New dashboard reports and enhancements to existing dashboard reports

·         Cash flow bucketing based on calendar days

·         A new out-of-box regulatory time bucket has been defined. A new set of business assumption has been defined based on this regulatory time bucket definition to address the regulatory scenario specified as part of US Final Rule

·         Minor user interface enhancements

Known Issues/ Limitations in This Release for OFS TR

Bug

Subject

21573707

RETAIL DEPOSIT OUTFLOW AMOUNT FOR THE THIRD PLACED DEPOSITS - INCLUDE ANNUITY

21565779

FURTHER CASH FLOWS ARE EXPECTED TO BE AVAILABLE AS A DOWNLOAD PER THE RULES OF CONSERVATISM GIVEN IN THE FINAL RULES

21500442, 21294001

PRODUCT TYPES LEASES HAS BEEN INCLUDED WITH LIMITED SCOPE. WILL UPDATED IN THE NEXT RELEASE

21470034

THE SYSTEM CALCULATES COLLATERAL OUTFLOW AMOUNT ONLY FOR DERIVATIVE PRODUCTS

21414743, 21412253

REVISED MATURITY CALCULATION IS LIMITED AND WILL BE UPDATED

21542474, 21410179

NON-MATURITY INFLOWS HAVE BEEN INCLUDED WITH LIMITED SCOPE AND WILL NEED TO BE CATEGORIZED APPROPRIATELY BY THE BANK

21574249

COMMITMENT OUTFLOW ASSUMPTION HAS TO EXCLUDE LIQUIDIT PROVIDED TO STRUCTURED SEC

21493692

UNDRAWN AMOUNT CALCULATION IS LIMITED

20535670, 21697813

CHANGING BALANCE OPTION IN THE RUN PARAMETERS MAY GIVE INACCURATE RESULTS, IT WILL BE FIXED IN A PATCH RELEASE

21535827

STRUCTURED TRANSACTION OUTFLOW HAS NOT BEEN INCLUDED 

21470917, 21293934

PRODUCT TYPES ANNUITY/ RETIREMENT ACCOUNTS HAS BEEN INCLUDED WITH LIMITED SCOPE. WILL UPDATED IN THE NEXT RELEASE

21613131

DRILL DOWN OF LIQUIDITY RATIO REPORTS IS LIMITED

21641886, 21634617, 21638920

DATA ANLAYSIS AND LIQUDITY RATIO REPORTS HAVE SOME ERRORS WHICH WILL BE FIXED

21641559, 21638975, 21634688, 21634378, 21612724, 21697350

THERE ARE SOME REPORT RELATED ERRORS AND ISSUES WHICH HAVE  BEEN INDENTIFIED AND WILL BE FIXED