Oracle Financial Services Analytical Applications Infrastructure v8.0.2.0.0 Maintenance Level Release #2 (8.0.2.2.0)

Description

OFSAA 8.0.2.0.0 AAI ML RELEASE #2 8.0.2.2.0 (ID 26721783)

This Maintenance Level Release (ML) of OFS AAI is cumulative of enhancements and bug fixes done since the 8.0.2.0.0 Minor Release. This ML release of OFS AAI can be installed on a setup with any OFSAA 8.0.2.0.0 Application Pack.

Prerequisites

The minimum patch set level should be OFS AAI 8.0.2.0.0.

How to Apply This Maintenance Release?

For detailed instructions on installing this Maintenance Level release, see OFS AAI Installation Guide 8.0.2.2.0.

New Features in This Release

1.      Model Upload

·  Naming Convention of constraints (PK and FK) has been changed to resolve the following issues:

·  For tables with similar names which are relatively long (>27 characters) where initial few characters differ (for example, STG_COMMON_ACCOUNT_SUMMARY, FCT_COMMON_ACCOUNT_SUMMARY), the constraint names get generated as same causing an Oracle error of duplicate constraints.

·  When number of foreign keys for a table is more than 100, the length of the constraint name exceeds the permissible limits allowed by Oracle Database.

Update Constraints utility (23251358) is introduced to alter the existing constraint name references according to the new convention. A unique ID gets generated for each data model entities.  The new constraint name will be generated by appending the unique ID with ‘FK’ or ’PK’ (along with a sequence for FK). For example PK on DIM_ACCOUNT will be formed as PK_101, where 101 is the unique id of DIM_ACCOUNT. Similarly, FKs on FCT_ACCOUNT_SUMMARY will be FK_206_01, FK_206_02, FK_206_03, FK_206_04, where 206 is the unique id of FCT_ACCOUNT_SUMMARY and the table has 4 FKs.

For more information on this feature, see OFS AAI Installation Guide 8.0.2.2.0.

2.      Port Changer Utility

·  Shell script is provided to execute Port Changer utility. For more information, see OFS Analytical Applications Infrastructure Administration Guide.

List of One-Off’s Incorporated in This Release

Release

Component

Subcomponent

Bug

One-Off #

Subject

On 8.0.2.0.0  Release

Unified Metadata Manager

Business Metadata Management

22811206

8.0.2.0.16

DERIVED ENTITY THROUGH BATCH FRAMEWORK NOT FAILS IF ORIGINALLY FAILED

-

 23630277

8.0.2.0.17

IMPORT OF BP FAILS ON 8.0.2 ENVIRONMENT

Security Management System

-

23645276

8.0.2.0.18

DIRECT_LOGIN IS NOT WORKING WHEN SSO IS CONFIGURED

Forms Framework

-

24309494

8.0.2.0.19

COMMENTS ARE GETTING CUT IN VIEW MODE

Forms Manager

24007941

8.0.2.0.20

MASKING ISSUES IN FORMS MANAGER

Model Upload

-

23576168

8.0.2.0.21

OBJECT REGISTRATION FAILING WITH DUPLICATE FK NAME

Advanced Analytics Infrastructure

-

23709308

8.0.2.0.22

ERROR IN LOADING DATA TO SANDBOX

Forms Framework

Forms Manager

24293379

8.0.2.0.23

FORMS MANAGER ISSUE: LAYOUT TAG IS NOT GETTING INSERTED IN XML.

Unified Metadata Manager

Metadata Browser

23597656

8.0.2.0.25

EXPAND BUTTON MISSING IN MDB FOR DATASET AND BP POST 8.0.2 UPGRADE

Forms Framework

Forms Manager

24008794

8.0.2.0.26

ISSUE WHILE GENERATING THE FORM BY TWO USERS SIMULTANEOULSY

Unified Metadata Manager

Data Quality Group

23711170

8.0.2.0.27

DQ EXECUTION FAILS WITH A WRONG TABLE REFERENCE IN THE RULE COUNT QUERY

Forms Framework

Forms: ROR

24295638

8.0.2.0.28

POST 8.0.2 UPGRADE ISSUES WHEN HTML5 IS ENABLED

System Configuration

-

24597513

8.0.2.0.29

DISPLAY ERROR MESSAGES BASED ON ERROR CODE FOR LDAP LOGIN

Data Entry Forms and Queries

Data Entry

23741656

8.0.2.0.30

GETTING ORA-00907: MISSING RIGHT PARENTHESIS ERROR WHEN SEARCHING FOR '_' CHARS

Unified Metadata Manager

Metadata Browser

24432629

8.0.2.0.31

REG REPORTING : METADATA BROWSER VIEW/MDRM REFRESH

Forms Framework

Forms Manager

24360566

8.0.2.0.32

COPY CONTROL NOT WORKING FOR HIERARCHIES/BUTTONS

Install and Upgrade Issues

-

24962005

8.0.2.0.33

MLS UTILITY FAILS WITH ERROR FOR LOCALE_MESSAGE PROCEDURE FOR 802LP

Administration

Object Migration

24477162

8.0.2.0.34

IS THERE EXCLUDEURLLIST.CFG FOR OBJECT MIGRATION ITEMS?

Advanced Analytics Infrastructure

-

25061770

8.0.2.0.35

MR | MODELS(VAR/VOLATILITY) NOT EXECUTING FROM FRONTEND

Unified Metadata Manager

Technical Metadata Management

25290268

8.0.2.0.36

T2T FETCHING COUNT FOR BULK LOAD

Install and Upgrade Issues

-

22930093

8.0.2.0.37

SCHEMA CREATION FAILING ON OEL 7

Data Entry Forms and Queries

Data Entry

25244603

8.0.2.0.38

ALLOW AN EXTENDED SET OF SPECIAL CHARS IN DATA ENTRY FORMS

Inline Processing

-

23554438

8.0.2.0.39

FACING CHALLENGE IN ADDING EXPRESSION TO THE EVALUATION

Administration

Security Management

25433402

8.0.2.0.40

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

Unified Metadata Manager

Technical Metadata Management

25541771

8.0.2.0.41

LONG RUN TIME IN EXECUTION OF RBI CONTRACTUAL RUN

25187040

8.0.2.0.42

F2T FAILED WHEN ROW DELIMITER GIVEN AS \R\N:FAILED IN FUNCTION CHECK FOR DATA

Administration

Security Management

25687660

8.0.2.0.43

OFS BD 8.0.2: FAILED LOGIN EVENT IS NOT REGISTERING IP ADDRESS.

Advanced Analytics Infrastructure

Modeling

25951770

8.0.2.0.45

LIB DATABASE PLATFORM LIBRARY ISSUES IN MULTI THREADED APPLICATIONS.

Forms Framework

Forms Manager

22963421

8.0.2.0.46

INSERT/UPDATE OF TEMPLATE_JSP_MAPPING THROUGH FM FAILS

Link Analysis

-

20920008

8.0.2.0.47

LINK ANALYSIS CONTEXT MENU DOESN'T APPEAR & CALL BACK FUNCTION FOR NO DATA

On 8.0.2.1.0 Release

Model Upload

-

23014117

8.0.2.1.1

DM PROCESS IS FAILING WITH JAVA EXCEPTION WHILE GENERATING THE SQL FILES

Unified Metadata Manager

Data Quality Definition

24405268

8.0.2.1.2

DCDQ: CONSOLIDATED 1-OFF PATCH FOR RI CHECK

Model Upload

-

24390648

8.0.2.1.3

OBJECT REGISTRATION FAILING WITH DUPLICATE FK NAME

Unified Metadata Manager

Data Quality Definition

24586817

8.0.2.1.4

DQ EXECUTION FAILS WITH A WRONG TABLE REFERENCE IN THE RULE COUNT QUERY

24612061

8.0.2.1.5

DQ RI IMPORT FAILS FROM 7.3.5.1.0 TO 8.0.2.1.0

Forms Framework

-

24677032

8.0.2.1.6

BUSINESS TABS NOT COMING ON ALERT DETAIL SCREEN

-

24360127

8.0.2.1.7

FORMS FRAMEWORK IN STANDARDS MODE SUPPORT FOR BROWSERS SAFARI AND FIREFOX

Forms Manager

24792804

8.0.2.1.8

INTRODUCE LOGGER LEVEL FLAG IN FORMSMANAGER

-

24953475

8.0.2.1.9

COLSPAN HEADER NAME IS NOT VISIBLE IN HTML5 STANDARD MODE

Forms Framework

-

25055585

8.0.2.1.11

FORMS MANAGER :- NOT ABLE TO ADD VALIDATION ON CHANGE OF CONTROL VALUE

Administration

Security Management

25067952

8.0.2.1.12

V_ROLE_CODE LENGTH DIFFERENCE IN 8.0.2.1 CONFIG SCHEMA

Forms Framework

-

24911251

8.0.2.1.13

NOT ABLE TO ASSIGN NULL TO ANY VARIABLE USING FORMSMANAGER

Security Management System

-

25038240

8.0.2.1.14

VALIDATION OF OBJECT ACTION AT SERVICE LEVEL

Forms Framework

-

25053813

8.0.2.1.15

IN CASE HISTORY, JUMP TO PAGE IS NOT DISPLAYED PROPERLY

24970475

8.0.2.1.16

NEXT MONTH OR YEAR PAGINATION NOT AVAILABLE IN CALENDAR SELECTION IN ALL SCREENS

24970498

8.0.2.1.17

NUMBER OF CHARACTERS ARE NOT PROPERLY DISPLAYED WITHIN THE TEXT BOX

25053953

8.0.2.1.18

TRANSPOSING COLUMNS DOESN'T WORK PROPERLY UNDER CUSTOMER AND ACCOUNTS TABS

Unified Metadata Manager

Business Metadata Management

25076970

8.0.2.1.20

METADATA CACHE ON START UP TAKES 15 MINS TO COMPLETE

Metadata such as T2T, F2T, etc

T2T Issues

24358770

8.0.2.1.21

OFSAA 8.0.2 - SCREEN HANGS WHEN SAVING T2T WITH MANY ENTRIES

Administration

Security Management

25097372

8.0.2.1.22

SYSTEM RENDERS BLANK PAGE INSTEAD OF ERRROR MESSAGE WHEN WRONG CREDENTIALS GIVEN

Forms Framework

-

25206559

8.0.2.1.23

FORMS_APP_FILTER TABLE SHOULD HAVE COLUMN TO CAPTURE MANDATORY PARAMETERS

25175670

8.0.2.1.24

FORMS MANAGER : NO PLACEHOLDER FOR MIN AND MAX VALUE FOR NUMBER CONTROL

Forms Rendering Engine

24960721

8.0.2.1.25

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

Administration

SQL Rule

24480661

8.0.2.1.26

OFSAA SQL RULES DEFINITION CAN NOT ACCEPT PLUS (+) OPERATION

Security Management

24923239

8.0.2.1.27

UNABLE TO UPLOAD HTML FILE FROM FCCM SCREENS

Advanced Analytics Infrastructure

Stress Testing

23212801

8.0.2.1.28

SAVING A STRESS DEFINITION TAKES VERY LONG TIME (20 MINUTES TO 1 HOUR +)

Forms Framework

-

25336403

8.0.2.1.29

UNABLE TO SELECT NODE IN INLINE HIERARCHY IN STANDARD MODE

-

 

8.0.2.1.30

TABS REFRESH WITH SAVED FIELD CHOOSE PREFERENCES

Inline Processing

-

23582931

8.0.2.1.31

FACING CHALLENGE IN ADDING EXPRESSION TO THE EVALUATION

Forms Framework

-

25361076

8.0.2.1.32

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

25880388

8.0.2.1.33

USER CREDENTIALS SHOULD NOT BE PART OF SERVLET REQUEST

25206121

8.0.2.1.34

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

Advanced Analytics Infrastructure

Modeling

26040895

8.0.2.1.35

LIB DATABASE PLATFORM LIBRARY ISSUES IN MULTI THREADED APPLICATIONS.

Forms Framework

-

26098068

8.0.2.1.36

REMOVAL OF UNUSED JS FILE REFERENCE FROM RICH TEXT CONTROL

26126878

8.0.2.1.37

LOGICAL FILENAME IS NOT ENCODED PROPERLY IN FILE UPLOAD

25059602

8.0.2.1.38

PAGINATION LIST STAYS ALWAYS ON AFTER CLICKING ONCE

 

25930449

8.0.2.1.39

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

System Configuration

-

26236695

8.0.2.1.41

VALIDATION ERRORS IN EXCELDOWNLOADSERVLET, USERREPORTSSERVLET, MEDIAPACKSERVLET

Forms Framework

-

26310403

8.0.2.1.42

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

Forms Framework

-

26474111

8.0.2.1.43

UNABLE TO OPEN THE RECORDS IF DATA HAS ASCII CHARACTERS

Forms: ROR

25364825

8.0.2.1.44

PROBLEM AGAIN EXPORTING EXCEL FOR ONE ROW

Administration

Object Migration

26178599

8.0.2.1.45

COMMAND LINE OBJECT MIGRATION- NOT EXTRACTING MENU AND FEW COLUMNS

-

26434639

8.0.2.1.46

NEED VALIDATION FOR LOCALE REQUEST PARAMETER

System Configuration

-

26536941

8.0.2.1.47

PASSWORD ISSUE IN OFSAA

Forms Framework

Forms: KYC

26617330

8.0.2.1.48

CHINESE/THAIWAN CHARACTERS NOT WORKING IN HIERARCHY CONTROL NAME SEARCH.

System Configuration

Security Metadata Mapping

26642620

8.0.2.1.49

CHANGE IN PASSWORD AND USER DETAILS DOES NOT ALLOW USER TO LOGIN

Data Entry Forms and Queries

Forms Designer

25923451

8.0.2.1.50

SEARCH FUNCTIONALITY IS NOT WORKING PROPERLY IN DEFQ FORMS

Forms Framework

 

26620435

8.0.2.1.51

ALIGNMENT PROBLEM FOR DROPDOWN CONTROLS

Forms: ROR

26758109

8.0.2.1.52

UNABLE TO OPEN THE RECORDS IF DATA HAS ASCII CHARACTERS

-

26735553

8.0.2.1.53

DOWNLOADED ATTACHMENT FILE NAME NOT SHOWING CHINESE CHARACTER CORRECTLY

 

26978992

8.0.2.1.54

DOCUMENTS IN DOWNLOAD AREA NEEDS TO BE CLEARED AFTER DOCUMENT DOWNLOAD

Others

-

27041373

8.0.2.1.55

SESSION PERSISTENCE ISSUE

Forms Framework

-

26999688

8.0.2.1.56

DOCUMENT NAME IS COMING AS $USER$ DURING DOCUMENT UPLOAD

Administration

Security Management

26286179

8.0.2.1.57

CUMULATIVE FIXES IN AAI FOR BACKPORT OF 8040 FIXES

Forms Framework

-

27100760

8.0.2.1.58

DOCUMENT ATTACHMENT CAUSING LOCKS

Forms: ROR

27346246

8.0.2.1.59

HOUR GLASS SHOULD BE SHOWN DURING THE TIME OF BIG SIZE DOCUMENT UPLOAD

 

List of Bugs Fixed in This Release

Component

Sub-component

Bug

Subject

Unified Metadata Manager

Business Metadata Management

24605102

DUPLICATE ENTRIES ARE APPEARING IN VIEW MAPPING SCREEN

25985949

REMOVAL OF CONF FOLDER DEPENDENCY FOR DE, ESSBASE & ARCHIVE/RESTORE SCREENS

24431604

VIEW MAPPING SCREEN TAKES LONGER TIME TO LOAD AND CAUSES TIME OUT

Data Quality Definition

27336937

DISPLAY DATA QUALITY RULE QUERY PANEL ROLE-BASED

Filters

Hierarchy Filter

26516029

NEW OR EXISTING HIERARCHY FILTER HANGS LOADING HIERARCHY DETAILS

Forms Framework

Forms Rendering Engine

24295674

DYNAMIC HIERARCHY NODE LIMIT SHOULD BE CONFIGURABLE

24300876

HIERARCHY POPUP ISSUES

Forms: ROR

22345147

HOUR GLASS SHOULD BE SHOWN DURING THE TIME OF BIG SIZE DOCUMENT UPLOAD

23638465

NOT ABLE TO ASSIGN VALUE TO A LABEL CONTROL(CONTROL IN VIEW MODE) (TYPE=13)

-

24715261

IN EXCEL EXPORT SPAN HEADER SHOULD BE ALIGNED CENTRALLY

26075569

OFSOR- INCIDENT NAME IS GETTING TRIMMED OUT AT THE END

27210970

GRID EXPORT NOT WORKING IN NON HTML-5

Model Upload

-

24295015

REV_TAB_PARTITION TABLE IS POPULATED JUNK DATA AFTER IMPORT MODEL

Administration

Security Management

26077691

INCREASE MAX LENGTH FOR SSOHEADER TEXTBOX IN CONFIGURATION SCREEN

24814729

AUDIT TRAIL REPORT GENERATED IN UNREADABLE FORMAT FOR MULTIPLE GROUP MAPPING

Object Migration

23854145

CUSTOM DIMENSION’S MEMBER MIGRATION FAILS WHEN NO DATA IN THEIR ATTRIBUTE TABLE

Style

-

27335198

CSS OPTIMIZATION FOR OFSAAI LOGIN PAGE