My Oracle Support Banner

Missing physical data element for Managed Assets (Report FFIEC031/041, schedule RC-T, Memoranda Line Items 1(a) to 1(o). (Doc ID 2597943.1)

Last updated on OCTOBER 20, 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

Report- FFIEC031/041
Schedule- RC-T Memoranda
line item- 1.a to 1.o

MDRM codes-

(RCFDJ263,RCFDJ264,RCFDJ265,RCFDJ266,RCFDJ267,RCFDJ268,RCFDJ269,RCFDJ270,RCFDJ271,RCFDJ272,RCFDJ273,RCFDJ274,RCFDJ275,RCFDJ276,RCFDJ277,RCFDJ278,RCFDJ279,RCFDJ280,RCFDJ281,RCFDJ282,RCFDJ283,RCFDJ284,RCFDJ285,RCFDJ286,RCFDJ287,RCFDJ288,RCFDJ289,RCFDJ290,RCFDJ291,RCFDJ292,RCFDJ293,RCFDJ294,RCFDJ295,RCFDJ296,RCFDJ297,RCFDJ298,RCFDJ299,RCFDJ300,RCFDJ301,RCFDJ302,RCFDJ303,RCFDJ304,RCFDJ305,RCFDJ306,RCFDJ307)


These line items has to report "Managed assets held in fiduciary accounts"

Based on Schedule RC-T lineage file, the flag column F_MANAGED_ASSET_IND is available in stage product tables [STG_MANAGED_INV_ADV, STG_RETIREMENT_ACCOUNTS, STG_TRUSTS, STG_CUSTODIAL_ACCOUNTS] and is used in other line items to identify managed assets in the fiduciary accounts.

However, this flag column is not used in the configuration for these line items RCFDJ263 to RCFDJ307

Changes

 This is a product configuration issue

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.