OFS Data Foundation Application Pack is a
separately licensed product.
Description
Bug # 25881273 - CONSOLIDATED DATA QUALITY RULE FIXES FOR
FSDF & REG REPORTING USFED
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 One-Off Patch Release?
Perform the following steps to apply the
one-off patch:
1.
Login to https://support.oracle.com/, and search
for Bug# 25881273 under Patches and Updates tab.
2. Download 25881273_GENERIC.zip archive file, and copy it to your OFSAA server in Binary mode.
3. Shut down all the OFSAAI Services.
4. Extract the contents of the patch archive file by using the command: unzip -a <name of the file to be unzipped>
For example: unzip -a 25881273_GENERIC.zip
Note: The above "-a"
option is mandatory to unzip the patch. In case you notice an error message “unzip: not found [No such file or directory” when the package is not installed, contact your UNIX administrator to
resolve this issue. For further details, refer to Oracle Financial Services Data
Foundation Installation Manual Release 8.0.4.0.0 in OTN Documentation Library.
5. Grant RWX (755) permissions for folder by executing command: chmod -R 755 OFS_BFND
6. Navigate to the path: <>/OFS_BFND/conf
7. Update the UPLOAD_MODEL parameter value to 0 in params.conf file to skip
model upload.
8. Navigate to the path: <>/OFS_BFND/bin
9. Execute the command: ./install.sh
10. Verify the patch installation logs in the location <>/OFS_BFND/logs. Contact Oracle support in case of any errors.
11. Generate the application EAR/WAR file and redeploy the application in
the configured web application server. For further details, refer to Oracle Financial
Services Data Foundation Installation Manual Release 8.0.4 in OTN Documentation
Library.
12. Restart all the OFSAAI services. For further details, refer to Oracle
Financial Services Data Foundation Installation Manual Release 8.0.0.0.0 in OTN Documentation
Library.
List of
Bugs Fixed
Bugs |
Description |
22850900 |
DQS WHICH HAVING N_RULE_SYS_ID MORE THAN 200000 NEED
TO BE FIXED |
23275270 |
DQ CHECK RULES ARE NOT AVAILABLE IN FOLLOWING TABLES
UNDER FSDF |
25309133 |
FSDF DQ FAIL FOR COLUMN REFERENCE CHECK WITH COLUMN
REF FILTER TYPE |
25336947 |
SOME OF THE DATA QUALITY CHECKS DEFINED ARE
INCORRECT |
25665530 |
DQ ISSUES ON STG_LOAN_CONTRACTS AND STG_COMMITMENT_CONTRACTS |
25680357 |
OUT OF BOX DQ (LOAN CONTRACT VALUEDT)HAS INCORRECT
QUERY COMPARED TO DESCRIPTION |
25680423 |
OUT OF THE BOX DQ CHECKS TO SEE WHETHER THE TARGET
COLUMN HAS A VALUE IS NOT WOR |
25692979 |
OUT OF BOX DQ RULE(LOAN CONTRACT) HAS INCORRECT
QUERY COMPARED TO DESCRIPTION |
25695254 |
OFSAA FSDF OUT OF THE BOX DATA QUALITY RULES HAS
MISSING FIC_MIS_DATE FILTER |
25700534 |
OUT OF BOX DQ (FORECLOSURE) HAS INCORRECT QUERY
COMPARED TO DESCRIPTION |
25833323 |
OOTB DQ'S ISSUE |
25881609 |
DQCUSTACCT1404 - ISSUE WITH DQ LOGIC |
25947875 |
ISSUES WITH STG_LC_CONTRACTS DQ CHECKS IN FSDF 8.0.3 |
25951048 |
ADDITIONAL DQS FOR WELLSFARGO ALPHA TESTING |
25967654 |
DQ EXECUTION FAILING FOR THE DQ ID DQCUSTACCT1692 |
26002097 |
ADDITIONAL INCORRECT OOTB DATA QUALITY RULES IN FSDF
8.0.3 |
26022594 |
ISSUES WITH OOB DQ RULES |
26022691 |
DQ CREATION GIVING A UNIQUE CONSTRAINT ERROR |
26098859 |
THE BELOW LIST OF DQS DOES NOT HAVE THE VALUES THAT
LOV TAKES |
26116229 |
BLANK VALUE CHECK DQ'S ARE DEFINED ON COLUMNS WHICH HAVE
DATA TYPE AS NUMBER |
26116272 |
NULL VALUE DQ CHECK DEFINED ON COLUMNS WHICH ARE NOT
NULL |
26132606 |
DQS WITH SIMILAR DESCRIPTIONS |
26132833 |
LIST OF DQS HAVING UNCLEAR DESCRIPTIONS |
26132854 |
DQ CAPTURED ERRONEOUSLY IN UI |
26141267 |
DQ OF REFERENTIAL INTEGRITY CHECK REFERENTIAL COLUMN
IS NOT AS PER DESCRIPTION |
26142472 |
MISMATCHES IN COL REF DQS |
26142501 |
OOTB DQ RULES FOR STG_LOAN_RECOURSE_TYPE_MASTER NOT
WORKING AS EXPECTED |
26142522 |
RANGE CHECK DQS MISMATCHES |
26142570 |
DQ WITH LOV CHECK MISMATCHES |
26160124 |
CONTRADICTING DQ CHECKS |
26160146 |
ISSUE WITH REGARDS TO DUPLICATE DQS IN 804 FSDF
RELEASE |
26162816 |
DQS WITH UNCLEAR OR CONTRADICTARY DESCRIPTIONS |
26162887 |
DQ NEEDING MERGING OF LIST OF VALUES |
26164641 |
MERGING OF DQS WHEN ONE IS SUBSET OF OTHER |
26166398 |
ADDITIONAL DETAILS IN FILTER OF THE DQS |
Note: See the list
of DQs that have been deleted from FSDF as they were invalid or duplicates.