OFS Data Foundation Application Pack is a
separately licensed product.
Description
Bug 26285451 – ORACLE FINANCIAL SERVICES DATA FOUNDATION
PACK 8.0.4.1.0 IR RELEASE
This is first Maintenance Level Release (ML) of OFSDF,
cumulative of enhancements and bug fixes done since the 8.0.4.0.0 Release.
Prerequisites
The pre-requisites required for this release is as follows:
·
The minimum patch
set level should be OFSDF 8.0.4.0.0
How to Apply This Maintenance Release?
For detailed instructions on installing
this Maintenance Level Release, refer to OFSDF 8.0.4.1.0 Installation Guide in OTN.
Oracle Financial Services Data Foundation Application Pack
New Features in This Release
1.
Population
of Fact Management Reporting from Stage General Ledger
This enhancement support the following
mapping combinations
·
One to one mapping : One GL Code to One Rep Line Code
·
Many to one mapping: Many GL Codes to One Rep Line Code
with aggregated measures at Rep Line level
·
Many to many mapping: Many GL Codes to many Rep Line Codes
with aggregated measures (at full value of GL Codes) at Rep Line level
List of Bugs Fixed in This Release
Bug |
Subject |
26236792 |
N_UNDRAWN_AMT NOT MAPPED FROM LOAN OR LEASE PP TABLES FOR RC-L
SCHEDULE |
26200976 |
FCT_PLACED_COLLATERAL FK WITH DIM_ENTITY SHOULD BE DISABLED
MANUALLY |
26195015 |
IMPROPER JOIN CONDITION IN T2T_STG_LC_CAS IN IPA SOLUTION |
26143525 |
FCT_DEPOSITS_BORROWINGS - FK ON N_CUST_TYPE_SKEY REFERENCING
DIM_PARTY_TYPE |
26098473 |
DEPRICATED STAGING COLUMN 'N_30DPD_12MONTHS_BAL' IS USED FOR
FRY-14Q LINEAGE |
26092971 |
DATA LENGTH FOR V_PROMINENT_MITIGANT_CODE NOT IN SYNC WITH
V_MITIGANT_CODE |
26092652 |
FR Y 14Q DISPOSITION FLAG IN SCHEDULE H1 AND H2 |
26092282 |
NO MAPPING FOR DIM_CUSTOMER TABLE V_CUST_LOCATION_CODE COLUMN IN
SCD |
26020523 |
F_INELIGIBLE_ACCEPT_BORROW_FLG FROM STG_BORROWINGS HAS NOT MOVED
TO FCAS |
26006388 |
STG_CARDS.V_GURANTOR_LINE_CODE SHOULD BE MAPPED TO
FCAS.N_CREDIT_LINE_SKEY |
26002097 |
ADDITIONAL INCORRECT OOTB DATA QUALITY RULES IN FSDF 8.0.3 |
25990679 |
T2T/SCD MAPPING MISSING IN FCT_CARDS_SUMMARY & DIM_PARTY FOR
FRY-14M |
25983651 |
T2T MAPPING REQUIRED TO POPULATE
FCT_CARDS_SUMMARY.N_AMT_TOT_FEE_REVERSAL_YTD |
25976267 |
FOR 525 REF INTEGRITY CHKS THE REF TBL IS NOT SHOWN AND GENERATE
QUERY FAILS |
25959684 |
SCD-MAPPING NOT AVAILABLE FOR V_CUST_SIZE COLUMN -
STG_PARTY_MASTER TO DIM_PARTY |
25928875 |
EXTRA SPACE PRESENT IN LOGICAL COLUMN NAME OF FSDF DATA MODEL |
25888737 |
DUPLICATE ENTRY FOUND FOR DIM_HOLDING_TYPE |
25832832 |
DM AND T2T ADDITIONS FOR F_TROUBLED_DEBT_RESTRUCRE_FLAG |
25829113 |
NEW T2T ADDIOTION TO POPULATE FCT_MGMT_REPORTING TABLE |
25753998 |
V_SECURITIES_GUARANTOR_CD IS WRONGLY MAPPED IN FSDF T2T |
25708415 |
DIM ACCRUAL STATUS SEEDED SCRIPT UPDATES |
25640998 |
ALL STAGE AND DIM TABLES TO HAVE 'DATA QUALITY-CORRECTION RULES'
UDP MANDATORLY |
25572531 |
FCT_COMMON_ACCOUNT_SUMMARY.F_PLANNED_LOAN_TRANF_IND DOESNT HAVE
EQUIVALENT STAGE |
25492774 |
SOURCING TABLE FOR CREDIT SCORE AT ORIGINATION FOR FR-Y14M |
25488955 |
MAPPING MISSING FEW COLUMNS FOR FCAS TABLE T2T |
25378300 |
SCD NOT POPULATING ALL THE COLUMNS IN DIM_IRCS TABLE |
25364868 |
CORRECTION REQUIRED IN T2T_FLAS_STG_LEASES_CONTRACTS |
25222405 |
COLUMN V_LIEN_POSITION_CODE IN STG_MITIGANTS RATHER THAN
N_LIEN_POSITION |
25134223 |
FFIEC 009 USAGE OF DIM_COUNTRY VALUES IN REG REPORTING
MEMBER_CODE |
25126400 |
2052A - FOR ORG STRUCTURE THERE IS A REQUIREMENT FOR MULTIPLE
HIERARCHIES |
25104450 |
ATTRIBUTES MISSING FOR FCT_COMMON_ACCOUNT_SUMMARY UNDER
SCHEDULES HC-R AND RC-R |
25061953 |
F_NEG_INT_RATE_FLAG NOT PRESENT IN STG_CASA |
25038089 |
SCD MAPPING FOR V_APPLN_NUMBER OF CREDIT LINE DIMENSION |
24819708 |
DATA FLOW MISSING IN FSDF T2T/SCDS |
24763927 |
T2T MAPPING FOR FCT_COMMON_ACCOUNT_SUMMARY.N_ACCT_SENIORITY |
24753649 |
F_CONTROL_BY_TREASURY_IND TO BE REMOVED FROM STG_MITIGANT |
24389414 |
USFED T2T : ACCOUNT PURPOSE AND INSURANCE FLAG |
24350356 |
NETTING AGREEMENT DETAILS TO BE POPULATED INTO FCAS |
21309572 |
ALL PRIMARY KEYS OF FCT_MGMT_REPORTING ARE NOT REQUIRED |
21269136 |
T2T CHANGES FOR POPULATION OF N_ORIGINATION_DATE_SKEY FROM LOANS
TABLE |
20655322 |
POPULATION OF FACT MANAGEMENT REPORTING FROM STAGE GENERAL
LEDGER |
Known Issues in This Release
None
Oracle Financial Services Analytical
Applications Infrastructure
New Features in This Release
·
Run orchestration can be done using Process Modelling Framework
·
A task component for Process Modelling Framework has been
introduced in the Batch Maintenance screen of the Operations module
·
Option to provide SQL Hints and degree of parallelism in Derived Entity
has been introduced
·
Process Modelling Framework integration with Business Restructure
has been introduced
List of One-Off’s Incorporated in This Release
Release |
Component |
Subcomponent |
Bug |
One-Off # |
Subject |
Post 8.0.4.0.0
Release |
Process Modelling Framework |
- |
25679555 |
8.0.4.0.4 |
BACKWARD COMPATIBILITY ISSUE WITH WORKFLOW FOR PCD
8.0.4.0.0 |
Model Upload |
- |
25828416 |
8.0.4.0.5 |
INCONSISTENCY IN SCHEMA DUE TO DROPPED FKS IN CASE
OF PK ORDER CHANGE |
|
25555593 |
8.0.4.0.6 |
804 FSDF MODEL UPLOAD FK ARE GETTING DROPPED |
|||
Advanced Analytics Infrastructure |
Modeling |
25832689 |
8.0.4.0.7 |
MODEL FILTERS GET REMOVED ON DEPLOYING THE MODEL TO
PRODUCTION |
|
ABC |
Questionnaire |
25657660 |
8.0.4.0.8 |
MISMATCH IN THE LENGTH OF A COLUMN |
|
Inline Processing |
- |
25806091 |
8.0.4.0.9 |
HIGHLIGHTS QUERY DOES NOT HAVE BATCH FILTER ON
ACTIVITY TABLE |
|
Data Model |
- |
25723451 |
8.0.4.0.10 |
CERTIFICATION WITH ERWIN DATA MODELER STANDARD
EDITION R9.7 |
List of Bugs Fixed in This Release
Component |
Sub-component |
Bug |
Subject |
Administration |
- |
25730799 |
ISSUE IN USER PASSWORD RESET UTILITY |
25688179 |
LDAP-AFTER UNCHECK "MULTIPLE LOGIN" ,USER STILL CAN
LOGIN MULTIPLE TIMES |
||
25756900 |
DUPLICATE DATA IN USER PROFILE REPORT |
||
25748370 |
804 LOGIN PAGE HAS SCRIPT ERROR IN INTERNET EXPLORER 10 |
||
25730775 |
ISSUE IN USER ENABLE/DISABLE UTILITY |
||
Advanced
Analytics Infrastructure |
- |
25716377 |
NOT ABLE TO VIEW NAG MODEL OUTPUT |
Dimension
Management |
Attributes |
26030720 |
NOTHING TO SAVE ERROR WHEN EDITING DIMENSION MEMBER ATTRIBUTE
VALUES |
Data Model |
- |
26028901 |
ORA-00001: UNIQUE CONSTRAINT
(OFSAAATM.PK_AAI_ENTITY_ALTER_TRACE)>MODEL UPLOAD |
Expressions |
- |
25742030 |
CANNOT SAVE EXPRESSION WITH ENTITY IN OFSAA 8.0.4 |
Forms Framework |
Forms
Rendering Engine |
25468181 |
COMPAREDATES FUNCTION NOT WORKING WHEN DATE FORMAT IS
DD-MON-YYYY |
- |
25907895 |
PAGINATION LIST STAYS ALWAYS ON AFTER CLICKING ONCE |
|
25693636 |
TABS REFRESH WITH SAVED FIELD CHOOSE PREFERENCES |
||
25494815 |
GAP IS COMING B/W THE LAST COLUMN & THE VERTICAL SCROLL BAR
IN GRID WITH SPAN |
||
25929152 |
CALENDAR POPUP IS NOT
CLOSING EVEN AFTER NAVIGATING FROM ONE PAGE TO ANOTHER |
||
25641133 |
UNABLE TO SELECT NODE IN INLINE HIERARCHY IN STANDARD MODE |
||
Rules Framework |
Rule |
25633347 |
DEFAULT MEMBER SELECTION NOT WORKING PROPERLY |
Other |
- |
25802635 |
OBJECT MIGRATION OF MAPPER DEFINITION FAILS WITH
"ORA-00936: MISSING EXPRESSION |
25903678 |
MULTITHREAD SUPPORT FOR LIBDATABASE |
||
ABC |
Questionnaire |
25776429 |
ISSUE WITH RE-ORDERING OF THE QUESTIONS AND SECTIONS IN QUESTIONNAIRE |
System Configuration |
Configuration |
25594367 |
FREQUENCY OF PASSWORD CHANGE IN SSO IS NOT REFLECTING |
25441396 |
SAML REQUEST ID TO START WITH ALPHABET AND CERTIFICATE
VALIDATION FIX |
||
Unified
Metadata Manager |
Data
Quality Group |
25857973 |
THRESHOLD QUERY FETCHES WRONG COUNT OF IMPACTED RECORD IF FILTER
IS NOT PRESENT |
Metadata
Browser |
26133585 |
UNABLE TO OPEN THE DOWNLOADED EXCEL FROM METADATA BROWSER |
|
25928201 |
UNABLE TO OPEN THE DOWNLOADED PDF FROM METADATA BROWSER |
||
Technical Metadata Management |
25542362 |
LONG RUN TIME IN EXECUTION OF RBI CONTRACTUAL RUN |
|
Process
Modelling Framework |
Process Modelling Engine |
25998223 |
TASKS DO NOT NAVIGATE TO ENTITY DETAILS, WHEN 804 OR IS
INSTALLED ON 8041 AAI |
Known Issues
Component |
Sub-component |
Bug |
Subject |
Data Entry Forms and Queries |
- |
25239325 |
UNABLE TO SAVE DEFQ FORMS |
Style Sheet Issues |
- |
24338171 |
TABBING FUNCTIONALITY FOR CONTROLS AND FORM ELEMENTS |