My Oracle Support Banner

Information on filter condition in 'SUB_EXPOSURES_NON_SEC ' T2T (Doc ID 2589871.1)

Last updated on SEPTEMBER 23, 2019

Applies to:

Oracle Financial Services Basel Regulatory Capital Analytics - Version 8.0.0 and later
Information in this document applies to any platform.

Goal

Information on the functional logic of including this filter "COALESCE(DIM_BASEL_PRODUCT_TYPE.v_basel_prod_type_code_level1,'OOB') NOT IN ('OTD','SFT') " in T2T - SUB_EXPOSURES_NON_SEC
as it is not fetching records from FCT_NON_SEC_EXPOSURES table & FCT_MITIGANTS table to FCT_SUB_EXPOSURES table where the product type is amongst 'OTD' or 'SFT'

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.