My Oracle Support Banner

RC-C, RC-N: CIBUSCARD With Loans To Finance Agricultural Production And Other Loans To Farmers (Doc ID 2699138.1)

Last updated on AUGUST 14, 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

Schedule: HC-C
Line item 3(BHCK1590,BHDM1590)
filters: DIM_REG_PRODUCT_CLASSIFICATION.V_REG_PROD_CLASSIFICATION_CODE='LOANFINAGRIPROD' and DIM_REG_LOAN_PURPOSE.V_REG_LOAN_PURPOSE_CODE in('AGP','FARMEROTH')

Regulatory instructions for line item 3:
Page HC-C-11: Include: Loans to farmers for household, family, and other personal expenditures (including credit cards and related plans) that are not readily identifiable as being made to farmers need not be broken out of item 6 for inclusion in this item.
Page HC-C-12: Exclude: Loans to farmers for commercial and industrial purposes, e.g., when a farmer is operating a business enterprise as well as a farm (report in item 4).

Issue #1: "RLUS_FRAS_REG_PROD_CLASS_12" is being used for the line items to reclassify loans to agriculture. However  this rule does not consider DIM_REG_PRODUCT_TYPE.V_REG_PROD_TYPE_GROUP_CODE = 'CARDS'.
So records with the above mentioned data combination is not getting reclassified under LOANFINAGRIPROD.

Issue #2: RLUS_FRAS_REG_PROD_CLASS_09 which is used for reclassification of COMINDLOAN Commercial And Industrial Loans, considers DIM_REG_PRODUCT_TYPE.V_REG_PROD_TYPE_GROUP_CODE = 'CARDS' but excludes Reg loan purpose = AGP.
Dataset filter: DIM_REG_LOAN_PURPOSE.V_REG_LOAN_PURPOSE_CODE NOT IN ('FARMEROTH','AGP','PURSEC')
So these records are not getting classified under either LOANFINAGRIPROD or COMINDLOAN.

 

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.