Oracle Financial Services Data Integration Application Pack Release v8.0.0.0.0 Minor Release #2 (8.0.2.0.0)

OFS Data Integration Application Pack is a separately licensed product.

Description

Bug 22906120 - OFS DI 8.0.2.0.0 MAINTENANCE LEVEL RELEASE #1 (8.0.2.0.0)

This minor release of OFS Data Integration (DI) application pack is cumulative of enhancements and bug fixes done since the 8.0.1.0.0 Release.

Prerequisites

The pre-requisites required for this release is as follows:

·         The minimum patch set level should be DI 8.0.1.0.0

How to Apply This Minor Release?

For details, refer to Oracle Financial Services Data Integration Installation Manual Release 8.0.2 in OTN Documentation Library.

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

·         Known Issues/ Limitations

New Features in This Release

Following is the list of new features incorporated in this release. For detailed information on usage of these features, refer to OFSAAI 8.0.2.0.0 User Guide.

·         Data Management Tools

o    Table creation on the fly from Data File Mapping and Data Mapping screens is introduced. This allows you to add dynamic tables into the data model within OFSAA ecosystem.

o    Query validation is made optional while saving Data Mapping definition through the introduction of a new configuration parameter.

o    To limit the number of records that needs to be loaded, a new target property (RecordLoadLimit) is introduced in Data Mapping definition.

·         Data Quality Framework

o    Dynamic Degree of parallelism for RDBMS is supported.

o    Referential Integrity checks can be defined using composite key columns.

·         System Configuration & Identity Management

o    Users can be optionally created or modified to get authenticated using OFSAA Security Management System in case LDAP authentication is configured. 

o    Audit Trail report has been enhanced to show detailed information for various operations such as User -User Group map, User Group-Domain map, User Group- Role map, User Group –Folder-Role map, Role-Function map and Profile Holiday Map.

·         Business Metadata Management

o    Derived Entity definition supports creating materialized views with option to refresh fast/force/complete on demand/commit and query rewrite.

·         Forms Framework

o    Forms Framework has been enhanced to render Forms with CSS3 and HTML 5 constructs in addition to support of HTML 3. This is to enable support of Standards Mode and rendering of HTML pages in Internet Explorer and Google Chrome. 

o    Migration of Tabs and Layout details is supported for Object Migration Command line utility.

o    The behavior of the type 102 control can be changed to either single select or multi-select based on a particular column value of the grid.

·         OFS Analytical Applications Infrastructure (OFS AAI)

o    A command line utility has been introduced for resaving derived entity either through Batch framework or stand alone.

o    A command line utility has been introduced for source model generation.

o    Forms are rendered in standard mode based on DB Flag.

o    DB Catalog option supports reverse generation of existing database metadata into OFSAAI metadata repository by connecting to RDBMS Schema specified as DataDom in the Information Domain.

o    Configuration of onchange and ismandatory functions is introduced for Flexible KBD controls.

 

List of Bugs Fixed in This Release

Component

Sub component

Bug ID

Description

Administration

Object Migration

22446723

OBJECT MIGRATION SHOULD PERSIST SOURCE AND TARGET OBJECT IDS INTO DATABASE

Utilities

21328053

INFODOM DROPDOWN IN "USER GROUP-BATCH EXECUTION MAP" SCREEN SHOWS FULL LIST

Metadata such as T2T, F2T, etc

22539004

T2F TASKS ARE FAILING

T2T Issues

21812780

T2T FINISHES SUCCESSFULLY WHEN REJECTION THRESHOLD EXCEEDED

GRC Infrastructure

 

22459967

SEARCH FUNCTIONALITY NOT WORKING IN KBD PREFERENCE SUMMARY PAGE FOR OTHER LOCALE

22459895

KBD MAPPER AND CHECKER SCREEN NOT GETTING TRANSLATED IN OTHER LOCALES

Business Restructure

21625588

MULTI LOCALE SUPPORT IN BUSINESS RESTRUCTURE

Rules Framework

22486848

WSMREREQUEST.SH FAILED WITH ORA-12899

System Configuration

Configuration

22453450

APPLICATION ID IS NOT DISPLAYING CORRECT FOR OTHER LOCALES IN MODIFY/VIEW SCREEN

Information Domain

21484146

ADD PERSISTENCE UNIT ENTRY IN GRCPERSISTENCE&PERSISTENCE DURING INFODOM CREATION

Operations

Batch Monitor

21949567

API'S REQUIRED TO TRACK THE BATCH STATUS

Workflow Framework

 

21610478

UNABLE TO ADD MORE THAN ONE DATA FIELD

Data Entry Forms and Queries

Data Entry

21339271

NUMBER FORMAT CAUSES EDIT TO FAIL WITH SPECIAL CHARACTER NOT ALLOWED ALERT

Data Loading

21173111

'ORA-12899: VALUE TOO LARGE FOR COLUMN' IN MESSAGESERVER LOG RUNNING F2T

Forms Framework

20598965

MENU AND DROP DOWN OVERLAP

Security Management System

21697204

UCP CONNECTION POOL FAILING IN ALL THE LAYERS

Install and Upgrade Issues

Service Packs

21915445

PATCH INSTALLER DOES NOT VALIDATE FOR SESSION LEVEL SHELL AND PROCEEDS WITH BASH

Base Installer

21810719

ENVCHECK.SH CHECKS NLS_LENGTH_SEMANTICS DATABASE SETTING AT SESSION LEVEL

20727720

EDITABLE INFORMATION DOMAIN NAME FIELD IS NOT USER FRIENDLY

Unified Metadata Manager

Metadata Browser

22455350

MDB>DATA SOURCES MENU IS NOT TRANSLATED TO OTHER LOCALES

Business Metadata Management

21367887

$MISDATE,$RUNSK DOES NOT WORK IN DATA SET ANSI JOIN SUBQUERIES

20760616

NEED SPECIAL CHARACTERS IN HIERARCHY SHORT DESCRIPTION

Data Quality Definition

20511796

CHANGE IN ALERT MESSAGE IN DQ LIST OF VALUES CHECK RULE WHEN FILTER TYPE IS CODE

21464164

MAPPER SCREEN PAGE IS TAKING TOO MUCH TIME TO LOAD AND SAVE

Known Issues/ Limitations in This Release

·         Model Upload with DB Catalog option is not supported for RBDMS based Information Domains.

·         Model upload mode for the subsequent uploads is not same as the initial upload mode.

·         Exporting object type with code 2000 (User) fails if FAILONERROR is set to N.

·         Dynamic table created during Data File Mapping has incorrect column data types.

·         Data Mapping screen alignment changes if tables selected are with big names.

·         Description is not getting updated in Excel Upload edit mode.

·         Export with Include Search Info option for Type =1 container is not showing search information when exported to Excel Sheet.

Oracle Financial Services Data Integration Application Pack

This section includes the following sub-sections:

·         New Features in This Release

·         List of Bugs Fixed in This Release

·         Known Issues/ Limitations

New Features in This Release

Following is the list of new features incorporated in this release.

·         Fact tables loading and extract

·         Support of HIVE source with kerberos authentication.

·         Publish of DIH connectors as Mappings in ODI 12c.

·         User defined date format for HIVE

·         Table to table loading using JDBC connection

·         ODI connectivity using WebService

List of Bugs Fixed in This Release

Bug No.

Subject

22538202

ISSUES WHILE CONCURRENT USERS CREATING CONNECTOR

22920812

RECONCILIATION LOADING FAILED WITH ODI 12C

22885949

INCREMENTAL ADI REFRESH ISSUE WHEN CHANGED ADIS ARE LINKED TO CONNECTOR

22865877

UNABLE TO EXECUTE CONNECTORS USING BATCH MAINTANANCE with ODI 12c

22893640

ISSUE WITH INT DATA TYPE WHILE PUBLISHING

22845017

UNABLE TO SAVE EDS IF HIVE JDBC URL EXCEEDS 100 CHARACTERS

22844750

EDD SELECTION ISSUE IN CONNECTOR IN EDIT MODE

22551382

UNABLE TO RESUBMIT IMPORT MAPPING REQUEST IN DIH-CONNECTOR 

22858616

UNABLE TO SPECIFY HIVE JDBC DRIVER NAME OTHER THAN STANDARD APACHE HIVE DRIVER

Known Issues/ Limitations in This Release

Bug No

Subject

22929845

UNABLE TO MAP EDITED EXPRESSION TO TARGET COLUMN IN CONNECTOR SCREEN

22929751

PARAMETER IN EDD FILE NAMES ARE UNABLE TO PASS THROUGH BATCH EXECUTION

22573696

UNABLE TO PUBLISH CONNECTORS WITH MULTIPLE USERS LOGGED IN

22218925

REFRESH TARGET DATA STORE IS TAKING MORE TIME

20378183

CONNECTER PARAMETERS ARE NOT ABLE TO PASS THROUGH RULES FRAME WORK