Oracle Logo

Financial Services Advanced Analytical Applications Infrastructure Application Pack v8.1.0.0.0 Minor Release #2 (v8.1.2.0.0)

OFS AAAI Application Pack v8.1.0.0.0 Minor Release #2 8.1.2.0.0 (ID 32791983)

This release of the OFS AAAI Application Pack is cumulative of all enhancements and bug fixes completed since the v8.1.0.0.0 release.

NOTE:

·       For information about the Hardware and Software Requirements for this release, see the Oracle Financial Services Analytical Applications 8.1.2.0.0 Technology Matrix.

·       SQL Rule is a deprecated feature and is not supported. For further guidance, contact Oracle support.

Prerequisites

The minimum patch set level should be OFS AAI/AAAI Application Pack v8.1.0.0.0.

NOTE: You can upgrade the OFS AAI Platform on any OFSAA Application Pack.

How to Apply this Release?

For instructions on how to install this OFS AAAI Application Pack Release, see the OFS AAAI Application Pack Installation and Configuration Guide 8.1.2.0.0.

New Features and Enhancements in this Release

The following list provides details for the new features and enhancements in this release. For detailed information on how to use these features, see the Oracle Financial Services Advanced Analytical Applications Infrastructure v8.1.x User Documentation Online Web Page.

1.        Data Maintenance Interface

The enhancements are as follows:

·       The Audit-Trail Window now shows the Audit Time-stamp in milliseconds.

·       The Master-Child Data Maintenance Support enables Banks to maintain the data for the Master Table and its Child Tables (up to four Child Tables). Users must provide data for all selected tables in a single action.

NOTE: To use this feature, you must apply the mandatory patch 34778706 after or before installing the 8.1.2.1 patch

For more details, refer Data Maintenance Interface section of the AAI User Guide.

2.       Filter

Utility to download and upload Filter Definitions.

3.       Link Analysis

Performance Optimization to reduce the time taken to load graphs.

4.      Model Upload

Utility to transform SQL Modeler to ODM (JSON).

5.       Object Migration

The reverse population of Migrated Hierarchies using Offline Migration.

6.      Operations Menu

Privileged-based access to the functionalities in all of the Batch Screens.

7.       Process Modelling Framework

·       Performance Optimization is done to:

o   Reduce database requests to improve resource utilization.

o   Optimize Query Execution time using Indexes.

·       Configure Users to have only PMF Process Execution Privilege (WFACCNEXE Role Code).

8.      System Configuration

·       Web to Processing Tier communication through Hostname where the Processing Tier binds to the IP Address and not the Hostname.

·       Configure the value for 'SMS AUTH ONLY' through the Identity Management (IDM) RESTful API.

·       Map Users to a Group through the RESTful API.

·       UI Configuration to enable Just in Time (JIT) Provisioning to synchronize the User, Group, and User-Group Mapping in external systems such as LDAP, SAML, and SSO into OFSAA when a User logs in.

·       Change the default setting to refresh the Batch Monitor and Batch Execution Windows.

·       Use the Configuration Password from the Setup in PortC.jar and not prompt for the password during OFSAA Cloning. Support for Encryptc.jar to accept Command Line Arguments as a parameter.

9.      Security Management System

·       Utility to generate CSV file containing User, Groups, and User-Group Mapping.

·       Following enhancements in User Maintenance:

o   When you create a User, the Enable User check box is selected by default.

o   When you create a User, Start Date-Time displays the Current Date-Time by default and the End Date displays 31-December-2050 by default.

o   Lock statuses such as Enable, Disable and Delete with Authorization required for status updates.

o   Authorization is not required to view the Enable User Window in the User Activity Report.

Library Upgrade Information

Standard upgrade of libraries for common usage in OFSAA:

§  ant 1.10.11

§  Batik 1.14

§  guava 2.29.0

§  spring-xml-3.0.10.RELEASE.jar

§  spring-ws-core-3.0.10.RELEASE.jar

§  spring-ws-security-3.0.10.RELEASE.jar

§  xmlsec 2.2.3

List of Bugs Fixed in this Release

The following bugs are fixed in this release.

Component

Sub-component

Bug ID

Subject

Build Related

 

32924004

MDB SETTINGS CAUSES DEPLOYMENT FAILURE ON THE WEBLOGIC WEBSERVER 

Operations

Batch Group

33083987

THE TASK ID FIELD IS EDITABLE IN THE TASK DEFINITION SCREEN

Operations

 

31025034

THE IRC_HYBRID_SCHEDULER FAILS WITH ORA-01756 WITH MULTIPLE IRCS IN THE PARAMETER LIST

Process Modeller Framework

 

33250592

RUN PIPELINE - APPLICATION RULE OF "JSON READ FROM DB" FAILS WITH ERROR "FAILED TO FETCH CONNECTION FOR INVALID INFORMATION DOMAIN: NULL"

Rules Framework

 

33512976

RRF: FAILS TO LOAD THE TWO-PANE HIERARCHY BROWSER IN THE RULE SCREEN

System Configuration

Configuration

30106614

LOGGER LEVEL TO BE CHANGED FOR LDAP RELATED ERRORS IN 8.0.7

System Configuration

Security Metadata Mapping

33420767

IMPLEMENT A SIGNED REQUEST DURING LOGOUT IN SAML AUTHENTICATION

Unified Metadata Manager

Technical Metadata Management

29726268

[8368] MANDATORY COLUMNS ARE NOT MAPPED [9024] DO YOU WANT TO CONTINUE?

Unified Metadata Manager

Technical Metadata Management

32974452

FSDF812-LOGS SHOW THAT THE SOURCE MODEL GENERATION FAILS

Unified Metadata Manager

Technical Metadata Management

31195348

PLC JAVA EXECUTIONS PASS ADDITIONAL ICC PARAMETERS WITHOUT TRUNCATING

 

List of Bugs Fixed and Enhancements in Previous Releases Ported to v8.1.2.0.0

The bugs fixed and enhancements in previous release versions that are ported to this release are as follows.

Component

Sub-component

Bug ID

Subject

Administration

 

33269938

UNABLE TO SAVE USER DETAILS IF THE USERNAME INCLUDES SPACE

Administration

 

33071578

ENABLE USER LINK IS MISSING FROM IDENTITY MANAGEMENT

Administration

 

33071565

UNABLE TO INPUT MORE THAN 10 CHARACTERS IN THE 'SAML USER ATTRIBUTE' FIELD

Administration

 

33014136

REST APIS FOR INTEGRATING WITH SAILPOINT

Administration

Object Migration

33243664

CANNOT MIGRATE THE AMHM HIERARCHY AND FTP STANDARD PROCESS AFTER OFSAA V8.1.1.1

Administration

Utilities

33222268

THE ROTATEATOMICDBPWD.SH SCRIPT FAILS AFTER CHANGING THE DB CONNECTION WITH RAC JDBC

Administration

Utilities

33071449

THE ROTATEATOMICDBPWD.SH SCRIPT FAILS AFTER CHANGING THE DB CONNECTION OVER SSL

Administration

Utilities

32918195

THE TRANSFER_BATCH_OWNERSHIP PROCEDURE FAILS IF THE BATCH NAME IS IN LOWERCASE OR MIXED CASE

Big Data

Security Model

33219462

IN OFSAAI 8074, SUBMISSION OF SPARK SESSION WITH LIVY IMPERSONATE ENABLED AS TRUE DOES NOT VERIFY THE USER 

Build Related

 

32559362

PMF  DOES NOT FUNCTION IN MRMM 8101 AND 811

Dimension Management

Hierarchy

32976295

SEVERAL ISSUES WITH THE HIERARCHY UI

Dimension Management

Hierarchy

33023013

IN THE HIERARCHY MAINTAINER, THE SEARCH OPTION IN THE HIERARCHY BROWSER DOES NOT WORK AND THE CONTRAST ISSUE FOR LEAF/NON-LEAF NODES

Expression

 

33030079

INSTRUMENT AND TXN TABLES ARE NOT LISTED IN THE PFT-I EXPRESSIONS UI

Filters

 

32889899

THE RATE CARD PRODUCTS ARE NOT SHOWN AFTER APPLYING THE FILTER

Filters

 

32684279

IN THE FILTER DEFINITION UI, ONE-CLICK SELECT-ALL AND ADD ROWS DIALOG ISSUES

Filters

Data Element Filter

28239351

DATA FILTERS CANNOT EFFECTIVELY SEARCH THROUGH DATA ELEMENTS IN FIREFOX

Filters

Filter Hierarchy

32986739

THE SELECTED NODES/LEAVES IN THE HIERARCHY FILTER ARE NO LONGER DISPLAYED IN BOLD AND THERE ARE OTHER SELECTION ISSUES

Filters

Filter Hierarchy

32946806

THE REQUEST FOR THE HIERARCHY FILTER SHOWS MEMBER SHOWING THE SELECTED NODE/LEAF

Filters

Filter Hierarchy

32944404

IN THE FILTER DEFINITION SCREEN, SEARCH FOCUS SELECTION ISSUE

Filters

Filter Hierarchy

32894752

THE HIERARCHY FILTER SEARCH NODE AND SELECT NODE ARE NOT TAGGED AFTER REOPENING

Filters

Filter Hierarchy

32825016

THE ADD/UPDATE OPERATION FAILS WITH ERRORS WHILE CREATING HIERARCHY FILTERS

Filters

Filter Hierarchy

32684951

SHOWS JAVA.SQL.SQLSYNTAXERROREXCEPTION: ORA-01795: MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000 WHILE SAVING A LARGE HIERARCHY

Filters

Filter Hierarchy

33217048

ISSUE WITH HIERARCHY, SHOW NUMERIC CODE VALUE AND DISTINGUISH DISPLAY OF LEAF AND NON-LEAF NODE

Forms Framework

 

33295883

PERFORMANCE ISSUES WITH THE HIDDEN CONTAINER ID AND PAGINATION

Forms Framework

 

33283775

CTR, UNABLE TO DOWNLOAD THE E-FILE

Forms Framework

 

33035709

THE OPTION IN THE REFRESH CONTROL MUST REFRESH INDIVIDUAL GRIDS INSTEAD OF THE ENTIRE PAGE

Forms Framework

 

32945170

GROUP BY TREE AND TAB DOES NOT WORK FOR GRIDS WITH DISTINCT RECORDS, COMMENTS AT THE BOTTOM, AND BUG TREE AT THE TOP

Inline Processing

 

32873699

CHANGES TO SUPPORT IPE BATCHES RUN IN A TCPS ENABLED ENVIRONMENT

Installation

 

33071595

THE N_SERIAL_NO COLUMN IN THE  INFODOM_PATCHES TABLE, ACCEPTS A MAXIMUM OF 999 ENTRIES

Installation

Migration Scripts

32963495

AAI 8.1 CANNOT IMPORT EXPRESSION

Internal Operations

 

32996873

THE BATCH OPERATIONS VIEW LOG SHOWS '[208846] NO RECORDS FOUND FOR THE SELECTED SEARCH CRITERIA'

Internal Operations

 

32585762

SUPPORT OF IPV6 IN RHEL 

Metadata such as T2T, F2T, etc

 

32824870

THE T2F FAILS WITH THE 'ORA-00936: MISSING EXPRESSION' ERROR AFTER ADDING A RUNTIME PARAMETER

Metadata such as T2T, F2T, etc

 

32663168

THE H2T JOB RUN FAILS WHEN WE USE STAGING='Y'

Metadata such as T2T, F2T, etc

T2T Issues

33318532

IN AAI 8092, T2T EXECUTION ERROR

Metadata such as T2T, F2T, etc

T2T Issues

33545817

UNEXPECTED CHARACTER WHEN USING TILDA '`' IN ANSI JOIN OF T2T

Model Upload

 

33208725

FTP OF SCRIPTS TAKE A LONG TIME DURING THE MODEL UPLOAD

Model Upload

 

33208710

UPDATE CONSTRAINT UTILITY TO CORRECT THE INCONSISTENCIES IN THE UPGRADED 812 ENVIRONMENT

OJET Framework

 

33529478

SPECIAL CHARACTER ISSUE IN THE DISPOSITION SCREEN

OJET Framework

 

33507117

SORTING OF RECORDS DOES NOT HAPPEN CORRECTLY ON THE ALERT DETAILS TAB

OJET Framework

 

33372731

SAVE FAILS WHEN THE TEXT CONTAINS SQL KEYWORDS

OJET Framework

 

33068910

THE ALERT DETAIL TAB DOES NOT DISPLAY THE CUSTOMER ACCOUNT SECTION

OJET Framework

 

33263507

UNABLE TO UPLOAD DOCUMENT WITH THE EXTENSION .XLSX WITH FORMULAS EMBEDDED IN IT

OJET Framework

 

33086823

THE ALERT DETAILS TAB SHOWS DIFFERENT DATA SECTIONS FOR DIFFERENT ALERTS

OJET Framework

 

33086737

SORTING LISTS CAUSES DATA TO DISAPPEAR ON THE ALERT SEARCH SCREEN

OJET Framework

 

32798458

GDPR REDACTION REQUIREMENT FOR FFW

OJET Framework

 

32494795

FILE DATA SOURCE SAVE FAILS

OJET Framework

 

33274430

SORTING ISSUES WITH ALERT ID

Operations

Batch Maintenance

32604841

ENHANCEMENT REQUEST FOR BATCH DESCRIPTION FIELD TO ACCEPT MORE SPECIAL CHARACTERS

Operations

Batch Monitor

33071613

THE VIEW LOG SCREEN IN THE BATCH MONITOR IS BLANK WHEN THE PASSPHRASE IS NA FOR PUBLIC-KEY AUTHENTICATION

Operations

External Scheduler Interface Component

33252482

ESIC RETURNS WRONG STATUS OF EXIT STATUS = 0 WHEN USING DUPLICATE EXTERNAL BATCH ID

Operations

External Scheduler Interface Component

33051965

THE MRE FILE FAILS TO GENERATE RUN ID FOR THE BATCH

Preferences

 

32686836

ISSUE IN GLOBAL PREFERENCES

Process Modeller Framework

 

32611050

ERRORS LOGGED IN THE CATALINA.OUT FILE  AFTER INSTALLING THE LRS 8.1 MODULE

Process Modeller Framework

 

33307718

THE INBOX FEATURE SCREEN DOES NOT LOAD AFTER THE CONSOLE WAS CLEARED

Process Modeller Framework

 

33067314

PMF DOES NOT PASS $RUNID, $PHID, $EXEID, $RUNSK TO THE RUN EXECUTABLE COMPONENT

Questionnaire

 

33252138

QUESTIONNAIRE URL REDIRECTS TO THE FCCM LANDING PAGE

Rules Framework

 

33342931

UNABLE TO SAVE/EDIT THE RRF PROCESS, WHEN THE CHARACTER “:” IS AVAILABLE IN THE IPE METADATA DEFINITION

Rules Framework

 

32859261

SANCTIONS 811 PR2 SERVICE FAILURE, ERROR OBSERVED IN EXECUTING THE IPE TASK IN RUN

Rules Framework

Rules

32859668

RUN EXECUTION THROUGH PMF FAILS BECAUSE OF THE DIM_RUN_SEQUENCE SEQUENCE CREATION AT RUNTIME

Security Management System

Security Management System

33280132

ENABLE USER LINK SHOULD ALLOW ENABLED USER TO CLEAR THE USER STATION ALONG WITH THE EXISTING FUNCTIONALITY

System Configuration

Configuration

33095538

ALLOW MORE CHARACTERS IN THE USER PASSWORD FIELD

Unified Metadata Manager

Technical Metadata Management

32955592

SHOWS "ERROR EXECUTING PRE-LOADING STEPS JAVA.SQL.SQLEXCEPTION: INVALID COLUMN INDEX" MESSAGE WHILE RUNNING THE DATA_TRANSFORMATION TASK

Unified Metadata Manager

Technical Metadata Management

32859502

'NO ENTITY COLUMN MAPPED' ERROR WHILE SAVING T2T

Unified Metadata Manager

Technical Metadata Management

32841999

THE T2T EXECUTION FAILS AND GENERATES THE CORE DUMP FILE RANDOMLY DUE TO ISSUES IN CLOB SUPPORT

Unified Metadata Manager

Technical Metadata Management

32797029

THE H2T LOAD TYPE WITH SQOOP EXECUTION FAILS IN AAI 8074

Unified Metadata Manager

Technical Metadata Management

33332127

CUSTOMIZE THE T2F EXTRACT PATH LOCATION

Unified Metadata Manager

Technical Metadata Management

33284968

IN DMT, DOCKER UTILITY LOGS CLIENT IP IN THE CONSOLE AND LOG FILES

Unified Metadata Manager

Technical Metadata Management

32585794

AN INVALID ERROR IS THROWN WHEN THE EXTERNAL LIBRARY DTS HAS "./" CHARACTERS

Unified Metadata Manager

Technical Metadata Management

32585774

INVALID PLC CODE VALIDATION FOR EXTERNAL LIBRARY TYPE PLC

Unified Metadata Manager

Technical Metadata Management

32712063

THE F2T BATCH FAILS AFTER UPGRADING TO AAI 8.0.7.4

Workflow

 

33308127

THE ACTIVITY EXECUTION LOG TO BE ENHANCED FOR HTTP 400,404 AND 500 ERRORS

Workflow

 

33159588

PROVIDE CAPABILITY TO SEND A MESSAGE TO JMS CLIENT

Workflow

 

33092678

MISSING ENTRY IN THE AUDIT HISTORY TAB

Workflow

 

33086813

PMF PROCESS MUST NOT BE INVOKED THROUGH THE REST API WITHOUT A VALID OBJECT TYPE

Workflow

 

33086322

THE ACTIVITY EXECUTION LOG DISPLAYED IN THE PROCESS MONITOR SCREEN IS NOT COMPLETE

Workflow

 

32910449

THE TOMCAT SERVER DOES NOT SHUT DOWN ON ISSUING THE SHUTDOWN COMMAND

 


Oracle Financial Services Software   |   Copyright 2021, Oracle and/or its affiliates. All rights reserved.   |   Phone: +1.650.506.7000   |   Fax: +1.650.506.7200   |   www.oracle.com/industries/financial-services/index.html