Description
OFS PFT Application Pack v8.0.0.0.0 Minor Release #1 8.0.1.0.0 (ID 21031791)
This release of OFS PFT 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 PFT Application Pack v8.0.0.0.0.
How to Apply This Release?
For detailed instructions on installing this OFS PFT Release, please refer to Oracle Financial Services Profitability Management Application Pack Installation Guide 8.0.1.0.0.
Starting with the version 8.0.0.0.0 release, OFSAA applications are packaged and released as Application Packs. The OFS Profitability Management Application Pack includes OFS AAI, OFS PFT, OFS FTP, OFS IPA, OFS RPA, and OFS EFPA. Refer to the subsequent sections for more details.
· Oracle Financial Services Analytical Applications Infrastructure
· Oracle Financial Services Funds Transfer Pricing
· Oracle Financial Services Profitability Management
· Oracle Financial Services Institutional Performance Analytics
· Oracle Financial Services Retail Performance Analytics
· Oracle Financial Services Enterprise Financial Performance Analytics
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
Following is the list of new features incorporated in this release.
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 folders are not displayed. |
|
Technical Metadata Management |
21229361 |
Table Logical name is empty for Data File Mapping screen. |
|
21201150 |
Show Details/ Data Preview should be available under selected Members tree. |
||
21420020 |
Saving Data Mapping definition
takes long time if an entity containing many attributes (>100 columns) is
selected as Source entity. |
||
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 Funds Transfer Pricing
This section includes the following sub-sections:
· New Features in This Release
· List of Bugs Fixed in This Release
Following is the list of features incorporated in this release.
·
Change in sequence of the calculation line items: The Calculation elements in the TP Process
have been re-ordered to reflect the logical processing sequence as performed by
the engine
·
Option
Cost Calculation should automatically update the OPTION_COST field: The
OPTION_COST column is now automatically updated by the Stochastic TP Process,
and is equal to Historic OAS – Historic Static Spread
·
Add
Skip Non Zero option to the Propagate line in TP Process: Users can now have the option to skip
non-zero records during propagation
·
Provide
option to migrate Breakage Charges to Ledger table: Users now have the option
in the TP Process to migrate Breakage Charge results to the Ledger table
·
Break
Identification Performance Enhancements: Users can now manage performance of
the Break Identification process by providing database hints via the
FSI_PARALLEL_PARAMETERS table
·
Enhance
FTP Rate Card report to show all TP Rate outputs: The FTP Rate Card report has
been expanded reformatted to better display standard FTP rate results.
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug No |
Subject |
Calculation
Engine |
21435251 |
Incorrect TP method use when Conditional Assumption
is defined on more than one product and currency combination |
|
Other |
21146118 |
Forward port for bug 21027269 - OFSTP fails with
'syntax error at line 1' after |
|
21095658 |
Forward port for bug 21095642 - FTP Web Services is
crashing Tomcat server rando |
||
20812903 |
When an FTP process runs with a Transfer Pricing Rule
using the Straight Term method, process is using the wrong term on the
Interest Rate Curve (IRC). (20687924 ) |
||
20292448 |
All-in rate calculation is not aggregating all
selected elements |
||
20234515 |
FTP process ignores data filter when tractor method
is used |
||
|
19347046 |
EV calculation is incorrectly adding "interest
rate spread" to TP rate |
|
Calculation Engine Int Error |
|
18959203 |
Account type not defined for leaf errors for node level
TP assumptions |
Option Adjusted Cost |
|
20601478 |
Migration of option cost is happening with reversed
signage |
Performance issues |
|
18245095 |
Tractor method is not operating correctly with
multi-processing enabled |
Adjustments Calculations |
|
21042499 |
Adjustment propagation + charge/credit calculation is ending w/
"failed" status |
Breakage Charge |
20098590 |
Signage is wrong for economic loss - partial and
change in attributes |
Known Issues/ Limitations in This Release
None
Oracle Financial Services Profitability Management
This section includes the following sub-sections:
· New Features in This Release
· List of Bugs Fixed in This Release
Following is the list of features incorporated in this release.
· Lookup allocation for Management Ledger
· Aggregate amounts for Management Ledger
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug No |
Subject |
Engine for
Allocations |
21498795 |
Forward port : Parallel DML not specified in table
or improper entry in table errors |
|
21126842 |
Circular allocation model fails before launching
Sweep allocation |
||
Allocation Entries |
21461715 |
Error - ORA-00904:
"A"."ID_NUMBER": invalid identifier |
|
21119978 |
Forward port for bug 19996688 - Data filters not applied
to some SELECT statements |
||
Engine |
21119876 |
Forward port for bug 21096529 - ORA-00918 on
transaction table dynamic driver allocation |
|
20561078 |
Use detail leaves account type in FE element dimension
member not working on management ledger |
Known Issues/ Limitations in This Release
None
Oracle Financial Services Institutional Performance Analytics
This section includes the following sub-sections:
· New Features in This Release
· List of Bugs Fixed in This Release
Following is the list of features incorporated in this release.
·
Additional Reports in Customer Central and Graphical Representation of
Customer Group Structure.
·
What-if Analysis – Supports the ‘Advanced’ methodology for of applying
variations and analyzing the effect in a scenario. Variations can also be
applied through graphical representation.
·
Point in Time Reporting – The reports can be viewed at any historical
data and the data represented in the report will be pertaining to the specified
date.
·
Representation of Customer Income Statement in a Standalone as well as Consolidated
format.
·
Multiple Segmentation types – Multiple segmentation types are supported,
with each segmentation type being defined on a different set of dimensions.
· Enhanced RM Visibility – The visibility of an RM could be configured to provide him the visibility of his parent and child members.
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug No |
Subject |
RPD |
21134632 |
Customer central - Total size of
relationship mapped to N_CUST_CNR |
|
21040801 |
IPA - Summary - Product Penetration
report - Numbers are wrong |
||
20776845 |
Slow performance OBIEE customer
hierarchy |
||
20691787 |
Recommended approach for the
calculation of report line 98500: Tax Expense |
||
20583890 |
SQL performance issue in OBIEE/IPA
reporting |
||
19854116 |
Customer hierarchy parents must
always be reported with children |
||
OTHER |
21142496 |
IPA -Customer central - Customer
group structure |
|
20328837 |
Expose columns V_SALES_REP_ID,D_CALENDAR_DATE,V_FUND_CLASS
TO IPA RPD |
||
19804239 |
Descriptions mapping are missing for
level1, level2 and level3 FOPR PRODUCT SCD |
||
META |
21097115 |
Issue with top 10 current quarter
opportunities- current period report |
|
19972742 |
T2tT mappings from stage mutual funds
to fact common account summary |
||
19434815 |
Defaulting logic for transactions
summary table |
||
19434484 |
Issue with length of N_MANAGER_SKEY
of DIM_MANAGEMENT table |
||
19125126 |
Defaulting logic for dimensions in
T2T -product team |
||
DATA_MODEL |
|
20383498 |
Want to change OOTB T2T
forT2T_ACCOUNT_MANAGERS_REL |
|
20356475 |
Partner code is not exposed to OOB
OBIEE reports |
|
|
20302928 |
Physical foreign key missing in DIM_DEALER
and DIM_SALES_REPRESENTATIVE |
|
|
19972664 |
SCD mapping for DIM partner , DIM
dealer and DIM sales rep dimension tables |
|
|
19972632 |
Reference of dim dealer code/id needs
to be added to mutual funds & common accounts |
|
|
19972527 |
Stage dealer master and dim dealer
need to be added as part of IPA |
|
|
19811629 |
IPA implementation -
V_ACCOUNT_MGR_LOCATION missing in DIM_MANAGEMENT SCD CONFIG |
Known Issues/ Limitations in This Release
Known Issues:
Component |
Sub Component |
Bug No |
Subject |
|
21838951 |
The web service does not returns only the reference
number |
|
|
21499634 |
Missing mappings for columns in
FCT_PFT_CUSTOMER_SUMMARY table. |
|
|
21231306 |
The IPA model execution is failing |
|
|
21865952 |
Cubes not working -IPA Note: It fails ONLY when
the same value exists for 2 leafs of the same parent. |
Limitations:
Component |
Sub Component |
Bug No |
Subject |
RPD |
|
21784312 |
Transfer pricing credit/charge should be in
percentage form. |
SCRIPTS |
|
21753056 |
-VE variations are currently not allowed in what-if -
IPA |
Oracle Financial Services Retail Performance Analytics
This section includes the following sub-sections:
· New Features in This Release
· List of Bugs Fixed in This Release
Following is the list of features incorporated in this release.
·
Additional Reports in Customer Central.
·
What-if Analysis – Supports the ‘Advanced’ methodology for of applying
variations and analyzing the effect in a scenario. Variations can also be
applied through graphical representation.
·
Point in Time Reporting – The reports can be viewed at any historical
data and the data represented in the report will be pertaining to the specified
date.
·
Multiple Segmentation types – Multiple segmentation types are supported,
with each segmentation type being defined on a different set of dimensions.
·
Enhanced RM Visibility – The visibility of an RM could be configured to
provide him the visibility of his parent and child members.
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug No |
Subject |
RPD |
21230683 |
RPA - Customer central reports -report title has "albertson alta dena industrie |
|
DATA_MODEL |
20955826 |
Batch REPLINE_DIMENSION_UPDATE is not populating the data into
DIM_REP_LINE |
|
META |
20873560 |
T2T_FCT_APPLICATION having inner join with customer dimension |
Known Issues/ Limitations in This Release
Known Issues:
Sub Component |
Bug No |
Subject |
|
WEBCAT |
|
21752649 |
Issue with calculations in summary of balance (receivables)
breakdown |
OTHER |
|
21865969 |
RPA cubes not working Note: It fails ONLY when
the same value exists for 2 leafs of the same parent. |
RPD |
|
21790952 |
RPA/IPA: Variation specification rows are not
available |
Limitations:
Component |
Sub Component |
Bug No |
Subject |
WEBCAT |
|
21753049 |
-VE variations are currently not allowed in WHAT-IF -
RPA |
Oracle Financial Services Enterprise Financial Performance Analytics
This section includes the following sub-sections:
· New Features in This Release
· List of Bugs Fixed in This Release
Following is the list of features incorporated in this release.
·
What-if Analysis – Supports the ‘Advanced’ methodology for of applying
variations and analyzing the effect in a scenario. Variations can also be
applied through graphical representation.
·
Multi-currency Reporting – Enables to represent the reports in multiple
currencies.
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug No |
Subject |
META |
21091891 |
FN_MGMT_REP_MGMT_LEDGER batch
fails with ORA-00942 and ORA-01747 errors |
|
20951780 |
SCD generating multiple
keys for default members for all dimensions |
||
20898286 |
Interest Expense and TP
charge included in net interest revenue |
||
20772476 |
ORA-00904: "DIM_ORG_STRUCTURE"."N_ENTITY_ID"
error running T2T_FCT_LEDGER_STAT |
||
SCRIPTS |
20197671 |
LEDGER_STAT_TRM
transformation ignores PSOURCE_TYPE PARAMETER |
Known Issues/ Limitations in This Release
Known Issues:
Component |
Sub Component |
Bug No |
Subject |
RPD |
|
21620046 |
EFPA
cubes: Cubes are failing for mgt and financial reporting Note: It
fails ONLY when the same value exists for 2 leafs of the same parent. |
META |
|
21319305 |
Unable to
resave the hierarchy " HEPMGLFR" |
Limitations:
None