Oracle Financial Services Capital Adequacy Pack v8.0.0.0.0 Minor Release #3 (8.0.3.0.0)

Description

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.

Prerequisite

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

How to Apply This Release?

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

·         Known Issues / Limitations

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 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

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.

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

8.       Forms Manager

·         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.