My Oracle Support Banner

RC-S - Clarify Sourcing Of FCT_SECURITIZATION_POOL (Doc ID 2601555.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.6 and later
Information in this document applies to any platform.

Symptoms

The table FCT_SECURITIZATION_POOL is listed in the 8.0.6.1.0 DE Spreadsheet as part of the BASEL Regulatory Capital application, but there is also a STG_SECURITIZATION_POOL table part of FSDF. Issue is FCT_SECURITIZATION_POOL seems to be expecting inputs from both a Stage Table (STG_SECURITIZATION_POOL) and an External Engine Table (FCT_SECURITIZATION_POOL which ideally should be FCT_REG_POOL_SUMMARY if at all needs to be from External Engine). The current logic is expecting N_BASEL_POOL_TYPE_SKEY and N_SELLER_RETAINED_INT_LOANS to come from FCT_SECURITIZATION_POOL via the Basel Regulatory Capital solution

Changes

 1. Stg_Securitization_Pool will remain in DE sheets and will be used for
sourcing.
 2. Fct_Securitization_Pool will be removed.

Cause

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
Symptoms
Changes
Cause
Solution


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