My Oracle Support Banner

Issues Related To FFIEC 030 (Doc ID 2603113.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.8 and later
Information in this document applies to any platform.

Symptoms

 1. "[FFIEC 030s] : 4. Total gross notional amount of derivative contracts

We expect to see STG_FORWARDS and STG_CREDIT_DERIVATIVES table PDEs as well for the notional amount fo derivative contracts, however, we only see STG_FUTURES; STG_FX_CONTRACTS; STG_OPTION_CONTRACTS; STG_SWAPS_CONTRACTS table available. Can you confirm how is OFSAA sourcing this information?

2. " [FFIEC030s] : Attributes for following elements are not available in FFIEC-030 lineage file and are required either at schedule level or for specific line items. Elements are not available either in master staging tables or in DIM tables.
(1) Counterparty Type (V_PARTY_ID or V_PARTY_TYPE_CODE) : Expecting to see: STG_BORROWINGS,STG_INVESTMENTS ,STG_LOAN_CONTRACTS ,STG_MM_CONTRACTS however, no PDEs available in the lineage. Impacted MDRMs: FORB3002, FORB3001
(2) Accounting Methodology Type (F_REPORTED_AT_FAIR_VALUE): Expecting to see F_REPORTED_AT_FAIR_VALUE PDE to report the accounting methodology for Gross Due from or to related institutions transactions, however, is not available in the 806 lineage. Impacted MDRMs: FORB3002, FORB3001.
(3) Holding Type (V_HOLDING_TYPE): Expecting to see V_HOLDING_TYPE PDE to report the Holding Type for Gross Due from or to related institutions transactions, however, is not available in the 806 lineage. Impacted MDRMs: FORB3002, FORB3001

3. "[FFIEC030] : In Line items 20/21 Commitments to purchase foreign currencies and U.S. dollar exchange and All other futures and forward contracts are to be reported
Currently we don't see STG_FORWARDS staging table, we see either STG_FUTURES and/or STG_FX_CONTRACTS only for the different attributes required
Example:
- Buyer/Seller Indicator: Indicates whether the bank’s position in a transaction is that of a buyer or a seller. Expecting to see STG_FORWARDS product staging tables but not available in the lineage. Impacted MDRM: FORB3415

Analysis - LINEAGEDOC; STG_FORWARDS not available in lineage, whereas other non-derivative PP tables are available.

4. "[FFIEC030] : In line item 8&9 (assets) and 16&17 (liabilities), Gross balances due from/to related institutions, i.e. Intrabank transactions.
Intrabank transactions include transactions with other foreign branches of the reporting branch’s bank, the head office and U.S. branches of the reporting branch’s bank, and consolidated subsidiaries of the reporting branch’s bank. All balances and positions due from and due to these entities (other than off-balance sheet items) should be reported as gross amounts in FFIEC 030 Asset line items 8 and 9 (FFIEC 030S line item 1) and FFIEC 030 Liability line items 16 and 17 (FFIEC 030S line item 3), as appropriate.
- We currently don't see any attribute for this information. Can you confirm how is OFSAA identifying this information to cover the requirements?
Impacted MDRMs: Assets - FORBC482, FORBC483; Liabilities - FORBC485, FORBC486

5. "[FFIEC030] : In line item 8&9 and 16&17, Gross balances due from/to related institutions , i.e. Intrabank transactions are to be reported for assets and liabilities respectively. We see in lineage STG_GL_DATA, however, per OFSAA banking product processor we are expecting to see:
1. Assets: We expect to see STG_INVESTMENTS, STG_LOAN_CONTRACTS, STG_MM_CONTRACTS, but available in lineage . Can you confirm how is OFSAA sourcing this information?
Impacted MDRMs: FORBC482, FORBC483
2. Liabilities: We expect to see STG_BORROWINGS, STG_CASA, STG_TD_CONTRACTS, but available in lineage . Can you confirm how is OFSAA sourcing this information?
Impacted MDRMs: FORBC485, FORBC486

6. "[FFIEC030] : In line item 10, other assets are to be reported, including federal funds sold and securities purchased under agreements to resell. We are expecting to see Repos staging table, according to OFSAA banking product processor, however is not available in lineage. Can you confirm sourcing how is OFSAA sourcing these transactions?

7. "[FFIEC030]: In line item 2 and 3, Balances due from are to be reported. Per OFSAA banking product processor we are expecting to see STG_MM_CONTRACTS and STG_INVESTMENT, however, we only see STG_GL_DATA. Can you confirm how is OFSAA sourcing this information?

8. "[FFIEC030] : Attributes for following elements are not available in FFIEC-030 lineage file and are required either at schedule level or for specific line items. Elements are not available either in master staging tables or in DIM tables.
(1) Internal Entity Type (V_ENTITY_TYPE) and (V_LV_CODE), require to identify the type of entity in the organization structure for e.g. Consolidated Holding Company, subsidiary etc. Impacted MDRMs for securities and Loans: FORB6597,FORB0423,FORB1410,FORB2237,FORB1600,FORB2024,FORB2123
USAGE; Entity/Branch selection is to be done at AR reporting portal level

(2) Location Where Instrument is Held (V_BRANCH_CODE): FORB6597,FORB0423,FORB1410,FORB2237,FORB1600,FORB2024,FORB2123, FORB6839,FORB3411
USAGE; Branch code will be user input for the executing the run for branch-specific reporting; hence not required in MDRM configuration/Lineage

(3)Accounting Methodology Type (N_REPORTED_AT_FAIR_VALUE_RCY) : To identify whether the exposure is to be reported at Fair Value. Impacted MDRMs: FORB0033,FORB0034,FORB6597,FORB0423,FORB2146,FORB1410,FORB2237,FORB1600,FORB2024,FORB2123,FORBC482,FORBC483,FORB2160,FORB2623,FORB2625,FORB2238,FORB2239,FORBC485,FORBC486,FORB2930,FORB0071
USAGE; FFIEC030 requires reporting of values at Fair value for AFS and Amortized cost for HTM, therefore no need to check if the exposure is being reported at fair value or not.

(4) Holding Type (V_HOLDING_TYPE): required to identified non trading product transactions and is missing for following MDRMs: FORB0033, FORB0034, FORB0071, FORBC482,FORBC483,FORBC485,FORBC486
(Also, expecting to see STG_OD_ACCOUNTS.V_HOLDING_TYPE, however, is not available in the lineage for the following MDRMs: FORB2146, FORB1410, FORB2237, FORB1600, FORB2024, FORB2123)
USAGE;
i) FORB0033, FORB0034, FORB0071, FORBC482,FORBC483,FORBC485,FORBC486 are currently sourced through GL data. However design will be updated to source same from PP tables, after the said change Holding Type would be available in Lineage.
ii) FORB2146, FORB1410, FORB2237, FORB1600, FORB2024, FORB2123 - Please check the latest Lineage or HM Linkage (v 808) - V_HOLDING_TYPE is available

(5) Unsettled Transaction Flag: It is used to identify if securities transactions are not settled for a time period. Expecting to see STG_FORWARDS; STG_FUTURES; STG_FX_CONTRACTS product staging tables. Impacted MDRMs: FORB6836,FORB3415
CONFIG-USFED; Configuration will be updated to remove unsettled transactions.

(6) Counterparty Type (V_PARTY_TPYE ) : Expecting to see: STG_MM_CONTRACTS,STG_INVESTMENTS;STG_BORROWINGS; STG_CASA; STG_TD_CONTRACTS, however, no PDEs available in the lineage. Impacted MDRMs:FORB0033,FORB0034,FORBC482,FORBC483,FORBC485,FORBC486,FORB0071. Line item 27 for Total Interest Bearing included in line items 12,13 and 14
CONFIG-USFED; Mentioned MDRMs are are currently sourced through GL data. However design will be updated to source same from PP tables, after the said change Standard_party_type would be available in Lineage.

(7) Country of Domicile (Counterparty) (V_DOMICILE_COUNTRY): Required to identify deposit of US/Foreign Banks and we are expecting to see STG_BORROWINGS; STG_CASA; STG_TD_CONTRACTS,STG_MM_CONTRACTS,STG_INVESTMENTS product staging table but not available in lineage. Impacted MDRMs: FORB0033,FORB0034,FORB1600, FORB2623,FORB2625
CONFIG-USFED - Configuration will be updated to identify if counterparty's parent bank is US/Non-US domiciled

(8)Interest Bearing Deposit Flag: We expect to see STG_PRODUCT_MASTER.F_NON_INTEREST_BEARING_DEPOSIT, however is not available in lineage for MDRM = FORB0071. (Note this is available for MDRM FORB6636 where also interest bearing are to be sourced)
CONFIG-USFED; Mentioned MDRMs are are currently sourced through GL data. However design will be updated to source same from PP tables, after the said change F_NON_INTEREST_BEARING_DEPOSIT would be available in Lineage.

(9)Original LTV(Property) for MDRM = FORB1410.
USAGE; Please check the latest Lineage (v 808) - N_ORIG_LTV is referred from PP tables for mentioned MDRMs

(10) Loan and Lease Product Type (V_PROD_CODE) for MDRMs: FORB1410, FORB2237, FORB1600, FORB2024, FORB2123
USAGE; Please check the latest Lineage (v 808) - V_PROD_CODE is referred from PP tables for mentioned MDRMs

(11)Carrying Value (Asset)(N_EOP_BAL) for MDRMs: FORB1410, FORB2237, FORB1600, FORB2024
USAGE; Please check the latest Lineage (v 808) - N_EOP_BAL is referred from PP tables for mentioned MDRMs

Missing STG_CARDS staging table:
(12) MDRM FORB2024 requires reporting of loans and leases including loans to individuals (like credit cards). We expected to see table STG_CARDS related PDEs in the lineage file, however, currently we only see STG_LOAN_CONTRACTS and STG_LEASE_CONTRACTS tables. Impacted MDRM: FORB2024""
USAGE; Please check the latest Lineage (v 808) - STG_CARDS is referred for mentioned MDRMs

(13) Missing STG_OD_ACCOUNTS staging table for Loans related line items:
USAGE; Please check the latest Lineage (v 808) - STG_OD_ACCOUNTS is available"

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
 Goal
References


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