My Oracle Support Banner

Clarification for attribute V_ACCT_STATUS_CODE in DIM_ACCT_STATUS Used In Multiple and Not-consistent Ways (Doc ID 2715393.1)

Last updated on OCTOBER 05, 2020

Applies to:

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

Symptoms

The field  V_ACCT_STATUS_CODE is used to capture different values like Forbearance, critical etc which are overlapping

As per RRS 8094 STG_LOAN_CONTRACTS.V_ACCT_STATUS_CODE - STG_LOAN_CONTRACTS.V_ACCT_STATUS_CODE is used to identify

If the Loan is in Forbearance. - STG_LOAN_CONTRACTS.V_ACCT_STATUS_CODE is used to identify if the Loan is Criticized and classified items (RC-O line 6).

The V_ACCT_STATUS_CODE is field has overlapping values and is asking for potentially independent attributes: Examiner rating of a loan and (per a T2T transition) whether it is frozen or in foreclosure. Similar observation for STG_CARDS.V_ACCT_STATUS_CODE - Is used to identify if the card is frozen. - Is used to identify if the asset is Criticized and classified items (RC-O line 6).

 

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