OFS Data Foundation Application Pack is a
separately licensed product.
Description
Bug 25260082 – Oracle Financial Services Data Foundation
Application Pack v8.0.3.1.0
This is first Maintenance Level Release (ML) of OFSDF,
cumulative of enhancements and bug fixes done since the 8.0.3.0.0 Release.
Prerequisites
The pre-requisites required for this release is as follows:
·
The minimum patch
set level should be OFSDF 8.0.3.0.0
How to Apply This Maintenance Release?
For detailed instructions on installing
this Maintenance Level Release, refer to OFSDF 8.0.3.1.0 Installation Guide in OTN.
New Features in This Release
1.
FSDF
Run
Two Runs are introduced Financial
Services Data Foundation for Data Population:
a.
Financial
Services Data Foundation Sourced Run
This Run can be executed once per day for Data Movement from Staging
Area to Results Area for Non-RUN SKEY tables.
b. Financial Services Data Foundation
Execution Run
This Run can be executed any number of times per day with each unique
RUN SKEY for Data Movement in Run enabled tables.
2.
Run Parameters
for Run Management
Two Run parameters are introduced for passing the
values during Run execution.
a.
Reporting
Currency Code (RCY) parameter
Reporting Currency Code parameter is used for calculation of amounts in
Reporting Currency during Data Population.
b. Legal Entity Code (LE)
parameter
Legal Entity Code parameter is used for identifying the
legal entity which is used for the Run.
3.
Dataflow Changes
for Snapshot Data Load into Results
Introduced changes in Run enabled T2T joins for
loading only Snapshot Data into Results table.
List of Bugs Fixed in This Release
Bug |
Subject |
25059370 |
COLUMN ADDITION TO
STG_MERCHANT_CARDS TABLE FOR 2052A REPORTING |
24618820 |
OFSAA - LANGUAGE CODE IN
STG_<DIMENSION>_TL_INTF TABLE |
25115882 |
DATATYPE MISMATCH IN T2T_STG_CASA_CAS
AND T2T_STG_TD_CONTRACTS_CAS |
25061067 |
MLS SCD |
25182260 |
MAPPING NOT AVAILABLE FOR
N_AMORTIZED_COST & N_GUARANTOR_SKEY |
24527486 |
COLUMNS NEED TO BE ADDED IN
STG_MERCHANT_CARDS TABLE |
24598408 |
MAPPING MISSING FOR SOME OF THE
SCD'S |
24620516 |
DUPLICATE JOIN CONDITION IN
T2T_FCT_ACCOUNT_MITIGANT_MAP |
24339324 |
MISSING COLUMNS FOR FFIEC-031 AND
FRY-9C REPORTS |
24316225 |
STAGING REFERENCE COLUMN NOT
AVAILABLE FOR DIM_ORG_STRUCTURE. V_DEPOSIT_INS_GUAR |
24941735 |
2052A - OOTB
T2T_FCT_ACCOUNT_MITIGANT_MAP JOINS TWICE WITH SAME TABLE |
25110889 |
COLUMNS AND/OR T2T MAPPING REQUIRED
IN FACT TABLE FCT_CARDS_SUMMARY |
25038985 |
V_ORG_UNIT_CODE VS
V_BUSINESS_UNIT_CODE IN T2T OF STG_LOAN_CONTRACTS |
24916777 |
DIM_PARTY SCD |
25132072 |
F_INTERNAL_CUST_IND UNAVAILABLE IN
STG_CORRESPONDENT_ACCOUNT TABLE |
25222938 |
T2T_FCT_MR_CAPITAL_SUMMARY_FMRIRC -
DIM_COMMODITY_GROUP IS NOT PART OF BASEL |
25222956 |
MAPPING MISSING IN
T2T_FRCAS_FCT_SEC_EXPOSURES |
25239866 |
FCT_REG_CAP_ACCOUNT_SUMMARY MAPPING
MISSING |
25213964 |
ADI NAME UDP SHOULD HAVE VALUES FOR
ALL THE STG & RESULTS TABLES |
25222642 |
DIM_COMMODITY_GROUP TABLE IS NOT
PART OF BASEL , SO NEEDS TO CORRECT THE T2T |
25247311 |
FCT_COMMON_ACCOUNT_SUMMARY.F_TRADING_BOOK_IND
IS POPULATED WITH Y AND N. |
25140077 |
SCD IS
UNAVAILABLE:-STG_MERCHANT_CARDS TO DIM_ACCOUNT |
25096427 |
TABLE FCT_REG_CAP_ACCOUNT_SUMMARY
POPULATION ISSUES |
25140838 |
T2T_FCT_REG_CP_CAPITAL_SUMMARY JOIN
ISSUES |
24836318 |
ISSUE WITH VIEW DEFINITION -
VW_STG_PARTY_MASTER_CUST |
23592467 |
STG_MERCHANT_CARDS DATA FLOW FOR
FR2052A REQUIREMENT |
25336258 |
SUPPORT FOR FSDF8031 IN AIX7.1 |
List of Known Issues in This Release
Bug |
Subject |
25264798 |
TABLES WITH SAME OFSAA_DATA_INT_NAME
AND OFSAA_DATA_INT_SUBTYPE |