Bug 24741584 - Oracle Financial Services CAP Application Pack v8.0.0.0.0 Minor Release #3 (8.0.3.0.0)
This release of OFS CAP Application Pack is cumulative of all enhancements and bug fixes done since v8.0.2.0.0 release.
The minimum patch set level should be OFS CAP Application Pack v8.0.0.0.0.
For detailed
instructions on installing this OFS CAP Release, refer to CAP Installation and Configuration Guide 8.0.3.0.0 in OTN
Documentation Library.
Post Installation Note:
After
successfully installing 8.0.3.0.0, please run the RLBL6022_0.sql
script:
1. Open the RLBL6022_0.sql file
and replace the following placeholders:
##INFODOM## - Infodom name of the BASEL Application Instance.
##USER## -
Application User Name used to login to the application (for example: SYSADMN,
CAPUSER, and so on).
##INDIA_SEG## -
Segment Code for India (Same as folder name as shown against the Rule in RRF
screen).
2. Stop OFSAA Application
Services.
3. Log in to CONFIG schema of
the Application Instance in the database server.
4. Execute the contents (SQL statements) in the database and COMMIT the changes.
Note: This step can vary depending on how the
SQL scripts are executed, via Windows, Linux, or any other method.
5. Start OFSAA Application
Services.
Note: Starting 8.0.0.0.0 release, OFSAA applications are packaged and released as Application Packs.
Oracle Financial Services Capital Adequacy Pack Applications
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. For detailed information on usage of these features, refer to the 8.0.3.0.0 User Guides of OFS CAP applications from OTN Documentation Library.
Enhancements
in Basel Applications
Indian Jurisdiction (RBI)
In
the OFS Basel Regulatory Capital Release 8.0.3.0.0, the changes brought about
by “Master Circular – Basel III Capital Regulations,
DBR.No.BP.BC.1/21.06.201/2015-16” (hereinafter named as the RBI Basel III final
rules) issued by the Reserve Bank of India and published in July, 2015 are
introduced. These changes are introduced in the Basel solution on top of the
existing July 2013 regulations and also take into account all circulars issued
till 2015 end in this regard.
The
following enhancements have been introduced in this release to cater to Basel
III regulation for India jurisdiction:
·
Capital
Calculations
o
Transitional arrangement related changes to Capital
Conservation buffer
o
Treatment of Equity Investment in non-financial and
insurance subsidiaries
o
Treatment of Intra Group transactions
o
Eligibility of Quarterly Profit in CET1 Capital
·
Standardized
Approach
o
Risk weighting of deduction exposures as 1250%, instead of
1111%
o
Treatment for exposures to Export Credit Guarantee
Corporation
o
Treatment for exposures to foreign central bank
o
Treatment of SDR exposures
o
Incurred CVA calculations
·
Securitization
exposures treatment as per Standardized approach
o
Risk weighting of deduction exposures as 1250%, instead of
1111%
·
Market
Risk Capital Calculations
o
Capital Charge calculation as 12.5 instead of 11.11
o
Position Conversion and treatment of Hybrid Instruments
·
Changes
in Mitigant Eligibility criteria under Credit Risk Mitigation
Europe Jurisdiction (EU)
The
European Banking Association (EBA) in conjunction with the European Council and
the European Parliament has issued the CRD IV and CRR IV rule which encompasses
the entire Regulations to be followed by the Banks. These regulations are by
and large compliant with the Basel III changes issued by the Basel Committee (BIS).
The
OFS Financial Services Basel Regulatory Capital 8.0.3 Release has the Capital
Requirements Regulation IV (CRR IV) issued by the European Union on 26th June
2013, incorporated in it.
The
following enhancements have been introduced in this release to cater to CRR IV
regulation for European Union jurisdiction:
·
Non-Securitization
Exposures – Standardized Approach
·
Counterparty
Credit Risk Exposures – Original Exposure Method, Mark to Market Method, and
Internal Model Method
·
Settlement
Risk Exposures – Standardized Approach
·
Credit
Valuation Adjustment – Standardized Approach and Alternative Approach
·
Default
Fund Contribution – Qualified Central Counterparty and Non Qualified Central
Counterparty
·
Large
Exposure Treatment for Banking book
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug ID |
Subject/Description |
Other
Jurisdiction |
– |
21268270 |
EU - CRD
- BASEL III - CONSOLIDATION |
Other
Jurisdiction |
– |
21268283 |
EU - CRD
- BASEL III - STANDARDISED APPROACH-CR |
Other
Jurisdiction |
– |
21268288 |
EU - CRD
- BASEL III - MULTIPLE ASSESSMENT |
Other
Jurisdiction |
– |
21268308 |
EU - CRD
- BASEL III - COUNTERPARTY CREDIT RISK |
Other
Jurisdiction |
– |
21268307 |
EU - CRD
- BASEL III - CLEARED TRANSACTIONS |
Other
Jurisdiction |
– |
21268314 |
EU - CRD
- BASEL III - CREDIT RISK MITIGATION |
Other
Jurisdiction |
– |
21268297 |
EU - CRD
- BASEL III - CREDIT VALUATION ADJUSTMENT |
Other
Jurisdiction |
– |
21268304 |
EU - CRD
- BASEL III - LARGE EXPOSURES |
Data
Model |
24338927 |
COLUMN
LENGTH MISMATCH FOR V_ISSUE_ID IN FCT_REFERENCE_ISSUE, STG WITH DIM TABLE |
|
INDIA -
RBI Regulations |
– |
24436785 |
UFCE
RISK WEIGHT INCREASE REQUIRED ONLY FOR THE CASES WHERE UFCE AMOUNT IS NOT
NULL |
Metadata
Configuration |
RULESFW |
23638077 |
SHORT
TERM RATING OF ASSET CLASS- PRIMARY DEALERS & DOMESTIC PSE IS
NOT CORRECTLY ASSIGNED |
Data
Population |
– |
23598490 |
SINGLE-ROW
SUBQUERY RETURNS MORE THAN ONE ROW |
Metadata
Configuration |
– |
23567871 |
SINGLE
REQUEST BATCH EXECUTION FOR TWO QUARTERS RULE RLBL0324 FAILED |
Engines/Backend
Components |
– |
23256926 |
IRB
CAPITAL CHARGE CALCULATION RULE FOR SECURITISATION PORTFOLIO MAPPED IN INDIA |
Metadata
Configuration |
– |
23217233 |
DQ CHECK
RULES STATUS ISSUE |
Data
Population |
– |
23080358 |
CARDS_EXPOSURE_DATA_CREATION
LOADING ISSUE ON PRODUCT SET UP |
Data
Model |
– |
23615877 |
COLUMN
LENGTH OF V_STD_ACCT_HEAD_ID IN FSI_SETUP_CAPITAL_HEAD IS INCORRECT |
Metadata
Configuration |
LOADEXT |
23631817 |
T2T
MAPPINGS REQUIRED FOR FSI_PLACED_COLLATERAL |
Documentation
Issues |
– |
21973526 |
ATTRIBUTES
FOR BASEL_III_INDIA_NON_SEC_STD MISSING FROM DOWNLOAD SPECIFICATIONS FILE |
Known Limitations in this Release
QA certification on functional verification for Default Fund Contribution / Credit Valuation Adjustment treatments of EU package contents of this release is in progress.
Known Issues in this Release
Component |
Sub Component |
Bug ID |
Subject/Description |
Metadata
Configuration |
– |
24734124 |
EU - CRD
– ERROR IN RESAVING HIERARCHIES H8028 AND HBL6007 |
Non-Securitization |
– |
24574268 |
EU - CRD
– LARGE EXPOSURES - TO CONSIDER ADDITIONAL EXPOSURES |
Oracle Financial Services Analytical Applications Infrastructure Application Pack
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
Following
is the list of new features incorporated in this release. For detailed
information on usage of these features, refer to OFSAAI 8.0.3.0.0 User Guide.
1. Model Upload
Naming
Convention of constraints (PK and FK) has been changed to resolve the following
issues:
·
For tables with similar names which are
relatively long (>27 characters) where initial few characters differ (for
example, STG_COMMON_ACCOUNT_SUMMARY, FCT_COMMON_ACCOUNT_SUMMARY), the
constraint names get generated as same causing an Oracle error of duplicate
constraints.
· When number of foreign keys for a table is more than 100, the length of the constraint name exceeds the permissible limits allowed by Oracle Database.
Update Constraints utility (23251358) is introduced to alter the existing constraint name references according to the new convention. A unique ID gets generated for each data model entities. The new constraint name will be generated by appending the unique ID with ‘FK’ or ’PK’ (along with a sequence for FK). For example PK on DIM_ACCOUNT will be formed as PK_101, where 101 is the unique ID of DIM_ACCOUNT. Similarly, FKs on FCT_ACCOUNT_SUMMARY will be FK_206_01, FK_206_02, FK_206_03, and FK_206_04, where 206 is the unique ID of FCT_ACCOUNT_SUMMARY and the table has 4 FKs.
For more
information, see OFS AAAI Application Pack Installation and
Configuration Guide_8.0.3.0.0.
2.
Process Modelling Framework
·
Supports asynchronous invocation of workflow.
·
Supports setting reminder for a task.
·
Supports setting expiry date for a task.
·
Supports escalation of tasks.
·
Supports delegation of task to peers or
subordinates.
·
Parallel gateway is introduced, which can be
used to execute multiple transitions in parallel.
·
Multi Choice gateway is introduced, which can be
used to execute multiple transitions/flows based on a decision rule.
·
Supports Committee approval/Group Consensus that
can be used to decide whether the flow has to move to a particular activity based
on the response of a single member, majority of members of the group, or all
members of the group. If more than one group is present, then you can design to
move the flow to a particular activity based on the response of a single group,
all groups or the majority of groups.
3.
Data Quality Framework
OFSAAI
is provided with a comprehensive business semantic rich and FSI domain centric
Data Quality Rule Type called Control Total Check. This type of quality check
allows configuration of entity-attributes (multiple ones) checked against a
reference entity with its set of attributes. Both LHS (subject entity)
and RHS (reference entity) permit tagging aggregate functions to attributes,
adding dimension-filters to the where-clause and supporting group-by predicates.
4. Business Metadata Management
UAM Hierarchy resave utility (runit.sh) is enhanced
with an additional option to save the hierarchies in synchronous manner.
5.
Run Rule Framework
Run
definition supports selection of AMHM filter as Run condition and/or Job
condition.
6.
System Configuration and Identity Management
·
Supports configuration of OFSAAA with multiple
LDAP directories.
·
FTPSHARE DB and APP server screen now accepts
special characters for password.
·
OFSAA is enhanced to act as service provider for
SAML integration.
7.
Forms Framework
·
Supports collapsing of Rich Text Control editor
·
Toggle button is introduced
·
Supports events for Rich Text Control
·
Supports yen special character in UI
·
Supports reuse of Grid / Child form
·
Customization for displaying basic Rich Text
Control is introduced
·
Multi Select Control now supports Focus event
·
Supports either Single Select or Multi Select
Control based on the corresponding column value of the grid
·
Supports configurable Search fields in Hierarchy
Control
·
Hourglass / Progress bar is introduced to show
the duration of document upload
·
Supports Hierarchy Control Search functionality
for non-list custom hierarchy
·
Displays an alert message if exporting records
crosses a specified limit
·
Hierarchy Control is enhanced not to accept a
root node
·
Supports configuring expansion level for custom
Hierarchies
·
Configuration parameter is introduced for not
displaying UI search in Hierarchy Control window
·
Supports assigning values to Label Control
·
Supports partial save of forms by highlighting the
mandatory fields
·
Difference Container supports KBD Control
·
Ability to define and maintain Applications
which is a set of Pages grouped together
·
Single screen view for all the components within
a Page
·
Enhanced the following from Page perspective:
o
Blocks (Frames)
o
Forms
o
Containers
o
Controls
o
Validation Rules
o
Actions (Buttons)
o
Processing Rules
o
Masking
o
Control Reorder
·
Introduced Controls as Non-Action, Action and
Advanced
·
Supports invoking a Page from Menu and Tab
·
Introduced Application Administration for
maintaining the Application
·
Supports generation of Pages individually
·
Supports creation of Pages from existing Custom
Layouts
· Introduced Supported Objects in Template frames like Form, Tab, Custom JSP and Report
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug ID |
Subject |
Unified Metadata Manager |
Business Metadata Management |
22517322 |
SUPPORT FOR PLACEHOLDERS BASED DATASET IN BUSINESS
PROCESSORS |
24285674 |
DEFAULT HIERARCHY FOR USER GROUP MAP IS NOT AVAILABLE |
||
22828608 |
DERIVED ENTITY THROUGH BATCH FRAMEWORK NOT FAILS IF
ORIGINALLY FAILED |
||
– |
23630753 |
IMPORT OF BP FAILS ON 8.0.2 ENVIRONMENT |
|
22955414 |
UNABLE TO RESAVE HIERARCHY POST 801 LP INSTALLATION |
||
Data Quality Group |
24293717 |
DQ GROUP EXECUTIONS FAILED FOR SOLARIS X86 |
|
Metadata Browser |
23759051 |
REV_OBJECT_REPOSITORY_TL.OBJECT_DESCRIPTION TO BE
INCREASED TO VARCHAR2(4000) |
|
22884416 |
RULE MAPPING IN MDB SHOWS LONG DESCRIPTION OF BP
INSTEAD OF SHORT DESCRIPTION |
||
Forms Framework |
Forms Manager |
22328459 |
ISSUES WITH SELECT CONTROL IN FORMS MANAGER |
22328255 |
FORMS FAILED TO SAVE WHILE ADDING CUSTOM MESSAGES |
||
22328168 |
UNABLE TO CONFIGURE TYPE "1" CONSEQUENCE
VALIDATION RULE SETS. |
||
22328094 |
NUMBER CONTROLS MIN LENGTH AND MAX LENGTH PARAMETERS
NOT AVAILABLE. |
||
Forms Rendering Engine |
23583998 |
ROOT NODE SHOULD NOT BE ALLOWED TO SELECT IN
HIERARCHY CONTROL |
|
22862981 |
TOGGLE BUTTON IS REQUIRED |
||
21973759 |
COMPLETE HELP TEXT IS NOT DISPLAYED IN UI |
||
20939525 |
EVENTS FOR RICH TEXT CONTROL |
||
Forms: ROR |
22746543 |
FIELD CHOOSER SAVE IS NOT WORKING AS EXPECTED |
|
23281292 |
REMOVAL OF SEARCH ON HIERARCHY POP UP WINDOWS |
||
20818824 |
DISPLAY OF SPECIAL CHARACTERS ON SCREEN |
||
22907718 |
VALIDATIONRULESET PARAMETER CAUSING SCRIPT ERROR IN
TYPE="41" HIERACHY CONTROL |
||
22615445 |
WHILE SAVING RECORD WITH DECIMAL VALUE, AFTER SAVE
SHOWING WRONG DECIMAL VALUE. |
||
22461676 |
IF HELP TEXT CONTAINS SPECIAL/NEWLINE CHARACTERS,
APPEARS WRONG TEXT IN FRONTEND |
||
22239118 |
MORE HELP TEXT RELATED ISSUES FOUND AFTER APPLYING
21369130 PATCH |
||
21974187 |
ALIGNMENT ISSUE WITH WRAP AND UNWRAP |
||
21753129 |
REQUIRED SCROLL BAR IN CONTEXTHELP IF CONTENT IS TOO
LONG |
||
– |
23241509 |
PDF FORMAT HAS TO BE SUPPORTED BY EXPORT FUNCTIONALTY |
|
23030449 |
NOT ABLE TO LOAD THE TAB IN UI THROUGH FORMS_MANGER
BECAUSE OF BIG TAB ID |
||
22933709 |
CLICKING THE X DOES NOT CLEAR THE SELECTED LIST IN
DROPDOWN LIST |
||
22875369 |
NOT READING DATA SET DEFINITION FROM WEB LAYER CACHE |
||
22687923 |
FILE CONTAINING SINGLE QUOTE IN IT'S NAME IS NOT
SHOWN IN THE DOCUMENT GRID |
||
22390715 |
REQUEST TO REMOVE RICOFILE LIBRARY REFERENCES FROM
MAPRENDERER.JSP |
||
21768415 |
MENU AND DROP DOWN OVERLAP |
||
21626063 |
WRONG REPLACEMENT OF LOGICAL PARAMETERS THROWING SQL
EXCEPTIONS |
||
21625984 |
CONTENT OF TABS ARE GETTING DISAPPEARED |
||
21545291 |
THE UI SHOWS NO DATA EVEN IF IT HAS DATA. |
||
20783308 |
TEXT AREA - BEYOND THE ALLOWED LIMIT TRIMS DATA |
||
Data Entry Forms and Queries |
Data Entry |
22127463 |
OFSAAI 8.0 DEFQ FAILS WHEN AUTHORIZING RECORD PLACED
ON HOLD |
Operations |
Batch Execution |
22816895 |
BATCH EXECUTION SCREEN RESPONDS SLOW (TAKES APPROX 50
SECONDS TO LOAD) |
22647400 |
UNABLE TO DO EXCLUDE/INCLUDE DURING RE-RUN OPTION OF
BATCH EXECUTION |
||
– |
21311157 |
OFSAA WENT TO HANGING STATE DURING DMP RESTORE
PROCESS |
|
Metadata such as T2T, F2T, etc |
T2T Issues |
20418253 |
MAPPING SECTION IN T2T RANDOMLY DUPLICATES MAPPING
MULTIPLE TIMES AFTER EDITING |
Rules Framework |
– |
23712109 |
MRE EXECUTION FAILED,CLASSNOTFOUNDEXCEPTION |
23710220 |
COMMAND LINE RULE EXECUTION FAILED, ERROR WITH UNABLE
TO FETCH RULE ID |
||
Install and Upgrade Issues |
Migration Scripts |
23182300 |
PORTC UTILITY UPDATE LRM SPECIFIC FILE |
Upgrade Kits |
23708520 |
ISSUE IN DEPLOYING IPE.WAR AFTER AAAI 802 UPGRADE |
|
Administration |
Security Management |
23502411 |
SMS AUDIT TRAIL REPORT PRINT TO FILE OPTION IS NOT
WORKING |
– |
23476979 |
ERROR IN NOHUP.OUT WHILE STARTING 8.0.2 APP LAYER |
|
System Configuration |
Configuration |
23497342 |
NOT ABLE TO DELETE LDAP SERVER DETAILS FROM LDAP
SERVER DETAILS SCREEN |
– |
23560716 |
DEBUG INFORMATION SHOULD NOT BE PRINTED UNLESS IN
DEBUG MODE |
|
23049665 |
PORTC.JAR DOES NOT UPDATE CONTEXT-NAME IN MENU_ITEMS
TABLE |
||
22883826 |
ROOT CONTEXT FIELD COMING AS EMPTY IN LDAP SERVER
DETAILS PAGE |
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 OFSAAI 8.0.3.0.0 User Guide.
Data
Management Tools
Support
for WebLog ingestion
·
Data Source designer supports creation of
sources based on WebLog files (both Local File System and HDFS based).
·
Source model generation has been enhanced to
reverse-engineer data model for the WebLogs.
·
Data Mapping supports loading of data from
WebLog source to Hive based Information Domain (L2H).
· Task execution supports incremental/snapshot load for L2H type loads.
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug ID |
Subject |
Unified Metadata Manager |
Technical Metadata Management |
23738545 |
H2H ENGINE IS FAILING TO FETCH THE PARAMETERS PASSED
DURING FIRE RUN |
23639636 |
T2H EXECUTION FAILS WITH STATIC PARTITION COLUMNS |
Known Issues/ Limitations in This Release
Unable to create WebLog source model with only user selected/defined column names and regex values.
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.3.0.0.
Modeling
·
Support of model execution on HDFS using ORAAH
(Oracle R Advanced Analytics for Hadoop).
· Multiple dataset support for ORE based models.
List of Bugs Fixed in This Release
Component |
Sub
Component |
Bug ID |
Subject |
Advanced
Analytics Infrastructure |
– |
22454717 |
ORE EXECUTIONS
APPENDING IMPROPER/INVALID/NO PK'S TO THE DATA OUTPUTS |
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.3.0.0.
·
Infodom and APPID filters are added in Business
Entity screen allowing the user to add an Entity which is defined as Reference
in one App and as an Activity in another App.
· Assessment Cache, Business Entity cache, BusinessNamesToPhysicalName cache and Action caches are App ID aware.
List of Bugs Fixed in This Release
Component |
Sub Component |
Bug ID |
Subject |
Inline Processing |
– |
22892554 |
CACHEING IS NOT HAPPENING FOR DELETE ASSESSMENT &
CHNG OF EXEC MODE |
22874352 |
UPDATE TO AN ENTITY IN 1APP, CAUSES LOSS OF DATA FOR
THAT ENTITY IN OTHER APP |
||
22857449 |
FEW BUSS ENTITIES IMPORTED HAVE APP ID AS UNDEFINED. |
||
22809453 |
ASSESSMENT ACTIVITY IS NOT MASKED AS PER THE APP IDS
WHILE CONFIGURING RUNS. |