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 |