Oracle Financial Services Advanced Analytical Applications Infrastructure -Application Pack v8.0.0.0.0 Minor Release #1 (8.0.1.0.0)

Description

OFS AAAI Application Pack v8.0.0.0.0 Minor Release #1 8.0.1.0.0 (ID 21054241)

This release of OFS AAAI Application Pack is cumulative of all enhancements and bug fixes done since v8.0.0.0.0 release.

Prerequisite

The minimum patch set level should be OFS AAAI Application Pack v8.0.0.0.0.

How to Apply This Release?

For detailed instructions on installing this OFS AAAI Release, please refer to OFS AAAI Application Pack Installation and Configuration Guide_8.0.1.0.0.

Starting 8.0.0.0.0 release, OFSAA applications are packaged and released as Application Packs. OFS AAAI Application Pack includes OFS AAI, OFS Enterprise Modeling, and OFS Inline Processing Engine. Refer to the subsequent sections for more details.

· Oracle Financial Services Analytical Applications Infrastructure

· Oracle Financial Services Enterprise Modeling

· Oracle Financial Services Inline Processing Engine

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.1.0.0 User Guide.

1. Business Restructure

· Business Restructuring in corporate management is act of reorganizing Ownership, Operational or other structures of the company for making it more profitable or better organized for its present needs. Other reasons for restructuring include demerger or a response to major change in the business such as repositioning or buyout.
A module has been introduced in this release to configure and manage the restructuring process across the organization.

2. Process Orchestration Framework

· A new module has been introduced to support built-in tooling for orchestration of human, automatic workflow interfaces as well as various OFSAA Processes.

· Support for visual modeling of the Workflow and Processes.

· Support for registration of Process /Activity/ Transition Logic implementation, separated from the modeling process itself.

· Built-in orchestration engine (included within OFSAAI’s runtime) for workflow execution (interactive model as opposed to the batch model supported through Rule Run Framework).

· Published interface for abstraction of workflow task implementation.

· Representation of the workflow-routing rule logic in Java/ PL-SQL / Web-service.

· Process Monitoring Admin Tool to view and control the Execution Process Instances.

3. Data Management Tools

· Ability to preview Database details while creating Data Sources has been introduced.

· Ability to preview data of the source/ target entities has been provided while defining Data Mapping and Data File Mapping.

· For Data Mapping, there is no default limit set for Rejection Threshold and the value needs to be set if it is required.

· Data Sources creation has been modified to pick up the connection details created from the Database Details screen.

4. Data Quality Framework

· Data Quality rules can be defined on Data Management Sources. 

· Data Quality checks can be performed based on Unique Identifier Columns other than Primary Key columns.

· In the Data Quality Reports, the Primary Key columns or Unique Identifier Columns are displayed.

5. Mapper

· Copy feature of Mapper definitions is introduced.

· While defining a Mapper, an option to create Database View has been provided.

6. Business Metadata Management

· Ability to preview the query and the data from the Dataset definition is introduced.

7. Object Migration

· Command Line Migration now supports Security Management System (SMS) objects such as Users, Usergroups, Functions, Roles, and Profiles along with the mappings.

· The Object Migration Command Line Utility (offline option) supports wildcard (*) feature.

8. Run Rule Framework

· The Use Descendants option for a Parent Child hierarchy has been provided to apply self/ descendants to a Run/Process condition implicitly.

· The Process engine has been enhanced to support “Select Insert” and “Partition Swap” query along with the “Merge” query.

· The Rule engine has been enhanced to support “Select Insert” and “Partition Swap” query along with the “Merge” query.

9. Model Upload

· A command line utility has been introduced to perform Object Registration independently for an Information Domain where model upload is done successfully.

10. DEFQ

· From the Excel Entity Mappings and Excel Upload screen, you can download the Excel template which is used in the mapping.

11. System Configuration and Identity Management

· Create New Application feature has been introduced, which enables to create an Application using the standard platform frameworks.

· The Database details screen has been enhanced to support for heterogeneous database.

· Users can be created with an option to authenticate through SMS even when LDAP or SSO authentication is enabled.

· SSO authentication using SAML v2 is introduced. This release supports only 1-way SAML authentication.

· User Provisioning API is provided so that User Objects can be provisioned in OFSAAI using web service call.

· An option to reinstate the deleted users has been introduced.

12. Forms Framework

· Flexible Key Business Dimensions(KBDs)

· Configuring Flexible KBDs is supported, which provides centralized configuration approach to KBD usage in the Applications, other than the seeded KBDs.

· Other Enhancements

· Spell check feature can be enabled for Text Box, Text Area, and Rich Text controls.

· A new feature is provided to pick the list of values for radio button and check box dynamically.

· Dynamic Filtering of drop-down for multi-select control has been introduced.

· Tool tips are provided for the wrap and unwrap buttons when the Image text is blank.

· Auto-fit feature is provided for Editable grid with multiple grids.

· Special characters are supported in multi-select control.

· Document delete feature is provided.

13. Metadata Browser

· Data Mapping along with User Defined Properties (UDPs) can be exported to Excel.

· An option to display Data Mapping with the selected UDPs is provided.

· The following objects are supported:

· Data Sources

· Data Source Entity

14. Link Analysis

· Single click option has been provided for Nodes.

· If multiple links (different types) are shared between two nodes, then the link is considered as complex link instead of duplicate link.

· Link Analysis graph has been enhanced to display with scroll bars for large graphs. Additionally, when a graph is zoomed out, the scroll bars will be displayed.

List of Bugs Fixed in This Release

Component	Sub Component	Bug No	Subject
Unified Metadata Manager	Metadata Browser	21237919	COLUMN NAME ON WHICH MEASURE BUILT IS MISSING IN METADATA BROWSER
		20873646	FORMAT OF PDF DOWNLOADED FROM MDB SCREEN IS NOT PROPER
	Data Quality Definition	19986171	QUERY VALIDATION FAILING WHEN CLICKED ON GENERATE QUERY FOR CUSTOM CHECK
	Technical Metadata Management	19435376	REMOVE RLT FROM MAPPING SCREEN FOR FILE EXTRACTS (SysDate and Constant value are supported)
		19429082	IF TABLE LOGICAL NAME IS EMPTY THE UI APPENDS NULL TO IT WHEN U REOPEN ENTITIES
Data Entry Forms and Queries	Forms Designer	19786363	'SELECT LIST' DOES NOT WORK IN 'INEDIT OR ADD' IN DEFQ FOR FOREIGN KEY COLUMN
	Data Entry	21339254	NUMBER FORMAT CAUSE EDIT TO FAIL WITH SPECIAL CHARACTER NOT ALLOWED ALERT
		19928860	FILTERS NOT WORKING PROPERLY ON DEFI WHEN EXPORT SELECTED
		19684150	DATA ENTRY SCREEN ALLOWS TO ENTER SPECIAL CHARACTERS IN TABLES USING COPY/PASTE
		20753155	FILTER CONDITION IS MISSING WHEN EXPORTING DATA FROM ENTRY FORM INTO CSV FILE
		17568615	CLICKING ON GRID VIEW & THEN COPY IS SHIFTING TO THE RIGHT BY ONE COLUMN.
	-	19635160	INVALID INPUT FOUND FOR PARAMETER TABLE NAME" ERROR ON CLICKING COLUMN HEADER
		19634971	SEARCH FUNCTIONALITY NOT WORKING WHEN CREATED A FORM WITH TWO TABLE
Dimension Management		18876170	REV_HIER_FLATTENED USE & AS DELIMITER CAUSING BATCH HIERARCHY LOAD OVERLOAD
Operations		19824312	TIMESTAMP(DATE & TIME) REQUIRED IN ICCSERVER LOG
	Batch Execution	20605588	BATCH EXECUTION SHOULD THROW PROPER ALERT IF ICCSERVER IS DOWN
Forms Framework	Forms Manager	20626675	MASKING ISSUES IN FORMS FRAMEWORK
		20753413	FORM DATASET ENTITIES DOES NOT ALLOW CONFIGURATION OF MORE THAN 4000 CHARACTERS
Metadata such as T2T, F2T, etc		20802601	MESSAGESERVER SHOULD SHOW PROPER LOG IF PASSWORD ABOUT TO EXPIRE
		19689752	F2T LOAD SUCCESSFUL BUT RECEIVED [6601] COULD NOT READ HEADER FILE
	F2T Issues	21103110	UNABLE TO F2T WHEN SOURCE IS DEFINED ON A REMOTE SERVER
Preferences	Global	21345344	GLOBAL PREFERENCES: FUNCTIONAL CURRENCY AND SIGNAGE BLANK
Rules Framework	Manage Run Execution	20760953	WHEN ATTEMPTING TO LAUNCH 2 RRF BATCHES IN PARALLEL ORA-00001 IS RECEIVED
		21105097	BACKWARD COMPATIBILITY MISSING FOR WSMRE UTILITY
		17585185	GETTING WEBSERVICEEXCEPTION WHILE EXECUTING WSMRESTARTUP.SH
	Rule Execution Engine	20228822	CHANGE OF MERGE WITH PARTITION SWAP
		19610888	MERGE ARE NOT TAKE ADVANTAGE OF PARTITION LOGIC IN CASE QRY_OPT_USE_ROWID=Y
Link Analysis	-	21176553	NETWORK VISUALIZATION GRAPH IS NOT LOADING (DISPLAYING), ITS THROWING JSP ERROR.
		20754376	LINK ANALYSIS AFTER LOADING THE GRAPH ACKNOWLEDGMENT IS REQUIRED
Install and Upgrade Issues	-	21220708	MEDIA PACK INSTALLERS ARE NOT VALIDATING ORACLE DATABASE VERSION PRE-REQUISITES
		21168440	PRE-CHECK UTILITY SHOULD VALIDATE THE EXISTENCE OF EN_US.UTF-8 LOCALE
		21052420	SCHEMA CREATOR UTILITY VALIDATION FAILS IF ORACLE SERVER IS ON A WINDOWS MACHINE
		20952939	PORTC.JAR DOES NOT CHANGE PORT TO 443
Administration	Utilities	21112846*	LINK TO METADATA PUBLISH FROM UI TO BE REMOVED

* User Interface link to publish Metadata in Metadata Browser is removed from Financial Services Analytical Applications Infrastructure > Object Administration > Utilities. Instead Command Line Utility is available to publish Metadata in Metadata Browser.

Known Issues/ Limitations in This Release

Component	Sub Component	Bug No	Subject
Administration	-	21423196	OFSAAI does not allow to enter the special characters such as '~!@#$%^&*()_+' in SFTP / FTP details screen
Data Entry Forms and Queries	Excel Upload	21354370	The Description of an Excel-Entity mapping definition is not getting updated in edit mode.
Model Upload		21207454	Model upload summary grid does not display the status of Object Registration process.
Rules Framework	Rule Execution Engine	21335353	Execution log does not provide detailed steps of execution if Execution mode is set as SELECT or PARTITION SWAP at Rule/Process/Run Level.
System Configuration	Database Details	21341795	No field restriction is given for the Name field in the Database details. Validation is done only after user clicks Save.
Unified Metadata Manager	Business Metadata Management	21205832	When a multi level hierarchy is used and the same hierarchy is repeated in more than one level, Pushdown operation is failing.
	Data Quality Group	21297551	Data Quality Group Summary grid does not display whether the DQ group is defined on Data Source or Infodom.
	Data Quality Definition	21421824	Java script error occurs when user clicks the online help icon from DQ Rule Summary page.
		21297543	Data Quality Rule Summary grid does not display whether the DQ Rule is defined on Data Source or Infodom.
		21216533	If you are defining Data Quality check on a Data Management Source, only quality check will be done; data correction will not be done since it is an external source. The UI does not restrict to perform any assignments on such DQ rules.
	Import Business Model	21422610	Model Upload log file provides incorrect information about indices.
	Metadata Archive Restore	21178745	From the Object Migration> Restore Metadata, when you click Browse to select the DMP file, the directory/folders are not displayed.
	Technical Metadata Management	21229361	Table Logical name is empty for Data File Mapping screen.
		21420020	Saving Data Mapping definition takes long time if an entity containing many attributes (>100 columns) is selected as Source entity.
		21201150	Show Details/ Data Preview should be available under selected Members tree.
Forms Framework	Forms Manager	21221027	Forms Manager application expects IE 11 Compatibility Mode setting from every client browser.
Link Analysis	-	20920008	Link Analysis context menu is going out of page and user has to scroll to view it.

Oracle Financial Services Enterprise Modeling

New Features in This Release

Following is the list of features incorporated in this release. For detailed information on usage of these features, refer to OFS Enterprise Modeling User Guide 8.0.1.0.

· Installation/ Configuration

· Execution venue (server where scripts will be executed) specific Post scripts, Pre scripts and Implementation can be configured.

· Multiple R server nodes for execution are supported.

Note: For more information, see OFSAAI Administration Guide.

· Variable Definition

· Variables can be defined from Stress Testing as well as Data Management modules.

· Business Processor, Measures, and Datasets can be created from the Variable Definition.

· Object security has been implemented to restrict the access of Variable definitions through a Folder concept (similar to directory structure in File System).

· Variable definition based on Entity supports creation of multiple variables at once, for the selected attributes.

· Modeling

· Support of Model Chaining, wherein the output of a model can be used as input of another model, has been introduced.

· Model Definition can be updated for a specific Model version.

· The run and process filters created during Run definition will be considered for model execution.

· The R script models can be executed directly on Open R Distributions in addition to ORE.

· Multiple datasets can be associated with R models that are executed using Open R Distributions.

· The Datasets and Input Variables can be created from the Model Definition (on the fly).

· Ability to preview the Database details from the Model Definition has been introduced.

· Show Version option to view the older versions of Models from the Model Summary has been introduced.

· During Model definition, you can indicate the execution venue and scripting language.

· Model outputs can be updated back to the tables by mapping the outputs to the Output variables.

· Support for multivariate Group executions for ORE based models has been introduced.

· Sandbox

· Incremental data population in Sandbox now considers filters other than Time filters.

· The Datasets can be created from the Sandbox definition and you can view its details.

· Techniques Registration

· During Techniques definition, you can indicate the scripting language.

List of Bugs Fixed in This Release

Component	Sub Component	Bug No	Subject
Advanced Analytics Infrastructure	Sandbox Definition	19684146	SOURCE DATASET FIELD DISPLAYED DISABLED IN SANDBOX DEFINITION EDIT SCREEN
		20112608	MULTIPLE DATASET ASSOCIATION TO SANDBOX
		19717307	ADDITIONAL FILTERS REQUIRED FOR SANDBOX POPULATION SUCH AS DATA VERSION.
	Sandbox Data Maintenance	19703773	DISPLAY ALERT ON CLICK OF AUTHORIZE TAB IF SANDBXAUTH NOT MAPPED TO USER
		20753018	NONSEC SANDBOX POPULATION ERROR DATATYPE_CHAR::PROBLEM IN SETSTRINGDATA
	Model	20160800	OUTPUTS GETTING DELETED FROM THE OUTPUT FOLDER ONCE VIEWED FROM OUTPUT SCREEN
		20135739	DELETING A TECHNIQUE IS NOT HAPPENING RECURSIVELY.
		20160505	MULTIVALUEPARAMETER OF TYPE INPUT IS NOT GETTING SAVED IN INPUT FOLDER.
		19675952	UNABLE TO SAVE MODELS AS THE INPUT PARAMETER VALUES CONTAIN SINGLE QUOTES
		20445414	JNDI CONNECTIONS ARE NOT BEING RELEASED
		20461217	UNABLE TO VIEW OUTPUTS FOR NAG BASED MODELS.
		20370100	STAGE FOLDER NOT CREATED ON VIEWING MODEL OUTPUTS FOR NAG MODELS
		20307619	TECHNIQUE NAMES SHOULD BE CHANGED FOR THE PRE PACKAGED R/ORE TECHNIQUES
		20242158	ERROR WHEN FTPING THE OUTPUT FILE AFTER MODEL EXECUTION
		20842972	RSERVE EXCEPTION DISPLAYED ON SAVING R MODELS
		20919953	MODEL OUTPUTS NOT DISPLAYED FOR R EXECUTION IN VIEW/COMPARE SAMPLE SCREEN
		20925963	REMOVE DEPENDENCY ON RSERVEENGINE& RENGINE JAR FOR LOCAL MODE R MODEL EXECUTION
		20895799	EXECUTION FOR EXTERNAL LIBRARY TECHNIQUE MODEL BASED ON PYTHON SCRIPT IS FAILING
		21269197	STANDARD R EXECUTION FAILING WITH STRING INDEX OUT OF RANGE EXCEPTION
		21356397	REMOTE R EXECUTION FROM ICC PASSING $HOST FAILS
		21292655	LOCAL MODE EXECUTION TRIGGERING REMOTE EXECUTION
		21169281	UNABLE TO SAVE PREDICTION MODELS
		21200419	EXECUTION FAILING FOR PREDICTION MODELS BASED ON R-ORE ENGINE
		21223811	SELF EXECUTABLE EXECUTION FAILING AS $RUNFILTERQUERY IS NOT REPLACED WITH VALUE
		21125618	TAGS IN MODELING EXECUTION CONFIGURATION FILES ARE MISSING.
		21120270	R/ORE ENGINE MODELS FAILING EVEN THOUGH LOG DISPLAYS SUCCESSFUL OUTPUT STORAGE
		21179709	MODEL EXECUTION HALTS DUE TO VARIABLE INITIALIZATION FAILURE
		21153536	MODEL EXECUTION USING STANDARD R ENGINE IS FAILING
		21236154	SCRIPT ERROR DISPLAYED ON CLICKING EXECUTE FOR EXTERNAL LIBRARY MODEL
		20160800	OUTPUTS GETTING DELETED FROM THE OUTPUT FOLDER ONCE VIEWED FROM OUTPUT SCREEN
	Variable	21264992	UNABLE TO CREATE VARIABLES DUE TO INVALID REQUEST ERROR DISPLAYED
		19633728	VAR: VARIABLE SELECTION BROWSER FOR TERM STRUCTURE DISPLAYS ALL SINGLE VARIABLES
	-	19694327	SUMMARY OF OUTPUTS TO BE SHOWN IN MODEL OUTPUT SCREEN FOR R SCRIPT BASED MODELS
		19711714	CHANGES IN SVN FOLDER STRUCTURE FOR AAAI AS AN APPLICATION
		20467674	MODEL EXECUTION FAILS FOR SSO ENABLED SETUP
		20253649	VARIABLES SELECTED IN A MODEL ARE NOT COMING IN PROPER ORDER DURING EXECUTION
		21103825	THE ORE BASED TECHNIQUES IS SHOWN AS R SCRIPT BASED WHEN USED FOR DEFINING MODEL
		21103845	ERROR WHILE UPDATING RESULTS BACK TO THE TABLE IN CASE OF ORE MODEL EXECUTIONS
		20401044	MODEL LEVEL FILTERS ARE NOT GETTING APPLIED FROM SANDBOX TO PROD
		21119860	NOT ABLE TO DELETE SANDBOX

Known Issues/ Limitations in This Release

· ORE model execution is not supported in RAC database.

· Open R execution does not support group and row level executions.

· Multiple datasets is not supported for models which get executed through ORE engine.

· Updating RDBMS table with respect to multiple datasets is not supported.

· Outputs from previous version models are not available for model chaining.

· NAG models does not support on the fly metadata creation, model versioning and run time filter.

· Execution of Models based on NAG Techniques are not supported on Solaris x86-84 due to non-availability of NAG libraries.

Oracle Financial Services Inline Processing Engine

New Features in This Release

Following is the list of features incorporated in this release. For detailed information on usage of these features, refer to OFS Inline Processing Engine User Guide 8.0.1.0.

· Scoring of Activities is supported in batch mode using Inline Processing Engine assessments.

· View/Edit of Expression lists the associated metadata such as Profiles, Virtual Profiles, Evaluations, and Assessments.

· IPE business model is integrated with datamodel repository; the registered datamodel objects are listed in the Inline Processing engine to perform Import Table.

· Assessments, Evaluations, Profiles, Filters, Expressions, and Entities are integrated in Metadata Browser Object view.

· Consolidated Scoring Output view is provided for IPE batches.

· Delete functionality is provided in Profiles, Virtual Profiles, Evaluations, Assessments, and Imported tables.

· Feature to synchronize the IPE business model with OFSAAI datamodel has been introduced.

· Ability to capture the snapshot of the inline processing objects while the Inline processing batches are processed has been introduced.

List of Bugs Fixed in This Release

Component	Sub Component	Bug No	Subject
Inline Processing	Inline Processing Engine	21341075	FORMATION OF INCORRECT ASSESSMENT QUERY FOR VIRTUAL PROFILE
	-	21286679	MULTIPLE PROCESSING SEGMENTS MAPPED TO SAME ENTITY IS REPLACED WHEN IMPORT XML IS TAKEN
		21271461	SAVE OF HIGHER LEVEL METADATA SHOULD NOT IMPACT THE LOWER LEVEL METADATA
		21215336	RTI_FILTER TABLE IS NOT TRUNCATED INSPITE OF DELETING EVALUATIONS,PROFILE,EXPRESSION
		20887006	PROFILES ARE BEING DELETED FROM EXPRESSIONS
		21200975	THE RTI_ENTITY_TYPE DOES NOT HAVE ENTRIES FOR THE INFODOMS CREATED
	Inline Processing Web	21073672	IPE CACHE ENABLED OPTION DELAYING UI UPDATE RESPONSE

Known Issues/ Limitations in This Release

· Metadata Browser's Application view is not supported for Inline Processing Engine application and its objects. (ID 21459492 )

· Export to PDF is not supported for Inline Processing Engine objects. (ID 21340421)

· Multiple objects deletion is not supported. (ID 21262808)