Oracle Logo

Financial Services Advanced Analytical Applications Infrastructure Application Pack v8.1.2.0.0 Maintenance Release #1 (v8.1.2.1.0)

OFS AAAI Application Pack v8.1.2.0.0 Maintenance Release #1 8.1.2.1.0 (ID 33865657)

This release of the OFS AAAI Application Pack is cumulative of all enhancements and bug fixes completed since the v8.1.2.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.2.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.1.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.2.x User Documentation Online Web Page.

1.        Unified Metadata Manager

The enhancements are as follows:

·       Enhanced Null and Blank DQ checks for timestamp columns.

o   In the Table to Table (T2T) functionality, batch size is configurable.

2.       System Configuration

·       PORT C.SH UTILITY.can be run without any input parameters

·       The Security Header configuration is now moved from web.xml to Database.

3.       Security Management System

Enhanced JIT PROVISIONING for User and User Group Mappings to support the application specific User Entitlements and Attributes.

4.      Administration

·       OFSAA refresh automation:

o   Support to modify the password of OMCSADMINISTRATION , SYSADMN, and SYSAUTH users using commandline utility.

·       Support to create a user name with a multibyte character.

·       User Status Report is enhanced to show the additional attributes.

·       User Access Report is enhanced with additional search criteria.

·       Added User Group Map Report.

·       On successful login, the number of failed logins is displayed.

5.       Questionnaire

Support of token-based approach in questionnaire response.

6.      Data Maintenance Interface

·       Enablement of Tree View for Designer.

·       Enabled Background processing logic when Excel data is uploaded with Auto Approve.

·       Introduced a process to restrict a row specified number of times only (Row Modification limiter).

·       Introduced a process to restrict a set of columns in a row specified number of times only (Column Modification limiter)

·       Supported re-upload of an Excel form.

NOTES: To use this feature:

·       You must apply the mandatory patch 34794130 on top of installing the 8.1.2.1.0 ML.

·       Oracle Financial Services Analytical Applications Infrastructure Extension Pack (OFS AAIEP) is required. For more details, refer to OFS AAIEP Release Notes.

Library Upgrade Information

The following is the list of libraries that are upgraded in this release:

·       APACHE KAFKA updated to 3.1.0

·       APACHE XERCES updated to 2.12.2

·       COMMONS-COMPRESS updated to 1.21

·       COMMONS-IO updated to 2.8.0

·       SPRING FRAMEWORK updated to 5.3.19

·       LOG4J updated to 2.17.1

·       CKEDITOR updated to 4.17.1

List of One-Offs Regularized in This Release

The One-Offs regularized in this release are as follows:

One-offs Released on v8.1.2.0.0

Component

Sub-component

One-Off Patch Number

Bug ID

Description

OPERATIONS

 

8.1.2.0.8

34080950

FP BATCH EXECUTION FAILS IN RHEL

SECURITY MANAGEMENT SYSTEM

 

8.1.2.0.9

34019691

JIT ENHANCEMENT TO SUPPORT APP SPECIFIC USER ENTITLEMENTS/ATTRIBUTES

OTHERS

 

8.1.2.0.3

33738222

STANDARD UPGRADE OF LIBRARIES FOR COMMON USAGE IN OFSAA ON V8.1.2 - JAN-2022

OJET FRAMEWORK

 

8.1.2.0.6

33649681

CONSOLIDATED FIX FOR NEW WAVE THEME ON V812

ADMINISTRATION

 

8.1.2.0.1

33533733

UNABLE TO CREATE USER NAME WITH SPECIAL CHARACTERS (Ø)

ADMINISTRATION

SECURITY MANAGEMENT

8.1.2.0.5

33481890

ENH NEED ADDITIONAL INFORMATION IN THE USER STATUS REPORT

ADMINISTRATION

SECURITY MANAGEMENT

8.1.2.0.5

33446723

USER STATUS REPORT AND USER ACCESS CHANGES

ADMINISTRATION

SECURITY MANAGEMENT

8.1.2.0.5

33150367

ENH NEED ADDITIONAL INFORMATION IN THE USER ATTRIBUTE AND USER GROUP - USER MAP REPORTS

ADMINISTRATION

SECURITY MANAGEMENT

8.1.2.0.4

32766345

SCRIPT RESETPASS.SH DOES NOT CONSIDER THE PASSWORD RESTRICTIONS DEFINED IN SYSTEM CONFIGURATION SCREEN

ADMINISTRATION

 

8.1.2.0.2

31313960

MOVE SECURITY HEADER CONFIG FROM WEB.XML TO DB

 

List of Bugs Fixed in this Release

The following bugs are fixed in this release.

Component

Sub-component

Bug ID

Description

QUESTIONNAIRE

34223828

RFI RESPONSE PAGE IS BLANK - CONSOLE SHOWS -COMMONSECURITYFUNCTIONS.JS:1 - FAILED TO LOAD RESOURCE: THE SERVER RESPONDED WITH A STATUS OF 500 (INTERNAL SERVER ERROR)

METADATA

34213482

DATA SOURCE RESAVE AND T2T RESAVE CAUSES CURSOR LEAK

METADATA

 

33908369

GENERIC - T2T'S SHOULD HAVE A PLACEHOLDER FOR MIS DATE SKEY

METADATA

 

33633984

NOT ABLE TO SAVE DQ RULES HAVING ESCAPE CHARACTERS IN THE DESCRIPTION FIELD

OTHER

 

34195109

ISSUE WITH ISNEWWAVECSSREQ PARAMETER WHILE LOADING INDEX.JSP

UNIFIED METADATA MANAGER

34128186

RULE ENGINE TO HAVE PLACEHOLDER FOR MIS DATE SKEY

UNIFIED METADATA MANAGER

DQ FRAMEWORK

33980519

ENABLE NULL AND BLANK DQ CHECKS TO BE DEFINED ON A TIMESTAMP COLUMN

WORKFLOW

33875133

SELF LOOP NOT GETTING DELETED

INSTALL AND UPGRADE ISSUES

 

34013065

ERROR PRESENT IN THE SCHEMA CREATOR LOGS DURING UPGRADE INSTALLATION 8101 TO 812

INSTALL AND UPGRADE ISSUES

SERVICE PACKS

33734636

OFSAAI 8.1.2 AAAI PATCH 32791983 DOES NOT WORK WITH WALLET

OJET FRAMEWORK

 

34189726

ECM - THP UI ISSUES - SPAN HEADER IS GOING TOWARDS RIGHT

OJET FRAMEWORK

 

34174802

BD8121-RESET BUTTON IN ALERT SEARCH PAGE IS NOT WORKING AFTER MANUAL ENTRY IN SEARCH CRITERIA

OJET FRAMEWORK

 

34143598

SECONDARY LEVEL POPUP'S GRID SIZE IS FIXED,WHEN ENLARGING IT SHOWS BLANK SPACE

OJET FRAMEWORK

 

34127249

COLUMN HEADER NAME IS NOT VISIBLE IF COLUMN NAME IS BIG IN THE GRID

OJET FRAMEWORK

 

34127212

GRID IS GETTING HIDING AFTER EXPORT OPERATIONSATION IN TRANSACTION TAB

OJET FRAMEWORK

 

34042935

THE CKEDITOR IS COMING BLANK IN NARRATIVE TAB

OJET FRAMEWORK

 

34025301

UPGRADE OF OJET FRAMEWORK TO 12.0.0

OJET FRAMEWORK

 

33992551

ATTACHMENT LIST POP-UP GETS DISPLAYED BEHIND THE AUDIT HISTORY WINDOW

OJET FRAMEWORK

 

33844474

NARRATIVE SPELL CHECK POP-UP HANGS THE APPLICATION

OJET FRAMEWORK

 

34217265

IF ANY TAB HAS 150 CONTROL TYPE, THEN TAB HEADERS ARE NOT DRAWING PROPERATIONSLY

DATA MAINTENANCE INTERFACE

 

33716735

EXCEL PREVIEW IS NOT WORKING WITH RESPECT TO THE SELECTED COLUMNS IN MAPPED ATTRIBUTES.

DATA MAINTENANCE INTERFACE

33611805

DMI-LOADING PROGRESS SHOULD BE SHOWN/UI SHOULD BE DISABLED WHILE PROCESSING THE REQUEST

DATA MAINTENANCE INTERFACE

33326609

DMI-USER SECURITY SHOULD HAVE ABILITY TO DELETE THE USERS UNDER THE GROUP

DATA MAINTENANCE INTERFACE

33309330

DMI VPAT OATB ISSUES

DATA MAINTENANCE INTERFACE

33299876

DMI VPAT KEYSTROKE ISSUES

DATA MAINTENANCE INTERFACE

33195663

DMI-NONE OF THE EXCEL AND DESIGN RECORDS ARE GETTING APPROVED.GETTING APPROVAL FAILED

DATA MAINTENANCE INTERFACE

33195653

DMI-AUDIT TRAIL IS NOT SHOWING PROPERATIONS ERRORS WHY THE RECORDS ARE FAILING

DATA MAINTENANCE INTERFACE

33158479

DMI_DATA ENTRY_DRAFT RECORDS ARE NOT GETTING DELETED

DATA MAINTENANCE INTERFACE

33148171

DMI - BULK AUTHORIZATION IS NOT IMPLEMENTED

DATA MAINTENANCE INTERFACE

33144431

DMI - DATA ENTRY ,UNABLE TO EDIT OR VIEW THE RECORD

DATA MAINTENANCE INTERFACE

33144352

DMI- EXCEL UPLOAD MAPPED ATTRIBUTES SCREEN IS NOT DISPLAYING DATA

DATA MAINTENANCE INTERFACE

33061981

DMI - FORMS DEFINITION IN AWAITING STATE CAN DELETED BY SELF

DATA MAINTENANCE INTERFACE

33046177

DMI - RECORDS ARE NOT GETTING INSERTED IN DB AFTER EXCEL UPLOAD

DATA MAINTENANCE INTERFACE

32998114

CNE - DMI - FORMS DEFINITION IN AWAITING STATE CAN DELETED BY SELF

DATA MAINTENANCE INTERFACE

DATA FORMS ENTRY

30912253

IN DATA MAINTENANCE >>SEARCH IS NOT WORKING

MODEL UPLOAD

 

34020496

DATAMODEL MODEL MAINTENANCE SHOULD THROW A CONFIRMATION POPUP

List of Bugs Fixed and Enhancements in Previous Releases Ported to This Release

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

Component

Sub-component

Bug ID

Description

ADMINISTRATION

SECURITY MANAGEMENT

34214791

IMPROVE SUCCESS / FAILURE RETURN STATUS FOR USER MANAGEMENT REST API

ADMINISTRATION

SECURITY MANAGEMENT

34117221

ENCOUNTERING A DYNAMIC VALUE IN THE WEB REQUEST WHICH IS NOT GENERATED BY THE APPLICATION SERVER.

ADMINISTRATION

 

34048139

F12 KEYPRESS OPENS THE BROWSER DEBUGGER TOOLS WINDOW IN FIREFOX

ADMINISTRATION

SECURITY MANAGEMENT

33989139

SCRIPT RESETPASS.SH DOES NOT CONSIDER THE PASSWORD RESTRICTIONS DEFINED IN SYSTEM CONFIGURATION SCREEN

ADMINISTRATION

OBJECT MIGRATION

33984280

IMPORT OBJECTS FAILS WITH 'FOLDER DOESN'T EXIST' ERROR WHEN FOLDER EXISTS

ADMINISTRATION

OBJECT MIGRATION

33321504

OBJECT MIGRATION IMPORT - VALUES OF IMPORT ALL, FAIL ON ERROR, OVERWRITE, RETAIN IDS ARE MANIPULATED AND SAVED AS N IN AAI_OBJMIG_OUTLINE_DEFINITION TABLE WHEN RESAVED AN ALREADY SAVED IMPORT DEFINITION.

SYSTEM CONFIGURATION

CONFIGURATION

34205964

SSO DOES NOT CONSIDER CSSECURITY MANAGEMENT SYSTEM_USR_PROFILE.D_USR_EXPIRY_DTE

LINK ANALYSIS

 

34188227

NETWORK ANALYSIS GRAPH CAN'T OPEN THE HIGHLIGHT OPTION

SECURITY MANAGEMENT SYSTEM

OBJECT SECURITY

34169801

UNABLE TO MAP USER TO USER WITH NUMERIC USER ID TO USER GROUP

PROCESS & ANALYTICAL PIPELINES

 

34169598

APPLICATION RULES CREATED IN PMF ARE NOT IMPORTING CORRECTLY

RULES FRAMEWORK

RULE EXECUTION ENGINE

34134405

OOB COMPUTATION RULE QUERY FORMING TAKING LONGER TIME

RULES FRAMEWORK

RUN

34240802

USER AUTHENTICATION FAILING IN ESIC THROUGH AUTOSYS ISSUES

RULES FRAMEWORK

RUN

33616593

CREATION OF DIM_RUN_SQUENCE SYNONYM IN ATOMIC SCHEMA

OPERATIONS

 

34047953

FP - BATCH EXECUTION FAILS IN RHEL

OPERATIONS

 

33985798

PAGINATION ISSUES IN SHOW DEPENDENCY UI LAUCHED FROM MEMBER SCREEN

QUESTIONNAIRE

 

34021819

ECM - RFI RESPONSE ATTACHMENT NOT SHOWING

PROCESS & ANALYTICAL PIPELINES

 

34001511

EXECUTING RUN PIPELINE THROUGH ICC FAILS WITH INSERT INTO DIM_RUN TABLE

PROCESS & ANALYTICAL PIPELINES

 

34001404

EXCEPTION WHILE EXECUTING EXTERNAL REST API RULE IN PMF WORKFLOW IN OFSAA 811 ENVIRONMENT

WORKFLOW

 

33965678

CS REAL-TIME REST CALL FAILS WITH SPECIAL CHARS IN RESPONSE JSON

WORKFLOW

 

33894443

APPLICATION RULE WINDOW IN PMF WORKFLOW IS NOT WORKING FOR THE OUT OF BOX RRS USFED WORKFLOW

OJET FRAMEWORK

 

34214003

DOCUMENT UPLOAD IS FAILING WHEN SPACE PRESENT BETWEEN DOC NAME AND DOT

OJET FRAMEWORK

 

34063148

COLUMN NAME IS BROKEN WHEN CLICK A HEADER OF GRID

OJET FRAMEWORK

 

34006395

LEAVE PAGE POPUP APPEARING ON CLICK OF PRINT PDF LINK

OJET FRAMEWORK

 

33958090

UNABLE TO EXPORT ALL THE RECORDS IN TRANSACTION TAB

UNIFIED METADATA MANAGER

DQ FRAMEWORK

33909691

ORA-01460: UNIMPLEMENTED OR UNREASONABLE CONVERSION REQUESTED FOR DQ EXECUTION

MODEL UPLOAD

 

33858892

OBJECT REGISTRATION ENTRIES ARE MISSING FOR TABLE/COLUMN UDPS

MODEL UPLOAD

 

33859416

UTILITY TO POPULATE AAI_DMM_METADATA FROM FIPJSON

MODEL UPLOAD

 

33984357

DATA MODEL UPLOAD IS FAILING AT INDEX CREATION ON APACHE HIVE ENVIRONMENT

 

 

Oracle Financial Services Software   |   Copyright 2022, 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