Description
OFS
AAAI Application Pack v8.0.0.0.0 Minor Release #6 8.0.6.0.0 (ID 23036940)
This
release of OFS AAAI Application Pack is cumulative of all enhancements and bug
fixes done since v8.0.0.0.0
release.
Note: The compatibility
patch 28033582 is available in My Oracle Support, which needs to be
mandatorily applied as a post installation step. This patch enables you to
upgrade selected packs in your OFSAA instance to 8.0.6.0.0 and makes the
existing packs from earlier versions compatible with 8.0.6.0.0. For
instructions, see OFS
AAAI Application Pack Installation and Configuration Guide 8.0.6.0.0.
Additional Licensing Information
To use the Distributed AM Processing feature, explained in the Distributed Activation Manager (AM) Based Processing section of the OFS Analytical Applications Infrastructure Administration Guide, additional licenses may apply.
For details, contact My Oracle Support.
Prerequisites
·
The minimum
patch set level should be OFS AAAI Application Pack v8.0.2.0.0.
How to Apply This Release?
For
detailed instructions on installing this OFS AAAI Release, see OFS
AAAI Application Pack Installation and Configuration Guide 8.0.6.0.0.
Starting 8.0.0.0.0 release, OFSAA applications are packaged and released as Application Packs. OFS AAAI Application Pack includes Financial Services Analytical Applications Infrastructure, Financial Services Big Data Processing, Financial Services Enterprise Modeling, and Financial Services Inline Processing Engine. Refer to the subsequent sections for more details.
· Oracle Financial Services Analytical Applications Infrastructure
· Oracle Financial Services Big Data Processing
· 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
· Features De-supported/Deprecated in This Release
Following is the list of new features incorporated in this release. For detailed information on usage of these features, see OFS Analytical Applications Infrastructure User Guide 8.0.6.0.0.
1. Data Security and Data Privacy
OFSAA is enhanced with the following features to adhere to Regulations and Privacy Policies with respect to Data Security:
· Transparent Data Encryption (TDE) –TDE is used for encryption at Rest. TDE enables you to encrypt sensitive data, such as Personally Identifiable Information (PII), that you store in tables and tablespaces.
· Data Redaction –Enabling Data Redaction allows you to disguise sensitive data such as Personally Identifiable Information (PII) that your application is accessing in real time.
· File Encryption – User can opt for encryption of the data files used in Data Mapping definitions. A stand-alone File Encryption utility is provided to encrypt and decrypt the Data files.
· Logging - Log format is standardized and can be read by any standard log analysis tool.
For more information on how to enable the above security features, see OFS AAI Administration Guide 8.0.6.0.0.
2. Alta Theme adoption
· Alta theming is adapted across OFSAA screens to provide sharper User Interface (UI) and usability to enhance user experience.
3. OFSAA Landing Page
· OFSAA Landing page shows the available Applications for which a user has access as tiles menu. Tiled view of applications depends on user access to the respective applications.
4. Model Upload
· Support for Oracle Partitioning such as Range Partitions, List Partitions and Hash Partitions for Model Upload using Erwin is introduced.
5. Data Management Tool (DMT)
As part of this release, Data Management Tools User Interface is re-organized and OJET/ALTA theme is adapted for better usability. All metadata in DMT is now persisted in Database instead of XML files.
· DMT definitions are moved from erstwhile XML files to database. DMT Migration utility is provided to migrate metadata for metadata types such as Table based Data Sources, Data Mapping, Data File Mapping, Post Load Changes (DT) and DMT properties XMLs (ETLLoader.properties and Cluster.XML). For more information on DMT Migration utility, see Command Line Utility for DMT Migration section in OFS Analytical Applications Infrastructure User Guide 8.0.6.0.0.
· DMT UI is enhanced to have Summary and Detailed view, with all other standard features like Search/Add/Edit/View/Copy/Delete.
· User Interface is introduced for the DMT Configurations.
· All DMT metadata is Infodom specific.
· Versioning of metadata is supported. Users can use ‘Make Latest’ feature to make any version active.
· Source creation now implicitly does a source model generation. Defining the structure of a Flat File is now mandatory during the creation of Flat File based sources.
· Data Mapping and Data File Mapping screens are now merged.
· An existing OFSAAI Infodom can be used as a Source in the Data Mapping screen.
· Data mapping can also be defined on the UMM Datasets.
· Data Mapping (T2T) and PLC execution can be configured to run in JAVA engine.
6. Operations
· Batch Monitor UI is enhanced to launch specific execution logs against each task
· Batch Framework to provide automated email notification on batch failure
7. Run Rule Framework
· Run executable component is enhanced to optionally pass RRF execution parameters such as $RUNID, $PHID, $EXEID, and $RUNSK to underlying executable shell script abstraction based on flag set as RRFOPT=Y or rrfopt=y.
· Run Framework supports Enterprise RUN, where multiple Information Domain metadata can be stitched together and executed accordingly.
8. Administration
· New Task Execution Log Viewer is introduced. You can download the log file in PDF or Excel format.
9. Business Metadata Management
· OJET/ALTA theme has been adapted for designing User Interface for better usability for Alias, Datasets, Essbase, and Measures.
· Essabase Cube has Summary and Detailed view, with all standard features like Search/Add/Edit/View/Copy/Delete.
· Metadata Resave utility is enhanced to support resave of Essbase Cubes.
· View mapping functionality added in Mapper definitions. It provides information about existing mapping to aide adding new mappings.
· Metadata Browser (MDB) Publish
· For hierarchy, lineage extended to distinguish between entities, alias and derived entities
· For Business processor, lineage extended to show dependency based on the expression of the definition
· Enhanced search capability in hierarchy browser with tree based search results for better usability
10. Process
Modelling Framework
· Process Flow designer is enhanced for better UI experience (Mobile first or Persona design philosophy)
· Support for asynchronous and synchronous paths within a process model
· Place holders for static values in attribute expression
· Straight transition line support with additional dotted and dash options in UI
· Introduction of two additional application rules - Advanced Attribute Expression and JSON Path Expression
· Dynamic creation & launching of form to capture drivers/parameters/data-entry for manual activity/task in a process-model (as execution is tracked thru the Process-Monitor)
· REST URL with proxy support as part of Webservices rule
· Support for seeded task-types in PMF – T2T, DT, Run, Type2 Rule, Type3 Rule & Model
· Interface spec to add custom tasks (fully typed with metadata, data/parameters interchange via JSON)
11. Object Migration
· UI based Offline Object Migration is introduced.
· Separate links for Export and Import functionalities
· Summary page lists out existing Export and Import definitions
· Available Objects in the Infodom are displayed as tree based widgets for selecting in the Export and Import Definitions
· Export and Import Definitions can be triggered for migrating objects from the Summary pages
12. Logging
· Audit Logging- Enables audit logging for all operations performed on Platform Objects.
· Execution Logging- Unified location to view all execution logs
· Application Logging- System log format has been standardized. Log file path is changed now.
For more information, see Logging section in OFS AAI Administration Guide 8.0.6.0.0.
13. Security Management System
· Audit reports is enhanced with additional attributes and granularity.
14. Technical Updates
· SAML v3.0 support
·
CMIS
(Content Management Interoperability Standard) adoption
List of Bugs Fixed in This Release
|
Component |
Sub Component |
Bug No |
Subject |
|
Dimension
Management |
Hierarchy |
18673707 |
SEARCH
IN HIERARCHY DOES NOT PROVIDE RELATED BRANCHES IN SEARCH RESULTS (FOCUS) |
|
27842676 |
REV_HIER_FLATTENED
USE & AS DELIMITER CAUSING BATCH HIERARCHY LOAD OVERLOAD |
||
|
Filter |
Filter
Data Element |
27575154 |
CANNOT
CREATE FILTERS WHILE USING CHROME BROWSER |
|
- |
27589021 |
SORT
IDENTITY CODE VALUES IN DATA FILTER DEFINITION SCREEN ALPHABETICALLY |
|
|
Unified
Metadata Manager |
Technical
Metadata Management |
18808928 |
F2T
CREATES CONTROL FILE IN COLUMN NAME ORDER INSTEAD OF DESIGNATED FIELD ORDER |
|
19830333 |
THRESHOLD
PERCENTAGE IN T2T SHOULD NOT ACCEPT VALUE >100 |
||
|
Business
Metadata Management |
27512888 |
UNABLE
TO CREATE/EDIT A REGULAR NON BI HIERARCHY |
|
|
21759551 |
RRDF
- DE CREATION DOES NOT CONVERT MAXIMUM TO MAX USED IN MEASURES |
||
|
14123159 |
METADATA
DEPENDENCY VALIDATION REQUIRED IN DATASET FOR RRF -BMM |
||
|
27512888 |
UNABLE
TO CREATE/EDIT A REGULAR NON BI HIERARCHY |
||
|
22616380 |
MDB
PUBLISH FOR HIERARCHY SHOULD DISTINGUISH BETWEEN ENTITY AND DERIVED ENTITY |
||
|
27522596 |
MAPPING
DETAILS NOT SHOWING WHEN THE NODES CONTAIN SINGLE QUOTE OR SQL KEYWORDS |
||
|
Metadata
Browser |
27167251 |
UNIQUE
CONSTRAINT ERROR IN LOG AFTER PUBLISHING METADATA |
|
|
Other |
- |
25370382 |
OFSAA
803 : NUMERIC ATTRIBUTE LIMITATION IN AMHM SCREEN |
|
Rules
Framework |
- |
27714288
|
RULE
EXECUTION FAILING WHEN DATASET ANSI JOIN HAS MORE THAN 4000 CHARS |
|
System Configuration |
- |
26499522 |
APPLICATION
SCREEN NOT OPENING IN TOMCAT 8.5.X WEB SERVER |
|
ABC |
Questionnaire |
27822459 |
INBOX
SCREEN DOES NOT LOAD (MY TASK) |
|
27642462 |
SWITCH
FROM STATIC TO DYNAMIC WITHOUT SAVING QUESTION GIVES ALERT WHILE SAVING |
||
|
27636885 |
ACTION
BUTTONS SUBMIT,SAVE DRAFT AND CLOSE DISAPPEARS AFTER SAVING THE QTNAIRE |
||
|
27474132 |
NOT
ABLE TO CREATE QUESTION/QUESTIONNAIRE |
||
|
27405188 |
QUESTIONNAIRE
SCREEN DOES NOT HAVE ADD BUTTON & CREATE QSN SCREEN DOES NOT OPEN |
||
|
27404733 |
NOT
ABLE TO ANSWER DISPLAY AS NUMBER QUESTION |
||
|
24800193 |
REVIEW
OF QUESTIONNAIRE IS NOT WORKING |
Features De-supported/Deprecated in This Release
Following features are de-supported from this release:
· Metadata Archive/restore functionality
· Oracle OLAP Cubes
· Catalog
Known Issues/Limitations in This Release
· T2T Java engine does not support Data Mapping definitions with transformations
· Loading of Entities in the Source Entity Selection window in File based Data Source creation and Data Mapping T2F extraction takes more time than expected
· No validation provided for missing Field Orders in File based Data Source creation and Data Mapping T2F extraction
· T2T Java engine execution does not display Event Logs in Batch Monitor
· Pressing the F12 function key opens the browser debugger tools window (only on Firefox browser).
Oracle Financial Services Big Data Processing
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 OFS
Analytical Applications Infrastructure User Guide 8.0.6.0.0.
· Support for Hive File-Formats such as Text, Sequence, RC, Avro, Parquet and ORC is introduced. HIVE_INPUT_FILE_FORMAT and HIVE_OUTPUT_FILE_FORMAT can be configured at three levels: OFSAA Instance Level Configuration, Model Level UDPs and Table Level UDPs
· User Interface for Cluster information is introduced.
· Heterogeneous Support for SCD to RDBMS is introduced where after SCD execution on Hive Information Domain, the data from Hive DIM table will be updated back to the RDBMS DIM table.
List of Bugs Fixed in This Release
|
Component |
Sub Component |
Bug No |
Subject |
|
Unified
Metadata Manager |
Technical
Metadata Management |
23738591 |
H2H
(OLD) ENGINE IS FAILING TO FETCH THE PARAMETERS PASSED DURING FIRE RUN |
|
25358599 |
H2T
FAILING FOR DATATYPE - DATE TIME IN SQOOP MODE |
Known Issues/Limitations in This Release
· Sqoop logs in client mode does not capture any data
· Dynamic Table creation during Data Mapping definition is failing
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.6.0.0.
· Support for Model definition using Derived Entities
· Support for ORE 1.5.1
· Migrated metadata from Modeling Framework XML to database.
· A new UI is provided for configuring model execution venues
· Migrating metadata of Variables from XMLs to database. Variable Migration utility is provided to migrate variables defined in previous versions to make it compatible with Variable definition in 8.0.6.0.0.
Features De-supported/Deprecated from This Release
Following features are de-supported from this release:
· NAG
· Variable classifications and dummy variables
· Variable shock definition
· Scenario file upload
· Scenario definition
· Technique Registration using External Library
· Logical Sandbox
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.6.0.0.
· Highlights are created without appending filters by default. To add filters by default, a parameter OFS_OFS_IPE_ADDHIGHLIGHTSFILTERS is introduced in the configuration table.
· Generating Highlights when evaluation score is zero for a Real Time process is introduced.
· Copy feature for Evaluation is introduced.
Known Issues/Limitations in This Release
· Generating Highlights when evaluation score is zero for batch processing is failing
· When you copy Evaluation, the non-mandatory fields are not getting copied