This readme has the following sections:
· Oracle Financial Services Analytical Applications Infrastructure
· Oracle Financial Services Asset Liability Management
· Oracle Financial Services Asset Liability Management Analytics
OFSAA 8.0.6.0.0 ALM ML RELEASE #1 8.0.6.1.0 (ID 28480449)
This Maintenance Level Release (ML) of OFS ALM is cumulative of enhancements and bug fixes done since the 8.0.6.0.0 Minor Release. This ML release of OFS ALM can be installed on a setup with any OFSAA 8.0.6.0.0 Application Pack.
Prerequisite
The minimum patch set level should be OFS ALM 8.0.6.0.0.
How to Apply This Release?
For detailed instructions on installing this OFS ALM Release, please refer to Oracle Financial Services Asset Liability Management Application Pack Installation Guide 8.0.6.1.0.
Oracle Financial Services Analytical Applications Infrastructure
This section includes the following sub-sections:
·
New Features in This Release
· List of One-Off’s Incorporated 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.
· OJET based shuttle is implemented in DMT screens
· A UI is introduced to externalize the Optimization parameters like Source Hint, Source Prescript, Target Hint and Target Prescript for Data Mapping definitions
· Reset Field Order button is provided for all editable grids in DMT screens
· Parent Child (PC) based Hierarchy is supported in Hive Infodom
· While defining Hierarchy Filter, leaf nodes can be displayed in the ascending order of Member names by configuring AMHMConfig.properties file.
· Object Administration and Utilities Tiles are added in the Common Landing Page
· Existing AES encryption ECB mode cipher is upgraded to CBC mode.
· A UI is introduced for non SFTP authentication as LOCAL under System Configuration screen.
List of One-Off’s Incorporated in This Release
Release |
Component |
Subcomponent |
Bug |
One-Off # |
Subject |
Post 8.0.6.0.0 Release |
Install and Upgrade Issues |
- |
27938294 |
8.0.6.0.1 |
CONSOLIDATED ONE-OFF FOR 8.0.6.0.0 RELEASE |
28033582 |
8.0.6.0.10 |
OFS AAAI 8.0.6.0.0 COMPATIBILITY ONE-OFF PATCH RELEASE. |
|||
28399610 |
8.0.6.0.14 |
UPGRADE IS TAKING TIME TO RUN QUERY TO POPULATE ISNULLABLE DATA FOR ATTRIBUTES |
|||
Base Installer |
28262015 |
8.0.6.0.11 |
ENVCHECK UTILITY FOR OFSAA 8.0.6 RELEASE |
||
28398331 |
8.0.6.0.13 |
ENVIRONMENT CHECK TO HANDLE COPY OF RELEVANT CPP COMPONENTS BASED ON OS VERSION |
|||
OJET |
- |
28045149 |
8.0.6.0.2 |
IPE FIXES FOR FCCM |
|
Operations |
- |
28067296 |
8.0.6.0.3 |
ISSUE WITH INVOCATION OF INTCALCEXEC BINARY |
|
Build Related |
- |
28061766 |
8.0.6.0.4 |
STLPORTON LIBS LINKING ISSUE IN CAP_ADQ_PACK C++ COMPONENTS |
|
- |
28079607 |
8.0.6.0.6 |
PLATFORM CPP LIBRARIES ONE-OFF FOR 8.0.6.0.0 |
||
Filters |
- |
27552339 |
8.0.6.0.5 |
INDETERMINATE BEHAVIOUR WHEN OPENING HIERARCHY FILTERS IN OFSA 8 WITH IE 11 |
|
Unified Metadata Manager |
Metadata Browser |
28173603 |
8.0.6.0.7 |
OBJECT TO APPLICATION MAP SPINS AND DOES NOT DISPLAY ANY RULES |
|
Technical Metadata Management |
28398512 |
8.0.6.0.15 |
DMT CONSOLIDATED FIXES FOR PERFORMANCE AND MIGRATION UTILITY |
||
28442780 |
8.0.6.0.16 |
F2T FIXED WIDTH FILE MIGRATION AND CTRL FILE RELATED FIXES |
|||
28432036 |
8.0.6.0.18 |
SCD-RECORDS ARE GETTING DUPLICATED WHEN SOURCE TABLE HAS DATA FOR DIFFERENT DATE |
|||
Others |
- |
28112732 |
8.0.6.0.8 |
CS806- DATAMODEL IS GETTING STUCK IN BETWEEN ON AIX FOR SANC806 |
|
|
Administration |
Object Migration |
28452008 |
8.0.6.0.17 |
EXPORT FAILS WHEN OFFLINE OBJECT MIGRATION (UI BASED) IS DONE USING LDAP USER |
Component |
Sub-component |
Bug |
Subject |
Advanced Analytics Infrastructure |
Modeling |
28387351 |
MODEL CREATION SCREEN DOES NOT DISPLAY SUMMARY PAGE |
Administration |
- |
28147230 |
COMMON LANDING PAGE NAVIGATION DRAWER INFODOM STYLING |
28078317 |
JAVA.IO.FILENOTFOUND EXCEPTION FOR FIVCONFIG.CFG FILE |
||
28125147 |
PORTC.JAR CHANGE IS APPENDING EXTRA SLASH FOR FTPDRIVE PATH IN APP_SERVER_INFO |
||
Utilities |
28091161 |
BLANK SCREEN WHEN CLICKING ON SELECT METADATA OPTION IN METADATA DIFFERENCE SCREEN |
|
Dimension Management |
- |
28386238 |
SUPPORT FOR HIERARCHY BROWSER CALL BACK FROM OJET BASED MODAL DIALOG |
Big Data Option |
- |
27977933 |
RULE EXECUTION FAILED WHEN SELECTED DATASET HAS SUBQUERY |
27977660 |
RULE EXECUTION FAILED WITH ERROR: VALUE === IS NOT A MEMBER OF INT |
||
Common Apps |
- |
27944259 |
LOGIN SERVICE IS NOT WORKING FOR USER OTHER THAN SYSADMN |
Data Model |
- |
28105825 |
DATA MODEL ENTITY/ATTRIBUTE INFORMATION NOT COMING VIA PLATFORM API |
DEFQ |
- |
27881827 |
DEFQ IN IE- SCRIPT ERROR COMES WHEN USER WHO CREATED FORM TRIES TO AUTHORIZE |
Environment |
- |
28141532 |
REGENERATION OF REVELEUS.SEC FILE FAILS |
Forms Framework |
- |
28170509 |
DOCUMENT UPLOAD PERFORMANCE ISSUE |
28213735 |
API BASED DOCUMENT UPLOAD (E-FILE) IS NOT HAPPENING. |
||
27769951 |
EXCEL EXPORT FOR MORE THAN 20000 RECORDS ARE FAILING. |
||
28034001 |
DOCUMENT UPLOAD IS NOT WORKING IN FILENET |
||
28080866 |
PAGINATION OPTION IS NOT WORKING IN METADATA BROWSER SCREEN |
||
Filter |
Hierarchy Filter |
27968529 |
HIERARCHY CHANGES IN UI DO NOT SYNC UP HIERARCHY BASED FILTER DEFINITION |
- |
27589021 |
SORT IDENTITY CODE VALUES IN DATA FILTER DEFINITION SCREEN ALPHABETICALLY |
|
OJET |
- |
28316625 |
WHEN EXPORTED ONLY 1000 RECORDS ARE GETTING EXPORTED FROM ALERT LIST |
28164803 |
CLUSTER REGISTRATION WINDOW HANGS ON SAVING, IF MANDATORY FIELDS ARE EMPTY |
||
28148345 |
EDITABLE GRID DATA IS LOST ON SORTING ANY GRID COLUMN |
||
28112456 |
DOCUMENT DOWNLOAD IS NOT WORKING |
||
28046007 |
ADDITION OF TRAIN CONTROL IN OJET FRAMEWORK |
||
28045258 |
LAST TWO DIGITS OF DESIGNATE TRUSTED PAIR>EXPIRATION DATE ARE NOT DISPLAYED |
||
28045149 |
IPE FIXES FOR FCCM |
||
Operations |
- |
28132565 |
ICCSERVER NOT STARTING AFTER APPLYING 80610 ML PATCH |
27983873 |
ALLOCATION RULE/ALLOCATION MODEL EXECUTION IS FAILING DUE TO CLASSNOTFOUND ERROR |
||
Others |
- |
27984161 |
WEBSERVICES IS NOT WORKING IN WEBSPHERE |
Model Upload |
- |
28146898 |
ENHANCEMENT FOR AAI METADATA MANAGEMENT COMPONENTS |
Rules Framework |
Rules |
28251622 |
UNABLE TO SAVE EXISTING RULE AFTER MOVING LOCATION FROM SOURCE TO TARGET |
Unified Metadata Manager |
Technical Metadata Management |
28384630 |
ISSUES DUE TO MISMATCH IN COLUMN LENGTH FOR V_BATCH_ID |
28248030 |
T2H SQOOP FAILS FOR ONE TO MANY MAPPING |
||
28107716 |
H2H GETTING FAILED |
||
28032977 |
T2T EXECUTION FAILS SINCE OVERRIDDEN SOURCE IS CHECKED IN THE WRONG INFODOM |
||
28032896 |
EXECUTION FAILS WHEN LOWER CASE NEXTVAL IS USED IN DATA MAPPING |
||
27784512 |
TO_DATE FUNCTION DOES NOT WORK ON BOTH HIVE AND SPARK |
||
27157231 |
ISSUES IN EXPRESSION CREATION AND MAPPING IN ETLMAPPER |
||
Metadata Browser |
28351525 |
MDB REPORTS FUNCTIONALITY FAILED : METADATA BROWSER |
|
27932045 |
MDB PUBLISH NOT CAPTURING EXPRESSIONS & TRANSFORMATIONS IN THE DATA MAPPING DEF |
||
Business Metadata Management |
28319027 |
MAP MAINTENANCE: MAPPER PUSHDOWN FAILED WITH CLASSNOTFOUND EXCEPTION |
|
28138957 |
VIEW EXISTING MAPPING SCREEN IS OVERLAPPED WITH THE CHILD SCREEN |
||
28079769 |
ESSBASE CUBE: PERFORMANCE TUNING FOR OUT OF MEMORY ISSUES |
||
28031717 |
UNABLE TO CREATE DIMENSION WITH IMPLICITLY CREATED UMM HIERARCHIES |
||
27926133 |
UNABLE TO CREATE MEMBER UNDER COMMON CHART OF ACCOUNTS |
||
27683256 |
USER DATA LEVEL DATA RESTRICTION FAILS |
||
21392484 |
MULTIPLE HIERARCHY REFRESH(RUNIT.SH) IS NOT WORKING IN OPERATIONS MODULE |
||
- |
28261037 |
ATTRIBUTE DATA TYPE - AGGREGATE FUNCTION VALIDATION MISSING IN MEASURE ADDITION |
|
28245173 |
DATASET- PREVIEW WITH DATE FILTER SHOWS ERROR IN QUERY EXECUTION |
||
28164141 |
ESSBASE: DATA COMPRESSION TYPE HAS CHANGED TO "NO COMPRESSION" |
||
28134273 |
ESSBASE: ALL MAPPED VARIATIONS ARE DESELECTED, IF ONE DIMENSION IS REMOVED. |
||
28131744 |
SEEDED MEASURE TYPE HIERARCHIES ARE NOT LOADING IN UI. |
||
27992218 |
ESSBASE CUBES: ALL MAPPED MEASURES SHOULD HAVE VARIATION |
||
27582054 |
NODE FORMULA BUTTON IS MISSING IN NEW ESSBASE CUBE |
||
Metadata such as T2T, F2T etc |
T2T Issues |
28328045 |
INAPPROPRIATE MESSAGE CAPTURED IN T2T LOGS WHEN EXECUTION FAILS FOR VALID REASON |
Log Viewer |
- |
27871607 |
HELP PAGE IS NOT ENABLED IN LOG INFORMATION WINDOW |
Process Modelling Framework |
- |
28199073 |
PERFORMANCE & WEBSEVICE ISSUE IN PMF - OPEN CURSORS AFTER BULK RECORDS EXECUTION |
28199091 |
HANDLING AND PERSISTING ERROR RESPONSE WHILE CALLING A WEBSERVICE IN PMF |
||
28444062 |
TRANSITION FILTERING IN PMF WORKFLOW DOES NOT HAPPEN CORRECTLY |
||
System Configuration |
- |
28120080 |
VALIDATION EXCEPTION WHEN USING REMOTE_USER IN SSO HEADER VALUE |
Security Management System |
- |
28421593 |
ALLOWING SMS USER NAME TO HAVE QUOTE CHAR AND LDAP PASSWORD FIELD TO HAVE % CHAR |
27967169 |
ENABLING SPECIAL CHARACTERS IN PASSWORD FIELD DATABASE DETAILS SCREEN |
Oracle Financial Services Asset Liability Management
This section includes the following sub-sections:
· New Features in This Release
For detailed information on usage of these features, refer to OFS ALM User Guide 8 and Cash Flow Reference Guide 8.
· 28478900: ER: Oracle 12.2 DB client support for ALM: Database 12.2 version supported
· 26240622: ER: Standardized Rate Shocks for IRRBB: Expanded support for the IRRBB Standardized Approach. Prepayments and early redemptions will now receive respective multipliers as part of Standardized Approach shock
· 27851097: ER: Changes to CFE to Improve Performance: Changes to enhance the performance of the CFE were done at the application level for certain memory settings and database level for cursor sharing.
Component |
Sub-component |
Bug |
Subject |
Calculation Engine |
Engine: Cash Flow
|
28479403 |
PREPAYMENT RATES INCORRECTLY GETTING APPLIED FOR UNMAPPED INSTRUMENT RECORDS |
28387330 |
FRWD PORT BUG FOR 28327929 - CCY CONVERSION FOR CASH_FLOWS INCORRECT |
||
28147409 |
FRWD PORT FOR 27845771-FE 430 INCORRECT FOR AMRT TYPE OF ANNUITY& ANNUAL CMPD |
||
27928838 |
INCORRECT EXCHANGE RATES USED IN CONSOLIDATION WHEN FROM_DATE = TO_DATE |
||
28147409 |
FRWD PORT FOR 27845771-FE 430 INCORRECT FOR AMRT TYPE OF ANNUITY& ANNUAL CMPD |
||
27875182 |
ER TO SUPPORT SA CPR / ER CALCULATION FOR IRRBB SHOCKS TYPE |
||
Engine: Other
|
28060470 |
FWD PORT FOR BUG# 28028417 : BALANCES LOADED ARE LARGER THAN EXPECTED |
|
28041571 |
FRWD PORT BUG FOR 27985554 - INCORRECT FE 210/660 WITH NON MATURITY BEHAVIOR PAT |
||
27932215 |
FRWD PORT FOR 27715639 - ALM WRONG RESULTS WHEN MATURITY, NEXT_PAYMENT SAME DATE |
||
- |
28184512 |
ALMBI TRANSFORMATION HAS PROBLEMS WITH PROCEDURE PRC_LOAD_FCT_ALM_GAP_LIMITS |
|
28061779 |
FWRD PORT FOR BSP BUG 27799426- INCORRECT ADJUSTMENT CHARGE/CREDIT CALCULATED |
||
27628183 |
UNABLE TO MOVE LIQUIDITY RESULTS INTO FACT TABLE THROUGH ALM BI PKG |
||
28294731 |
FWRD PORT FOR BUG 26866981 - INCORRECT FE 672 GAP INTEREST CASH FLOW NET |
||
|
27977146 |
FRWD PORT OF ALM BUG BUG 27977038 - BSP NODE LEVEL CALCULATION DOES NOT FINISH |
|
DATA_MODEL |
- |
27980271 |
REMOVE UNWANTED FK REFERENCES FROM FCT_ALM_SIGNIFICANT_CURRENCY TABLE |
INSTALL |
- |
28191219 |
FRWD PORT FOR BUG 28126289 (ORA-0143DV01) & 26866981(INCORRECT FE 672 GAP INT) |
User Interface
|
UI for Static Deterministic Process |
28357270 |
FORWARD PORT OF BUG 28324895-LEGAL_ENTITY_ID MISSING IN OFSA_CATALOG_OF_LEAVES |
UI for Time Buckets |
28334222 |
ADDITION OF NEW DYNAMIC START DATE IN IRGB DELETES THE PREVIOUS ENTRIES IN TIME |
|
- |
27921395 |
FORWARD PORT OF BUG 26085021-INTERFACE ISSUE:VAL LARGER THAN SPECIFIED PRECISION |
|
28543145 |
FWRD PORT FOR BUG 28487356 - UNABLE TO ASSIGN ATTRIBUTE TO CUSTOMER DIM MEMBER |
||
28088439 |
FORWARD PORT OF BUG 28018952 - UNABLE TO IMPORT FORECAST RATES, MATURITY MIX |
||
Cash Flow Edits (engine output) |
- |
28068490 |
FRWD PORT BUG FOR 27197163 - FE675 INCORRECT IF REPRICE DATES IS DIFFER FRM PMTD |
Performance Issues |
- |
27925038 |
FRWD PORT OF ALM BUG 27954153 - BI PACKAGE PERFORMANCE AND STAGE FORECAST LOADER |
Known Issues/ Limitations in This Release
None
Oracle Financial Services Asset Liability Management Analytics
This section includes the following sub-sections:
· New Features in This Release
For detailed information on usage of these features, refer to OFS ALMBI User Guide 8.
Component |
Sub-component |
Bug |
Subject |
SCRIPTS
|
|
28437946 |
FW PORT 8.0.6.1:WRONG FORMULA FOR THE COLUMN PAYMENT FREQ X MULT |
- |
28437482 |
FW PORT 8.0.6.1:REPRICING GAP-NOT SHOWING ALL CCY IN THE CURRENCY PROMPT |
|
WEBCAT
|
- |
28437926 |
FW PORT 8.0.6.1:LIQUIDITY GAP REPORT HAS INCORRECT CUMULATIVE VALUES |
28437919 |
FW PORT 8.0.6.1:MARKET VALUE REPORT | FORMULA FOR "NET MARKET VALUE" |
||
28437388 |
FW PORT 8.0.6.1 :NO VALUES IN ALMBI DASHBOARD (ALM HOME) FOR AS OF DATE |
||
28437641 |
FW PORT 8.0.6.1:REPORT NET DURATION SUMMARY IN BASE CURRENCY IS NOT SHOWING CURR |
||
28437609 |
FW PORT 8.0.6.1:CHECK IF COLUMNS USED FOR ENDING NET RATE & OTHER FES IN ALMBI A |
||
OTHER
|
- |
28437889 |
FW PORT 8.0.6.1:PREPAYMENTS -TABLE FSI_M_PPMT_REDEMPTION_RATE SHOULD BE USED |
28437619 |
FW PORT 8.0.6.1:REPRICING GAP - "REPRICING GAP ACROSS TIME" REPORT ISSUES |
||
28437449 |
FW PORT 8.0.6.1:ALM HOME - 'PROCESS' DROPDOWN NOT SHOWING ALL THE EXPECTED VALUE |
Known Issues/ Limitations in This Release
None