Oracle Financial Services Advanced Analytical Applications Infrastructure -Application Pack v8.0.0.0.0 Minor Release #5 (8.0.5.0.0)

Description

OFS AAAI Application Pack v8.0.0.0.0 Minor Release #5 8.0.5.0.0 (ID 25873206)

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

Additional Licensing Information

To use the Distributed AM Processing feature, explained in the New Features in This Release section, additional licenses may apply.

For details, contact My Oracle Support.

Prerequisites

The minimum patch set level should be OFS AAAI Application Pack v8.0.0.0.0 or OFS AAAI Application Pack v8.0.2.0.0 (using Full Installer). 

How to Apply This Release?

For detailed instructions on installing this OFS AAAI Release, see OFS AAAI Application Pack Installation and Configuration Guide 8.0.5.0.0.

Starting 8.0.0.0.0 release, OFSAA applications are packaged and released as Application Packs. OFS AAAI Application Pack includes Financial Services Analytical Applications Infrastructure, Financial Services Big Data Processing, Financial Services Enterprise Modeling, and Financial Services Inline Processing Engine. Refer to the subsequent sections for more details.

·         Oracle Financial Services Analytical Applications Infrastructure

·         Oracle Financial Services Big Data Processing

·         Oracle Financial Services Enterprise Modeling

·         Oracle Financial Services Inline Processing Engine

Oracle Financial Services Analytical Applications Infrastructure

This section includes the following sub-sections:

·         New Features in This Release

·         List of Bugs Fixed in This Release

·         Limitations/Known Issues in This Release

New Features in This Release

Following is the list of new features incorporated in this release. For detailed information on usage of these features, see OFS Analytical Applications Infrastructure User Guide 8.0.5.0.0.

1.          Model Upload

·         Model-upload functionality now supports moving the model encoding and DDL scripts  from one environment to another environment (For e.g. from Dev to UAT), so that the model upload process need not have to be repeated and object registration can be done directly on the target. To indicate this functionality, Data Model Descriptor has been added as a model upload option in the Model Upload UI. This option is used to resume model upload process from the logical data model in the form of OFSAA Data Model Descriptor file (Database.XML).

·         An option to print DDL statements in to execution log file is introduced.

·         An option to use Session Parameters and Hints during model upload process is introduced.

·         OFSAAI supports ERwin version 9.7 generated XMLs in Model Upload process.

2.          Data Management Tool

·         BATCH_RUN_ID as a parameter can be passed in a Data Mapping definition.

·         Support of HINT for table to file extraction (T2F) is introduced.

3.          Data Quality Framework

·         Resave button is introduced in the DQ Rules summary screen, which allows user to regenerate the query for multiple DQ Rules.

4.          Operations

·         Support of Distributed AM Processing is introduced where AM engine can be configured to run on multiple nodes and Batch Tasks now get distributed across AM engines running on multiple nodes. This can be achieved either by configuring OFSAA instance through load balancer or manually segregating Batch task to run on specific AM engine.

·         Crash handling of backend servers is introduced. During a batch execution if the Activation Manager (AM) server goes down, as soon as it comes up, the status of all the tasks in that batch will become Indeterminate.

·         For load balancing, different tasks in a Batch can be executed through different nodes in AM server. For more information on how to configure secondary AM server, see OFS Analytical Applications Infrastructure Administration Guide.

·         An option to purge or delete the Logs under View Log is introduced through ESIC.

5.          System Configuration and Identity Management

·         The number of characters allowed for User Name is increased to 100 from 60.

6.          Excel Upload

·         A source column in excel upload can be mapped to multiple columns in the target table.

7.          Business Metadata Management

·         Option to provide SQL Hints and degree of parallelism in Derived Entity has been introduced. This is also part of 8.0.4.1.0 ML.

8.           Object Migration Utility

·         The utility is enhanced to include a new parameter called IncludeInstances to migrate instance data along with the object.

9.          Process Modelling Framework (PMF)

·         Support of Run, Batch, Interactive, Workflow (human and automated tasks), and also mixing of the various modes of orchestration within a process flow

·         Support of PMF executions (tasks) for runtime parameters

·         Ability to create ICC batch with component as PMF pipeline

·         While migrating PMF Process, you can configure new parameter called “IncludeInstances” to “Y”, to migrate questionnaire instance data along with the PMF process. 

10.       Metadata Browser (MDB)

·         Supports MDB in Google Chrome and Firefox in addition to Internet Explorer

·         MDB Publish of Data Sources, that is, publish of External Source Table / Column, object IDs must match IDs of Model upload table, if the Data Source is an existing Infodom.

11.       Questionnaire

·         Questionnaire component introduces Review Questionnaire functionality, which enables n-eyes layers of security (maker / checker) for approval of Questionnaires.

·         Questionnaire introduces Online Help to enhance usability support.

·         Questionnaire does not allow modification of Questionnaire Configuration Attribute, which ensures the integrity of Questionnaire data.

·         Object Migration of Questionnaires and dependent objects is supported.

·         Unique ID implementation across questionnaire is introduced.

·         While the Questionnaire is in ‘Pending Approval’ status or ‘Open’ status, editing of mapped attributes is not supported.

List of Bugs Fixed in This Release

Component

Sub Component

Bug No

Subject

Administration

Security Management

25692678

FAILED LDAP LOGIN EVENT IS NOT REGISTERING IP ADDRESS

26284456

SMS USERS MARKED AS DELETED/DISABLED SHOULD NOT BE ALLOWED TO LOGIN IN LDAP AUTH

26277932

PREFERENCES LINK IN OFSAA APPLICATION PAGE IS NOT OPENING

-

26305505

LDAP-AFTER UNCHECK "MULTIPLE LOGIN", USER STILL CAN LOGIN MULTIPLE TIMES

26301774

AUDIT TRAIL REPORT SHOWS PROXY IP INSTEAD OF CLIENT IP

26272716

DUPLICATE DATA IN USER PROFILE REPORT

Data Entry Forms and Queries

Excel Upload

25685008

CANNOT DOWNLOAD EXCEL FILE ON EXCEL-ENTRY MAPPINGS SUMMARY

-

26273115

EXCEL-ENTITY MAPPING SCREEN HANGS ON APACHE TOMCAT 8.0.39

Forms Designer

25859807

LIST DISPLAY OF AVAILABLE FIELDS IN FORMS DESIGNER SCREEN

Dimension Management

Attribute

26182107

NOTHING TO SAVE ERROR WHEN EDITING DIMENSION MEMBER ATTRIBUTE VALUES

Member

26475547

NOTHING TO SAVE ERROR: WHEN EDITING MEMBER ATTRIBUTES WITH DROP DOWN.

-

26278872

TOOLTIPS NOT AVAILABLE IN SOME OFSAA 8.0.X MENUS

26136045

MEMBER : NOT ABLE TO SAVE MEMBER WITH DIMENSION HAVING ATTRIBUTES

Filter

Filter Hierarchy

26329890

UNABLE TO LOAD THE HIERARCHY IN THE HIERARCHY FILTER CREATION SCREEN

Filter Group

26273659

NOT ABLE TO VIEW DETAILS OF GROUP FILTERS IN ALLOCATION SPECIFICATION

Unified Metadata Manager

Business Metadata Management

26414750

METADATA TREE SHUTTLE IS NOT LOADING ON DERIVED ENTITY CREATION PAGE

26280465

HTTP 400 BAD REQUEST WHILE EDITING DATA SETS IN TOMCAT 8.0.39

Data Quality Definition

26285277

THRESHOLD QUERY FETCHES WRONG COUNT OF IMPACTED RECORD IF FILTER IS NOT PRESENT

Data Quality Group

26405311

THRESHOLD IS BREACHED AND FAIL IF THRESHOLD IS N, NOT POPULATING RESULT TABLES

22865028

OBJECT MIGRATION DQ GROUP SEQUENCE ISSUE

26188382

DQ RULE EXECUTION FAILS WHEN RULE FILTER CONTAINS SUBQUERY

Forms Framework

Forms Rendering Engine

26194950

COMPAREDATES FUNCTION NOT WORKING WHEN DATE FORMAT IS DD-MON-YYYY

Forms: ROR

26279278

IF HELP TEXT CONTAINS SPECIAL/NEWLINE CHARACTERS, APPEARS WRONG TEXT IN FRONTEND

-

26443289

OK BUTTON DOES NOT WORK IN TAB CHOOSER WINDOW OF ATTACHMENTS OF CASE HISTORY-SCB

26196009

DEVELOPER MODE ENABLED IN CHROME STANDARDS MODE

25880925

USERID AND PASSWORD SHOULD BE REMOVED FROM UPLOADSERVLET REQUEST

25694926

TABS REFRESH WITH SAVED FIELD CHOOSE PREFERENCES

25641147

UNABLE TO SELECT NODE IN INLINE HIERARCHY IN STANDARD MODE

25610805

GAP IS COMING B/W THE LAST COLUMN & THE VERTICAL SCROLL BAR IN GRID WITH SPAN

25555424

EXPORT EXCEL EXPORTS 2ND LEVEL HEADER INFO EVEN IF COL_SPAN TAG IS N

25555215

EXPORT TO EXCEL NOT WORKING IF WE HAVE & SIGN IN THE GRID HEADER IN ALL BROWSERS

25089276

PAGINATION LIST STAYS ALWAYS ON AFTER CLICKING ONCE

26374714

'GROUP BY TAB' AND 'GROUP BY' FUNCTIONALITY ISSUE

26318832

CALENDAR POPUP IS NOT CLOSING EVEN AFTER NAVIGATING FROM ONE PAGE TO ANOTHER

26318781

OFSOR- INCIDENT NAME IS GETTING TRIMMED OUT AT THE END

26264927

E-FILE STATUS TAB IN CRR IS KEEP LOADING DUE TO EXPRESSION CONTROL

26127075

LOGICAL FILENAME IS NOT ENCODED PROPERLY IN FILE UPLOAD

26099767

REMOVAL OF UNUSED JS FILE REFERENCE FROM RICH TEXT CONTROL

25634749

CONTEXT HELP IS NOT WORKING

25610841

SPACE IS COMING BETWEEN VIEWS ICON & VIEW OPTION IN E-FILE TAB IN ALL BROWSERS

25610292

HIERARCHY IS NOT HOLDING CODE VALUE IN _CODE HIDDEN WHEN PASSED AS NEXT.CONTR

25610199

GRID VALIDATION NOT WORKING PROPERLY IN EDITABLE GRID ONCE PAGINATION IS CLICKED

25594241

CASTR- RR LANDING PAGE IS NOT LOADING

26392373

DUPLICATE COLUMN NAME ERROR WHILE RUNNING THE BATCH

25549180

LANDINGPAGE.JSP SIZE LIMIT EXCEEDED BY 65535 BYTES

GRC Infrastructure

Business Restructure

26077443

BUSINESS RESTRUCTURE NEEDS TO BE COMPLETELY INTEGRATED WITH PMF

Model Upload

-

23492289

8.0.2 MODEL UPLOAD HANGS INSTEAD OF COMPLETING WITH FAILURE AND ERRORS

-

26414286

VIEW LOG IS NOT WORKING IN MODEL UPLOAD SUMMARY SCREEN

Operations

26356882

ESIC INPUT DATE TO BE VALIDATED

Batch Maintenance

25529956

TASK BOUNDARIES RENDERING ISSUE

Other

-

26481196

SAVE METADATA SCREEN HAVE UI DISPLAY ISSUE

25907834

MULTITHREAD SUPPORT FOR LIBDATABASE

Rules Framework

Rules

25923265

UNABLE TO ADD MORE THAN 100 CHARACTERS FOR MERGE HINTS AND SELECT HINTS

26399489

RRF SCREEN ALIGNMENT ISSUE

Code related to restore

25923726

PR2_RUN_EXECUTION_B TABLE CONSTRAINT LEFT DISABLED ON RUN IMPORT FAILURE

-

26082176

PR2 SCREENS IN METADATA DIFFERENCE

Manage Run Execution 

26196183

WSMREREQUEST.SH IS CREATING MRE FILE FOR A DELETED RUN

25876518

.MRE FILE IS NOT GETTING CREATED WHEN EXECUTED WSMREREQUEST.SH

Install and Upgrade Issues

-

26044391

ERROR: IMPROPER CONFIGURATION OF SCHEMA_IN.XML AFTER APPLYING PATCH 22930093

Style Issues

-

26476113

OJFFW - IE11 PAGE SCROLL ISSUE FOR FCCM

Security Management System

-

25921947

USER GROUP ,GROUP ROLE MAP, FUNCTION ROLE MAP NO SCROLL BARS & RESIZE OPTION

System Configuration

-

26435848

GETAPPNAME API TO BE ENHANCED TO GIVE LOCALE SPECIFIC APPLICATION NAME

26327469

ADD,EDIT,VIEW LINKS ARE NOT PRESENT FOR ADDING ALIAS NAME IN DATABASE DETAILS

ABC

Questionnaire 

26476275

CSRF-QUESTIONNAIRE LIBRARY SCREEN WHEN CLICKED APPROVED SHOWS SECURITY ISSUE

26382314

WARNING MESSAGE CORRECTION REQUIRED WHEN MOVING TO IN-REVIEW

26382055

PREVIOUS VERSION OF QUESTIONNAIRE(OPEN) IS NOT AVAILABLE TO RESPOND

26239181

SPECIAL CHARACTER ISSUE WITH ATTRIBUTE_CODE

25989560

APP LEVEL ATTRIBUTE CREATION COPIES THE SAME ATTRIBUTE CODE TO ALL THE COMPONENT

24747877

COPY QUESTION IS NOT WORKING FOR DYNAMIC QUESTIONS

24412647

BRANCHING ENABLED QUESTIONNAIRE MOVED TO OPEN WITHOUT BRANCHING LOGIC SET

Process Modelling Framework

26413341

RUNS ARE NOT LISTED IN PMF RUN ACTIVITY FOR TOMCAT SETUP

26303425

PMF MODULE CREATING HOGGING THREADS IN WEBLOGIC SERVER

26194191

SUB PROCESS ACTIVITY DOES NOT LIST PROCESSES IN PROCESSID DROPDOWN IN ITS DETAILS

26106172

REASSIGN DOES NOT WORK

26005947

PDF RECEIVED FOR BULK MAIL CANNOT BE OPENED

25971593

PARAMETER PASSED THROUGH PMF ARE NOT IN ORDER THEY WERE GIVEN IN UI

25971578

WHEN PROCESS IS DELETED DATAFIELDS ARE DELETED WITH NAME

25965508

BATCH DOES NOT INITIATE PROCESS EXECUTION

25965400

RUN SAVED DOES NOT DISPLAY IN UI

25965343

NOT ABLE TO EDIT RUN PARAMETER SELECTED

25952164

FULL INSTALLER DOES NOT HAVE PMF JAR IN FICDB

24436990

REASSIGN DOES NOT WORK AND ISSUES WITH INBOX SEARCH

24405868

COMMITTEE APPROVAL DOES NOT WORK IN 8.1

23533606

AFTER COMMITTEE APPROVAL TASK FOR OTHER ACTIVITY ARE NOT SENT

21618685

PROCESS MODELLING FRAMEWORK HAS  A JAR CONFLICT WITH FCCM APPLICATION

Limitations/Known Issues in This Release

·         Attributes should not be edited (other than Attribute Name) if it is linked to a Questionnaire irrespective of the Questionnaire status.

·         Migrating workflow instance data on the basis of Questionnaire ID is not available.

·         Incremental migration of Questionnaire instance data is not possible; that is, once workflow instances are migrated, you cannot migrate it again for newly created Questionnaires.

Oracle Financial Services Big Data Processing

New Features in This Release   

Following is the list of new features incorporated in this release. For detailed information on usage of these features, refer to OFS Analytical Applications Infrastructure User Guide 8.0.5.0.0.

OFS Enterprise Modeling

·         Support of ORAAH  (Oracle R Advanced Analytics for Hadoop) 2.7

List of Bugs Fixed in This Release

Component

Sub Component

Bug No

Subject

Model Upload

-

26419558

MODEL UPLOAD IS FAILING IN HIVE INFODOM

Advanced Analytics Infrastructure

Model

25053035

HIVE CONNECTION USING ORAAH 2.6 VERSION NOT WORKING IN KERBEROS CLUSTER.

Limitations/Known Issues in This Release

For H2H Data Mapping definition, if the source and target are pointing to two different Hive Schemas, it is mandatory to prefix the source schema name to the table. Otherwise, the execution will fail.

Oracle Financial Services Enterprise Modeling

List of Bugs Fixed in This Release

Component

Sub Component

Bug No

Subject

Advanced Analytics Infrastructure

-

26428855

MODEL QUERY VALIDATION

Oracle Financial Services Inline Processing Engine

New Features in This Release

Following is the list of features incorporated in this release. For detailed information on usage of these features, refer to OFS Inline Processing Engine User Guide 8.0.5.0.0.

·         Introduced add Parameter functionality from the IPE UI

·         Supports multi-select saving of Evaluations

·         Supports authentication using the AAI rest service

·         Introduced tables for Profiles for batch mode processing

·         Functionality to detect duplicate entries in activity in real time mode in IPE and notify client

·         Supports change in Score flag for Batch database processing

·         Introduction of adding technical parameters to include hints

·         Capability to support score rounding in real-time Evaluations.

·         Supports changes in DDL and DML to support gathering of stats between Assessment and Highlights

·         Supports Connection level setting in IPE Batch Execution

·         Capability to plug in stored procedure calls between Assessments and Highlights execution

·         Highlights query having batch filter on activity table.

·         Supports migration of IPE metadata if the associated expression is used in a dataset.

·         IPE needs to add a flag which will decide if the process manager will persist or not.

List of Bugs Fixed in This Release

Component

Sub Component

Bug No

Subject

Inline Processing

Inline Processing Web

24572665

CHANGES MADE TO BUSINESS ENTITY DOES NOT EDIT THE STATUS OF EXPRESSION TO INVALID

24572564

DO NOT ALLOW DELETING AN EXPRESSION WHEN IT IS USED IN ANOTHER EXPRESSION

24572485

TABLE DISPLAYED IN THE IMPORT ENTITY LIST  EVEN AFTER IMPORTING IT

24396343

SCORE, INLINE DATASET NAME, TRAVERSAL PATH NAME COLUMNS ARE NOT DISPLAYED COMPLETELY

24396331

NO TOOLTIP DSPLYD AFTER15 CHARS, FOR PROCESSING SEG COLUMN ON EXPRESSION GRID

23186176

WILD CARD SEARCH IS NOT WORKING ON IMPORT ENTITY SEARCH GRID

-

26091755

IPE: MULTI SELECT SAVE OPTION NOT WORKING AS REQUIRED FOR EVALUATIONS

26029430

SCRIPT SNIPPET USED FOR TABLE CREATION SHOULD NOT HAVE EMPTY LINE BETWEEN BRACKETS

26091951

CHANGE DESCRIPTION SHOULD BE ENABLED ONLY WHEN THE USER SELECTS THE CHECK UNDER EVALUATIONS TAB