Oracle Financial Services Treasury Application Pack Release v8.0.0.0.0 Minor Release # 2 (8.0.2.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 #2 8.0.2.0.0 (ID 22127488)

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 either OFS TR Application Pack v8.0.0.0.0 or TR Application Pack v8.0.1.0.0.

How to Apply This Release?

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

Oracle Financial Services Analytical Applications Infrastructure

This section includes the following sub-sections:

·         New Features in This Release for OFSAAI

·         Fixed Issues in This Release for OFSAAI

·         Limitations and Known Issues 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.2.0.0 User Guide.

1.       Data Management Tools

·         Table creation on the fly from Data File Mapping and Data Mapping screens is introduced. This allows you to add dynamic tables into the data model within OFSAA ecosystem.

·         Query validation is made optional while saving Data Mapping definition through the introduction of a new configuration parameter.

·         To limit the number of records that needs to be loaded, a new target property (RecordLoadLimit) is introduced in Data Mapping definition.

2.       Data Quality Framework

·         Dynamic Degree of parallelism for RDBMS is supported.

·         Referential Integrity checks can be defined using composite key columns.

3.       System Configuration & Identity Management

·         Users can be optionally created or modified to get authenticated using OFSAA Security Management System in case LDAP authentication is configured.  

·         Audit Trail report has been enhanced to show detailed information for various operations such as User -User Group map, User Group-Domain map, User Group- Role map, User Group –Folder-Role map, Role-Function map and Profile Holiday Map.

4.       Business Metadata Management

·         Derived Entity definition supports creating materialized views with option to refresh fast/force/complete on demand/commit and query rewrite.

5.       Forms Framework

·         Forms Framework has been enhanced to render Forms with CSS3 and HTML 5 constructs in addition to support of HTML 3. This is to enable support of Standards Mode and rendering of HTML pages in Internet Explorer and Google Chrome. 

·         Migration of Tabs and Layout details is supported for Object Migration Command line utility.

·         The behavior of the type 102 control can be changed to either single select or multi-select based on a particular column value of the grid.

6.       OFS Analytical Applications Infrastructure (OFS AAI)

·         A command line utility has been introduced for resaving derived entity either through Batch framework or stand alone.

·         A command line utility has been introduced for source model generation.

·         Forms are rendered in standard mode based on DB Flag.

·         DB Catalog option supports reverse generation of existing database metadata into OFSAAI metadata repository by connecting to RDBMS Schema specified as DataDom in the Information Domain.

·         Configuration of onchange and ismandatory functions is introduced for Flexible KBD controls.

7.       OFS Inline Processing Engine (IPE)

·         Dynamic Partition of result table in Information based on HIVE is supported.

·         Export of Assessment now includes all the metadata associated with the Assessment.

·         Capability for post processing the results data is introduced.

·         Support of Fixed time window for Profiles is introduced.

Fixed Issues in This Release for OFSAAI

Component

Sub component

Bug ID

Description

Administration

Utilities

21328053

INFODOM DROPDOWN IN "USER GROUP-BATCH EXECUTION MAP" SCREEN SHOWS FULL LIST

Data Entry Forms and Queries

Data Entry

21339271

NUMBER FORMAT CAUSES EDIT TO FAIL WITH SPECIAL CHARACTER NOT ALLOWED ALERT

Data Loading

-

21173111

'ORA-12899: VALUE TOO LARGE FOR COLUMN' IN MESSAGESERVER LOG RUNNING F2T

Forms Framework

-

20598965

MENU AND DROP DOWN OVERLAP

Install and Upgrade Issues

Service Packs

21915445

PATCH INSTALLER DOES NOT VALIDATE FOR SESSION LEVEL SHELL AND PROCEEDS WITH BASH

Base Installer

21810719

ENVCHECK.SH CHECKS NLS_LENGTH_SEMANTICS DATABASE SETTING AT SESSION LEVEL

20727720

EDITABLE INFORMATION DOMAIN NAME FIELD IS NOT USER FRIENDLY

Metadata such as T2T, F2T, etc

T2T Issues

21812780

T2T FINISHES SUCCESSFULLY WHEN REJECTION THRESHOLD EXCEEDED

Security Management System

-

21697204

UCP CONNECTION POOL FAILING IN ALL THE LAYERS

Unified Metadata Manager

Business Metadata Management

21367887

$MISDATE,$RUNSK DOES NOT WORK IN DATA SET ANSI JOIN SUBQUERIES

20760616

NEED SPECIAL CHARACTERS IN HIERARCHY SHORT DESCRIPTION

Data Quality Definition

20511796

CHANGE IN ALERT MESSAGE IN DQ LIST OF VALUES CHECK RULE WHEN FILTER TYPE IS CODE

-

21464164

MAPPER SCREEN PAGE IS TAKING TOO MUCH TIME TO LOAD AND SAVE

System Configuration

Information Domain

21484146

ADD PERSISTENCE UNIT ENTRY IN GRCPERSISTENCE&PERSISTENCE DURING INFODOM CREATION

Administration

Object Migration

22446723

OBJECT MIGRATION SHOULD PERSIST SOURCE AND TARGET OBJECT IDS INTO DATABASE

Metadata such as T2T, F2T, etc

-

22539004

T2F TASKS ARE FAILING

GRC Infrastructure

 

22459967

SEARCH FUNCTIONALITY NOT WORKING IN KBD PREFERENCE SUMMARY PAGE FOR OTHER LOCALE

22459895

KBD MAPPER AND CHECKER SCREEN NOT GETTING TRANSLATED IN OTHER LOCALES

Business Restructure

21625588

MULTI LOCALE SUPPORT IN BUSINESS RESTRUCTURE

Rules Framework

-

22486848

WSMREREQUEST.SH FAILED WITH ORA-12899

System Configuration

Configuration

22453450

APPLICATION ID IS NOT DISPLAYING CORRECT FOR OTHER LOCALES IN MODIFY/VIEW SCREEN

Operations

Batch Monitor

21949567

API'S REQUIRED TO TRACK THE BATCH STATUS

Workflow Framework

 

21610478

UNABLE TO ADD MORE THAN ONE DATA FIELD

Unified Metadata Manager

Metadata Browser

22455350

MDB>DATA SOURCES MENU IS NOT TRANSLATED TO OTHER LOCALES

Limitations and Known Issues in This Release for OFSAAI

·         Model Upload with DB Catalog option is not supported for RBDMS based Information Domains.

·         Model upload mode for the subsequent uploads is not same as the initial upload mode.

·         Exporting object type with code 2000 (User) fails if FAILONERROR is set to N.

·         Dynamic table created during Data File Mapping has incorrect column data types.

·         Data Mapping screen alignment changes if tables selected are with big names.

·         Description is not getting updated in Excel Upload edit mode.

·         Export with Include Search Info option for Type =1 container is not showing search information when exported to Excel Sheet.

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

Oracle Financial Services Treasury Risk

This section includes the following sub-sections:

·         New Features in This Release for OFS TR

·         Limitations and Known Issues 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.2.0.0 User Guide.

·         Forward date liquidity risk calculations

·         Liquidity Coverage Ratio calculation as per guidelines specified by Reserve Bank of India (RBI)

·         Computation of intraday monitoring metrics in accordance with BIS and RBI guidelines

·         Real-time intraday liquidity monitoring reports

·         Intraday liquidity time buckets and business assumptions

·         FR2052a (5G) asset categorizations

·         Regulatory templates covering:

o    BLR, Statutory Liquidity Ratio and Dynamic Liquidity Ratio reports of RBI

o    Intraday Monitoring Tools Reporting forms as per BIS and RBI

·         Dashboard  Reports

Limitations and Known Issues in This Release for OFS TR

Bug ID

Description

22647399,
22646123

For RBI assumptions commitment related outflow calculation and maturing ABCP run offs is limited

22636174

Derivative inflows are not being adjusted for HQLA collateral

22501865

Funds obtained through central bank intraday liquidity facility not excluded for Intraday metric: Daily maximum intraday liquidity usage

22321563

Identification of securities posted against MSF is limited in the system