This readme has the
following sections:
OFSDF Application Pack v8.0.0.0.0 Minor Release #4
8.0.4.0.0 (ID 25523810)
This release of OFSDF Application Pack is cumulative
of all enhancements and bug fixes done since v8.0.0.0.0 release.
·
The
minimum patch set level should be OFSDF Application Pack v8.0.0.0.0
(Java7/Java8).
·
To install OFS AAAI application pack
8.0.4.0.0 on Oracle Solaris OS, you should upgrade your OS to Oracle Solaris
11.3 with SRU09 or higher, or Solaris version 10 with certain OS patches
applied.
·
In an OFSAA instance on Oracle Solaris OS,
where multiple OFSAA application packs have been installed/ deployed, it is
mandatory to upgrade all OFSAA application packs to 8.0.4.0.0 release. You
should start the upgrade of the OFSAA instance, only after confirming that all
of the application packs in that instance are available for upgrade to
8.0.4.0.0 version. For availability of the required OFSAA Application Packs
release on 8.0.4.0.0 for Oracle Solaris OS and other details, see 2246606.1
For
detailed instructions on installing this OFSDF Release, please refer to OFSDF Installation
Guide Release 8.0.4.0.0 Java7 and Java8 in OTN documentation
Library.
Starting 8.0.0.0.0 release, OFSAA applications are packaged
and released as Application Packs. OFSDF Application Pack includes Oracle
Financial Services Data Foundation.
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
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.4.0.0.
1. Multi-Browser Support
OFSAAI has been enhanced to render on multiple browsers like Google Chrome and Mozilla Firefox in addition to Internet Explorer. The OFSAAI screens are now HTML 5 compliant. See Limitations section to know about the modules that are not HTML 5 compliant.
Note:
Oracle provides Web Browser support in accordance with the vendor support
policy listed on Oracle
Software Web Browser Support Policy.
2. Model Upload
· For Sliced and Incremental Model Upload modes, an option to perform object registration process as Incremental or Full is introduced.
· 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 AAAI Application Pack Installation and Configuration Guide_8.0.4.0.0.
3. Object Migration Utility
The utility has been enhanced to migrate objects with their dependent objects. For more information on the dependent objects that are migrated with the base object, see Command Line Utility for Object Migration section in the OFS Analytical Applications Infrastructure User Guide 8.0.4.0.0.
4. Data Management Tools
The DMT Data Mapping JAVA Engine has been enhanced to support Define Once – Execute Anywhere. A metadata that has been originally defined as a T2T, can at run time be executed like a H2H or H2T or T2H. Additional run time parameters EXEC_ENV_SOURCE and EXEC_ENV_TARGET have been introduced which contain information on the Run-Time Source and Run-Time Target. These run time parameters are passed through Operations or RRF module.
5. Data Quality Framework
· For Data Quality Control Total Check Rule, Group by Join Condition has been introduced as an additional input to define the order in which the LHS and RHS columns should be compared.
· Data Quality Rule can be defined on Derived Entities.
6. Business Metadata Management
· Hierarchy resave utility (runit.sh) has been enhanced with an additional option to exclude hierarchies from resaving.
· Dataset ANSI Join supports up to 12000 characters.
· Creation of Derived Entity now implicitly creates a Dataset.
7. System Configuration and Identity Management
· A new command line utility has been introduced to migrate:
· Users registered in LDAP server to OFSAA
· Users in LDAP to a user group mapping in OFSAA
· User Groups in OFSAA to LDAP server.
· User Group Name field has been added in User Group Maintenance window.
· SFTP authentication with Public Key Infrastructure (PKI) has been implemented.
8. Process Modelling Framework
· Command Line Object Migration utility supports migration of PMF Process (object ID is 8000).
· Copy feature is introduced for Workflow definition.
· Search functionality is introduced in Inbox.
· Feature to revoke active delegations is introduced.
· Ability to Send Email (Consolidated or Individual) for the task or notification is introduced.
· Ability to reassign the task from Inbox is introduced.
· Support for attaching document to the PMF activity has been introduced.
9. Questionnaire
· Generic Questionnaire framework has been introduced.
· Configure attributes with data from dimension tables, SQL queries or from a set of predefined static values. These attributes are dynamically displayed in Questionnaire.
· Create questionnaire by defining attributes across various components. Three types of Questionnaire are supported- Basic, Decision Tree and Score based.
· Dynamic Answer options can be defined for single-choice and multiple-choice questions.
10. Forms Framework
· A new column has been introduced in FORMS_APP_FILTER table to validate mandatory parameters in application filter.
· Contextual help is available for KBD controls.
· A configuration has been added for hiding or displaying the backend (top) search across all the hierarchies in Hierarchy Browser.
· Slider control has been introduced with the control type "30"
· For number control, default decimal point field is introduced.
· FMloglevel flag is introduced in the configuration table based on which logs will be written into the error table.
· Command line object migration utility now supports migration of Page (object ID is 1127).
List of Bugs Fixed in This Release
Component |
Sub
Component |
Bug No |
Subject |
Administration |
Security
Management |
25104795 |
V_ROLE_CODE
LENGTH DIFFERENCE IN CONFIG SCHEMA |
24903708 |
AUDIT TRAIL
REPORT GENERATED IN UNREADABLE FORMAT FOR MULTIPLE GROUP MAPPING |
||
24748369 |
SYSTEM RENDERS
BLANK PAGE INSTEAD OF ERROR MESSAGE WHEN WRONG CREDENTIALS GIVEN |
||
24658936 |
LDAP
AUTHENTICATION HAPPENS FOR SMS AUTH USER DURING COMMAND LINE MIGRATION |
||
24513079 |
USERS ARE
UNABLE TO LOGIN 24/7 DUE TO "WORKING HOURS FROM" AND "WORKING
HOURS TO |
||
24439498 |
UNABLE TO EDIT
THE USER DETAILS IF BOTH USER NAMES ARE SAME |
||
24398693 |
ADVERSARY USE
LOGGED USER SESSION TO PERFORM SENSITIVE ACTIVITIES VIA CSRFATTACK |
||
Object
Migration |
23854147 |
CUSTOM
DIMENSION'S MEMBER MIGRATION FAILS WHEN NO DATA IN THEIR ATTRIBUTE TABLE |
|
23753956 |
WRONG DQ RULE
GETTING EXPORTED IN 7.3.5.1.0 ENV DURING COMMAND LINE MIGRATION |
||
23336747 |
MIGRATION OF
ALL USERS FAILS WHEN AN UNAUTHORISED USER IS PRESENT |
||
- |
23740980 |
CONNECTIVITY
ISSUE ON CDH W.R.T USE OF SSL PARAMETER IN JDBC URL |
|
19642447 |
USER GROUP
AUTHORIZATION FUNCTIONALITY NOT WORKING PROPERLY |
||
17178569 |
ABILITY TO
DISABLE SYSADMIN/SYSAUTH USING THE OFSAAI INTERFACE |
||
Data Entry
Forms and Queries |
Excel Upload |
25259128 |
LOCAL FILE
INCLUSION FROM EXCEL UPLOAD THROUGH BURP SUITE |
- |
25048399 |
AAI 8.0 - DEFI
SCREEN FLICKERS IN ADD & EDIT MODE |
|
24438924 |
CONFIG SCHEMA
UPLOAD IS NOT WORKING |
||
Data Entry |
24317926 |
AUTO
AUTHORIZATION OPTION FOR DEFQ FORMS |
|
Forms Designer |
21800697 |
MANDATORY
FIELDS CHECK IS NOT WORKING FOR SECOND TIME IN FORM WITH AUTORIZATION |
|
Unified
Metadata Manager |
Business
Metadata Management |
24605104 |
DUPLICATE
ENTRIES ARE APPEARING IN VIEW MAPPING SCREEN |
24431607 |
VIEW MAPPING
SCREEN TAKES LONGER TIME TO LOAD AND CAUSES TIME OUT |
||
23305370 |
METADATA CACHE
ON START UP TAKES MIN 15 MINS TO COMPLETE |
||
Technical
Metadata Management |
25296570 |
FP- T2T
FETCHING COUNT FOR BULK LOAD |
|
24969695 |
DATA MAPPING
SCREEN HANGS INTERMITTENTLY |
||
Data Quality
Definition |
24610792 |
DQ RULES ARE
NOT GETTING IMPORTED WITH REFERENTIAL INTEGRITY CHECK |
|
24398337 |
IN DQ RULE ,
REFERENTIAL INTEGRITY CHECK IS FAILING WHILE TRYING TO EDIT |
||
24392031 |
RI CHECK IS
FAILING WITH ORA-00904 ERROR WHEN ADDITIONAL CONDITION IS USED |
||
Data Quality
Group |
25245705 |
DQ PROCEDURE
EXECUTION FAILS IN RI WHEN ADDTIONAL PARAMS ARE PASSED |
|
25133241 |
CONTROL TOTAL
CHECK, ERROR IN ANSI JOIN CONDITION EXPRESSION WITH ONSOURCE |
||
24510516 |
DQ EXECUTION
FAILS WITH A WRONG TABLE REFERENCE IN THE RULE COUNT QUERY |
||
Metadata
Browser |
23759610 |
REV_OBJECT_REPOSITORY_TL.OBJECT_DESCRIPTION
TO BE INCREASED TO VARCHAR2(4000) |
|
Forms
Framework |
Forms Manager |
24924486 |
FM ISSUE:
DUPLICATE VIEW ID'S ARE CREATING THROUGH FORMS MANAGER. |
24794208 |
FORMS MANAGER-
COPY OF HIERARCHY CONTROL ISSUE |
||
24471936 |
ISSUE WHILE
GENERATING THE FORM BY TWO USERS SIMULTANEOULSY |
||
24360518 |
FORMS MANAGER
ISSUE: LAYOUT TAG IS NOT GETTING INSERTED IN XML. |
||
Forms
Rendering Engine |
24509718 |
SLIDERS ARE
REQUIRED |
|
24300902 |
HIERARCHY
POPUP ISSUES |
||
24295695 |
DYNAMIC
HIERARCHY NODE LIMIT SHOULD BE CONFIGURABLE |
||
23584013 |
ROOT NODE
SHOULD NOT BE ALLOWED TO SELECT IN HIERARCHY CONTROL |
||
23532677 |
IMPROPER
ALIGNMENT OF CONTROL IN EDITABLE GRID ON SELECTION IN HTML5 |
||
Forms: ROR |
25068713 |
POST 8.0.2
UPGRADE ISSUES WHEN HTML5 IS ENABLED |
|
24741973 |
MORE HELP TEXT
RELATED ISSUES FOUND AFTER APPLYING 21369130 PATCH |
||
24740040 |
TO PROVIDE
FUNCTIONALITY TO COPY THE HELP TEXT |
||
23638483 |
NOT ABLE TO
ASSIGN VALUE TO A LABEL CONTROL(CONTROL IN VIEW MODE) (TYPE=13) |
||
23281304 |
REMOVAL OF
SEARCH ON HIERARCHY POP UP WINDOWS |
||
23097035 |
ISSUES ON
REMOVAL OF MENU FROM BACK END BUT STILL VISIBLE IN UI |
||
- |
25364054 |
PROBLEM AGAIN
EXPORTING EXCEL FOR ONE ROW |
|
25118208 |
TRANSPOSING
COLUMNS DOESN'T WORK PROPERLY UNDER CUSTOMER AND ACCOUNTS TABS |
||
25111157 |
SELECTING ALL
ALERTS CAUSES VIEW ALERT DETAILS BUTTON TO DISAPPEAR |
||
25077285 |
NUMBER OF
CHARACTERS ARE NOT PROPERLY DISPLAYED WITHIN THE TEXT BOX WHEN USER EN |
||
25074393 |
NEXT MONTH OR
YEAR PAGINATION NOT AVAILABLE IN CALENDAR SELECTION ACROSS SCREENS |
||
25062856 |
IN CASE
HISTORY, JUMP TO PAGE IS NOT DISPLAYED PROPERLY |
||
24970787 |
DEVELOPER MODE
ENABLED IN CHROME STANDARDS MODE |
||
24747139 |
OPS RISK |
SEARCH GRID SETTINGS ISSUE |
||
24741456 |
TEXTAREA
BREAK-WORD STYLE TO BE CHANGED TO JUSTIFIED WITHOUT BREAK-WORD |
||
24686874 |
BUSINESS TABS
NOT COMING ON ALERT DETAIL SCREEN |
||
24509700 |
IN EXCEL
EXPORT SPAN HEADER SHOULD BE ALIGNED CENTRALLY |
||
24311119 |
CONTROL
REFRESH ALIGNMENT ISSUE |
||
24301002 |
TAB BEHAVIOR
IS INCONSTANT |
||
24300813 |
GRID IS NOT
LOADING PROPERLY |
||
23561855 |
ALERT MESSAGE
FOR EXPORTING RECORDS MORE THAN A SPECIFIED LIMIT |
||
24841196 |
IN STANDARDS
MODE CALENDAR IS NOT APPEARING FOR CUSTOM JSP WITHOUT MENU |
||
23582940 |
DOCUMENT
ATTACHMENT GIVES JS ERROR WHILE CLICKING ATTACH BUTTON |
||
23318591 |
STYLESHEET IS
CHANGED WHEN A FORM IS CALLED FROM A NEW TAB |
||
23304308 |
ZERO KBD
SHOULD BE SUPPORTED IN APPLICATION |
||
Filter |
25076883 |
TREE GRID NOT
COME IN PARENT NODE &ORPHAN BRANCH IN HIERARCHY DATATYPE IN FILTER |
|
GRC
Infrastructure |
25215255 |
FLEX KBD:
CUSTOM QUERY GENERATED IS NOT PROPER |
|
Model Upload |
- |
22696868 |
PERFORMANCE
IMPROVEMENT FOR OBJECT REGISTRATION PROCESS |
21471381 |
REORDER OF PK
(PRIMARY KEY) COLUMNS THROUGH ERWIN |
||
25252319 |
INCREMENTAL
OBJECT REGISTRATION FAILS WHEN A WRONG PHYSICAL TABLE UDP IS PRESENT. |
||
25183272 |
HIGH RISK SQL
INJECTIONS IN MODEL UPLOAD. |
||
24482616 |
MODEL UPLOAD
PROCESS DOES NOT CREATE CONSTRAINTS NAME WITH NEW NAMING CONVENTION |
||
23501057 |
ENTITY IS
GETTING STORED IN ALL CAPS INSTEAD OF CAMEL CASE |
||
Operations |
Batch Maintenance |
25159866 |
ICC BATCH TO
SYNC UP WITH MIGRATED ALLOCATION SYS ID |
Other |
- |
24941855 |
OFFLINE
COMMANDLINE UTILITY : AAI_MIGRATION_DETAILS IS NOT POPULATED |
Rules
Framework |
Process Execution |
23190078 |
PROCESS
PARAMETER LENGTH LIMITATION FOR EXECUTABLE(WITH SHELL SCRIPT) |
Install and Upgrade Issues |
Migration
Scripts |
23219570 |
PORTC UTILITY
UPDATE LRM SPECIFIC FILE |
Service Packs |
23730269 |
QA ASSIGNED
:PORTC.JAR UTILITY SHOULD NOT SPECIFY AGENT PORT TO BE CHANGED |
|
23283729 |
PORTC.JAR UPD
SETS APPLOGPATH & DBLOGPATH TO SAME VALUE FOR ALL INFODOMS |
||
- |
21110755 |
IFCONFIG -A
COMMAND RETURNS MULTIPLE IPS DURING SCHEMA CREATION |
|
Style Issues |
- |
24840922 |
UI CHANGE
REQUIREMENTS |
24748156 |
DISPLAY OF
LEVEL 2 MENU IN OFSOR SCREEN IS NOT PROPER |
||
Security
Management System |
- |
25055770 |
INACTIVE
DAYS=30 WITH LDAP ENABLED STILL ALLOWS USER TO LOGIN AFTER 30 DAYS |
24701516 |
LDAP
AUHTENTICATION ISSUE WHEN USERS HAVE DIFFERENT DN WITHIN SAME USER BASE |
||
25389887 |
CSRF ENABLED
PASSWORD CHANGE AFTER LOGIN TO USER IS FAILING |
||
25319842 |
AUTH STRING
FIELD IS ALLOWING SPECIAL CHARACTERS IN COPY-PASTE |
||
25295613 |
QUESTIONNAIRE
PERSISTENCE-UNIT IS MISSING IN GRCPERSISTENCE.XML |
||
25215372 |
NOTHING IS
DISPLAYING AUTHORIZATION SCREEN WHEN UNCHECK PROXY |
||
25076079 |
PASSWORD IS
NOT CHANGING IF USE SMALL LETTER AS USER NAME |
||
24739389 |
NOT ABLE TO
LOGIN TO OFSAA USERS |
||
24708375 |
LHS ALSO
SHOULD SHOW ROLE MASTER REPORT INSTEAD OF USER ROLE REPORT |
||
24694323 |
USER
MAINTENANCE SCREEN THE SELECTALL CHECKBOX IS NOT SELECTING ALL THE USER ID |
||
24672426 |
NEXT AND LAST
BUTTON IS NOT WORKING IN USER MAINTENANCE SCREEN |
||
24671125 |
SMS ISSUE IN
"PASSWORD MANAGEMENT : EMPTY PASSWORD : SEMANTIC" |
||
24612897 |
USER
MAINTAINANCE SCREEN - VIEW ICON - ERROR MESSAGE (ALL BROWSERS) |
||
24612850 |
ERROR IN POPUP
WINDOW- USER GROUP MAP,DOMAIN MAP AND ROLE MAP (IE AND FIREFOX) |
||
24612489 |
USER GROUP
MAINTENANCE SCREEN - DELETE OPTION -ERROR IN THE POP UP WINDOW |
||
24605924 |
FAILMSG NEEDS
TO BE DISPLAYED WHEN CREATING A GRP HAIVNG EXISTING GRPNAME AND ID |
||
24595605 |
ISSUE WHILE
CREATING NEW USER |
||
24518998 |
LDAP TO SMS
MIGRATION IS FAILING IN AAI 8021 |
||
24459458 |
INTRODUCING
USER ATTRIBUTES IN SMS USER CREATION UI AND ENHANCE THE USER REPORTS |
||
24339462 |
SEGMENT CODE/
FOLDER CODE TO ALLOW UNDERSCORE |
||
System Configuration |
Information
Domain |
18614891 |
[309] FIV
STAGE PATH COULD NOT BE CREATED ON WEB SERVER |
Configuration |
24446212 |
ANONYMOUS BIND
COMING AS `Y’ EVEN IF IT IS NOT SELECTED |
|
23497315 |
NOT ABLE TO
DELETE LDAP SERVER DETAILS FROM LDAP SERVER DETAILS SCREEN |
||
- |
23758304 |
UNABLE TO
LOGIN TO OFSAA AFTER KEEPING THE SCREEN IDLE FOR LONG TIME |
|
10215123 |
REQUEST TO
CERTIFY SFTP AUTHENTICATION WITH PUBLIC KEY INFRASTRUCTURE (PKI) |
||
25207469 |
CONFIGURATION
SCREEN MANDATING FOR QUESTION AND ANSWERS FOR EACH CHANGE |
||
24930934 |
DB DETAILS
ENTRY EDITING HAS ISSUE |
||
24901524 |
LOGIN SCREEN
DISORDER |
||
24404598 |
DISPLAY ERROR
MESSAGES BASED ON ERROR CODE FOR LDAP LOGIN |
||
Workflow |
25340245 |
SAVE AS NEW
VERSION WITH PROCESS CODE HAVING '_' IS NOT WORKING |
|
25267068 |
DATAFIELDS AND
APPLICATION RULES CANNOT BE VIEWED/EDITED |
||
25265177 |
DELEGATION
LISTS DELEGATOR AS UNDEFINED |
||
25201251 |
ADDING TASK
FOR AN ACTIVITY DOES NOT WORK |
||
25134152 |
PMF DOES NOT
WORK IF HIVE RELATED JAR'S ARE AVAILABLE |
||
25109328 |
DELEGATION
TASKS ARE NOT OPENING |
||
24931460 |
IMPORT GIVES
ERROR WHILE IMPORTING API |
||
24902405 |
USER SHOULD
NOT BE ABLE TO REVOKE INACTIVE DELEGATION |
||
24701927 |
DATAFIELDS
CANNOT BE VIEWED OR EDITED |
||
24659016 |
DELEGATION
SAVED FOR A PROCESS WORKS ON ALL APPLICATIONS/PROCESSES |
||
24602927 |
DELEGATE USERS
ARE NOT LISTED |
||
24569462 |
REASSIGN TASK
DOESN'T SHOW USER LIST IF ENTITY IS MAPPED TO SOME KBD |
||
23624049 |
HISTORY TABLE
IS NOT GETTING UPDATED WITH LATEST STATUS VALUE. |
||
24487373 |
DATAFIELD
VALUE IS NOT GETTING REPLACED IN URL WHEN COMING FROM INBOX |
||
24480447 |
EMAIL
DIGEST>>ISSUES IN THE MAIL CONTENT |
||
24308737 |
NOT ABLE TO
ENABLE MAIL AND DISABLE NOTIFICATION |
||
23540751 |
E-MAIL
FUNCTIONALITY IS NOT WORKING IN PMF. |
||
23561439 |
TASK ID IS
DIFFERENT IN EMAIL |
||
23517452 |
COMMITTEE
SETTING UPDATED ONCE IS NOT SAVED ON SAVING |
||
23516615 |
DELEGATION
SAVED ARE NOT LISTED |
||
23510690 |
TASK IS NOT
GENERATED IF PMF IS CALLED THROUGH PROCEDURE |
||
23328330 |
THE PMF RECORD
IS SHOWING RUNNING SYMBOL FOR TWO STATUSES AT SAME TIME. |
||
23312634 |
EXECUTING
PROCEDURE THROUGH PMF IS NOT WORKING |
||
23249058 |
ISSUE WHEN
MORE THEN ONE ACTIVITY HAS TO BE COMPLETED BY MULTI CHOICE GATEWAY |
||
23218993 |
THERE IS NO
OPTION TO REASSIGN TASKS |
||
23540994 |
SUBPROCESS IS
NOT INITIATED |
||
23045130 |
USER TO WHOM A
USER’S ACTIVITIES ARE DELEGATED RECEIVES NO TASK OR NOTIFICATION |
||
21689518 |
E-MAIL
CONFIGURATION AND CONTENT |
||
21154236 |
WORKFLOW IS
NOT ABLE TO HANDLE PARALLEL TASKS. |
||
21687346 |
TASK/NOTIFICATION
TO HOLD THE LATEST ENTITY STATUS IN ADDITION |
||
21687335 |
TASK
EXPIRATION CONFIGURATION |
||
21687306 |
ENABLE/DISABLE
OPTION FOR TASKS AND NOTIFICATIONS |
Following
is the list of Limitations or Known Issues in this release:
· Dataset creation hangs if it has huge number of entities selected with ANSI Join.
· In case of Google Chrome and Mozilla Firefox, the base window is not closed after launch of Login page due to the browser security model.
· The following modules will be supported only in IE:
· Metadata Browser
· Data Entry Forms and Queries
· Essbase Cube
· Metadata Archive/Restore
· Email does not get triggered from PMF workflow, in case Webserver is WebSphere and it is HTTPS environment.
· Online help for Questionnaire is not available.
· Sequencing of Questions and sections does not work in Questionnaire module.
· Viewing Business Process Flow diagram uploaded in Post Load Changes displays the download window twice.
Oracle Financial Services Data Foundation
This section includes the following sub-sections:
· New Features in This Release
· List of Bugs Fixed in This Release
Following is the list of features incorporated in this release. For detailed information on usage of these features, refer to Oracle Financial Services Data Foundation User Guide Release 8.0.4.0.0 in OTN documentation Library.
· Consolidation Legal Entity
The reporting bank may be a part of a financial group that has multiple legal entities such as parent or child entities (subsidiaries) under its name. User can select the entity for which processing is to happen, and whether a ‘Solo’ or ‘Consolidation’ execution is to be done.
Scope Of consolidation is about list of Entities which participate in consolidation. Legal Entity Structure is looked through Organization Structure Dimension. This stores parent child relationship. This is stored only once. While moving the data, Legal Entity can move related entities to processing/reporting area. Legal structure being finalized once, this structure only stores one parent child relationship.
List of Bugs Fixed in This Release
Bug No |
Description |
25166628 |
OFSAA
SCD USED FOR AMHM DIMENSION IS CREATING NEW RECORD FOR EACH LOAD |
25557052 |
CONSOLIDATION
LOGIC FOR LEGAL ENTITY AND LEGAL ENTITY HIERARCHIES |
25664239 |
FSDF
804 MODEL UPLOAD NOT GOING THROUGH ON BASEL |
25391660 |
FSDF
803 UPGRADE ISSUE - V_PK_RULE_COLS COLUMN OF DQ_CHECK_MASTER HAS WRONG ORDER |
23561151 |
EXTENSTION
OF STG_OPTION_CONTRACTS |
24670947 |
ENHANCEMENT
TO MAP 'TYPE OF PAYMENT' COLUMN INTO STG_CARDS TABLE |
24707417 |
NEED
A COLUMN TO CAPTURE MARKET VALUE DATE |
24939913 |
INCORRECT
TABLE REFERENCED IN THE JOIN STG_LOAN_CONTRACTS TO DIM_INSTRUMENT_TYPE |
24787652 |
UNREALIZED
GAINS/LOSS IN FUTURE CONTRACT |
25633966 |
FCT_LOAN_ACCOUNT_SUMMARY.N_REG_VINTAGE_SKEY
HAVING MULTIPLE FKS |
25351554 |
REMOVE
INVALID FLAG COLUMN FKS FROM FCT/DIM TABLES |
25351558 |
REMOVE
INVALID FLAG COLUMN FK FCT_CARDS_SUM TABLES WITH DIM_REVOLVE_TYPE_MASTER |
25166937 |
MITIGANT
AND COLLATERAL CODE COLUMN DATA LENGTH INCREASE. |
25335904 |
DIM_CURRENCY
SEEDED VALUES |
25296552 |
CONCERN
AROUND FSDF DATA SOURCING FOR F_REVOLVE_IND IN DIM_PRODUCT |
25336942 |
FSDF
803 - N_ACCRUED_INTEREST MISSING IN STG_BORROWINGS |
25166885 |
V_DAY_COUNT_IND
FIELD IN PRODUCT PROCESSOR TABLES |
22489610 |
COLUMN
V_FINANCIAL_ELEMENT_CODE IS MISSING IN DIM_FINANCIAL_ELEMENT |
22298729 |
MISMATCH
BETWEEN DIM_INSTRUMENT_CONTRACT & STG_INSTRUMENT_CONTRACT_MASTER TABLES |
23007432 |
INCONSISTENT
DATA TYPES BETWEEN FSDF AND FCCM FOR PHONE NO. AND EXTENSION FIELDS |
24564893 |
ADDITIONAL
COLUMN REQUIRED IN STG_CARDS_BALANCE_SUMMARY |
24586698 |
FCT_RATING_TRANSITION_MATRIX
AND FCT_TRANSITION_MATRIX HAVE SAME
ADI NAME |
24708649 |
INCORRECT
SKEY ENTRIES DEFAULT RECORDS IN DIMENSION TABLES |
25138817 |
DIMENSION
TABLE LINKAGE FOR STG_CREDIT_LINE_DETAILS.V_CREDIT_LINE_STATUS_CODE VA |
24666522 |
DIM_INSTRUMENT_CONTRACT -
TWO COLUMNS PRESENT IN STG BUT NOT IN DIM TABLE |
25152056 |
V_HOLDING_TYPE
REQUIRED IN LIABILITY TABLES |
25110225 |
COLUMNS
AND/OR T2T MAPPING REQUIRED IN FACT TABLE FCT_LOAN_ACCOUNT_SUMMARY |
24793457 |
ALL
COLUMNS PRESENT IN STG_CARDS TABLE NEEDS TO BE ADDED IN STG_PREPAID_CARDS |
22914538 |
REPORTING
TABLE FOR INSTRUMENT RATING DETAILS |
24317911 |
AMHM
TABLE STRUCTURE FOR LOB DIMENSION |
23706346 |
EXTENSTION
OF STG_FX_CONTRACTS |
24360176 |
ALTERNATE
COLUMN ADDITIONS FOR DEPRECATED COLUMNS IN FSDF 8.0.2 MODEL |
24300628 |
EXTENSTION
OF STG SWAP CONTRACT |
25140653 |
LCY
COLUMNS SHOULD BE DEPRECATED FROM STAGE TABLES |
24585494 |
OFSAA
FSDF - CONSTRAINT ON FCT_LOAN_ACCOUNT_SUMMARY |
24904342 |
REALIZED
GAINS/LOSSES MAPPING ENHANCEMENTS IN COMMON ACCOUNT SUMMARY |
25071734 |
COLUMN
EXTENSIONS FOR STG_CARDS: D_LAST_PURCHASE_DATE,N_BONUS_POINT_AMT_REDEEMED |
24957812 |
ADD
STORAGE FOR RATINGS WATCHLIST DATA (IE MOODYS) FOR PARTY AND INSTRUMENT TABS |
25095329 |
DIM_ORG_STRUCTURE
VERSUS STG_ORG_STRUCTURE_MASTER - MISSING ATTRIBUTES |
24963701 |
N_LOAN_RECOURSE_TYPE_SKEY
COLUMN NOT POPULATED IN FCT_COMMON_ACCOUNT_SUMMARY |
25555594 |
NOT
ABLE TO SELECT LEGAL ENTITY IN RUN DEFAULT PARAMETERS TAB |
25595661 |
COLUMN
REF FILTER TYPE IS WRONG B/W REQUIREMENT & DEFINITION |
25532146 |
SCD
FROM STG_PARTY_MASTER TO DIM_PARTY TO USE V_PARTY_TYPE INSTEAD OF V_TYPE |
25535646 |
LOAN
CONTRACTS ORG UNIT DATA QUALITY RULE MISSING |
25351763 |
V_OCCUPANCY_CD
EXPECTS DIFFERENT VALID VALUES IN BASEL AND RRS APPLICATION |
25466916 |
(D_START_DATE,D_END_DATE)
VS (D_RECORD_START_DATE, D_RECORD_END_DATE |
25351795 |
V_OCCUPANCY_CD
EXPECTS DIFFERENT VALID VALUES IN BASEL AND RRS APPLICATION |
25390132 |
FCT_MITIGANTS.F_MITIGANT_REPOSSESSED_FLAG
COLUMN DOESN'T HAVE DATA |
25345474 |
T2T
MISSING FOR STG_PARTY_ACCOUNT_ROLE_MAP IN THE RRS |
25519448 |
FCAS.N_IR_STRUCTURED_INSTR_SKEY
- DIM_INSTRUMENT_CONTRACT.V_IR_STRUCTURED_INSTR |
25390920 |
RCA
III :EXPOSURE AMOUNT NOT BEING POPULATED |
25201903 |
INCORRECT
REFERENCE DIM_BANK_INSTRUMENT_TYPE IN STAGING TABLE COLUMN |
25289859 |
INCONSISTENT
USAGE OF ISSUER_SKEY IN RRS |
23274953 |
POPULATE
V_ORIGINAL_ACCOUNT_NUMBER IN DIM_ACCOUNT |
22111489 |
DUPLICATE
PLACE HOLDERS IN DIM_INSTRUMENT_CONTRACT TABLE |
23081381 |
FOR
STG_CUSTOMER_RELATIONSHIP TABLE THERE IS NO DIM TABLE AVAILABLE |
24510887 |
FCT_LOAN_ACCOUNT_SUMMARY.N_LOAN_SERVICE_PARTY_SKEY-T2T
MAPPING NOT AVAILABLE |
24397777 |
DIM_COUNTRY
SEEDED DATA ENHANCEMENT TO ADD COUNTRY `CURACAO ` AS OOB |
22843745 |
CHARGE
OFF STATUS / DELINQUENT STATUS /REDEEM STATUS IN DIM_CREDIT_STATUS |
24360777 |
ATTRIBUTES
REQUIRED IN STG_CREDIT_DERIVATIVES |
20253539 |
REFERENTIAL
CONSTRAINTS ON FACT_COMMON_ACCOUNT_SUMMARY BLOCK MULTI-ENTITY RUNS |
22709444 |
TABLE
& COLUMN DESCRIPTION SHOULD BE ENHANCED |
22540052 |
LCY
COLUMNS IN STG_INSTRUMENT_MARKET_PRICES TABLE |
21031842 |
RENAME
THE COLUMN D_RECORED_END_DATE TO D_RECORD_END_DATE IN DIM_RISK_WEIGHT |
22149444 |
FCAS
N_SANCTIONED_LIMIT COLUMN MAPPING SHOULD BE CORRECTED |
25133654 |
CHANGES
IN EXPIRY & MATURITY DATES IN CREDIT LINE TABLES |
25358211 |
MISSING
MAPPING FOR N_REALIZED_GAIN_LOSS_AMT IN FCAS |
23240979 |
COLUMN
ENHANCEMENTS TO REPO CONTRACT |
22134222 |
ADD
ROLE IDENTIFER IN STG_PARTY_ACCOUNT_ROLE_MAP TABLE |
23119113 |
MISSING
ATTRIBUTES IN STG PREPAID CARDS TXNS |
24554988 |
STAGING
REFERENCE FOR DIM_ACCOUNT PURPOSE |
24445551 |
INCONSISTENT
COLUMN SIZE BETWEEN STG TO FCT |
25061992 |
V_HOLDING_TYPE
NOT PRESENT IN STG LIABILITY TABLES |
24940654 |
ADDITION
OF V_DATA_ORIGIN IN STG_ACCOUNT_MITIGANT_MAP/FCT_ACCOUNT_MITIGANT_MAP |
25109477 |
FCAS.F_GUAR_BY_SOVERIGN_IND
MAPPING ENHANCEMENTS |
25220549 |
DISCREPANCY
IN SCD FOR POPULATING DIM_PRODUCT |
25145019 |
SCD
TO POPULATE ISSUER DIMENSION FROM STAGE PARTY MASTER |
23524121 |
UPDATE
DEFINITIONS OF GLOSSARY TO DATA MODEL |
24686105 |
ADD
DATA ORIGIN FIELD TO VARIOUS STAGING TABLES USED BY BD |
24330734 |
NEW
COLUMNS IN STAGE TRADING ACCOUNT |
23327607 |
FIELDS
IN STG_FRONT_OFFICE_TXN_PARTY MUST BE NULLABLE |
24427258 |
ADD
NEW FIELDS TO STG_ACCOUNT_ALT_CCY_VALUES |
24699240 |
ADD
NEW FIELDS TO STG_CUSTOMER_ALT_CCY_VALUES |
24933035 |
ADD
NEW STG_SERVICE_CHARGE_MASTER TABLE FOR THE V_SERVICE_CHARGE_CODE FIELD |
25140404 |
ADD/MODIFY
FIELDS TO VARIOUS STAGING TABLES USED BY BD CUSTOMER TABLE |
23328047 |
STG_PARTY_PARTY_RELATIONSHIP:
CONVERT NOT NULL FIELD TO NULL |