Missing T2T For FCT_COMMON_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL From STG_BILLS_CONTRACTS, (Doc ID 2816073.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Symptoms

Issue : Missing logic in T2T of FCT_COMMON_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL from STG_BILLS_CONTRACTS.

Usage of this data element in reg rep USFED

HC-D-5 (Line items M.1.d: Other loans),

For reporting line item M.1.d 'Unpaid principal balance of loans measured at fair value' (reported in Schedule RC-D,
items 6.a through 6.d)) and M.2.b (Loans measured at fair value that are past due 90 days or more: Unpaid principal balance), unpaid principal balance should be used from all the loan related staging tables like STG_LOAN_CONTRACTS, STG_BILLS_CONTRACTS, STG_OD_ACCOUNTS, STG_REPO_CONTRACTS and STG_CARDS.

OFSAA is reporting FCT_REG_ACCOUNT_SUMMARY. N_OUTSTANDNG_PRINCIPAL_BAL_RCY for these line items. And FCT_REG_ACCOUNT_SUMMARY. N_OUTSTANDNG_PRINCIPAL_BAL_RCY in turn is getting derived from FCT_COMMON_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL * FSI_EXCHANGE_RATES.N_EXCHANGE_RATE expression.

The configuration for both (M.1.d and M.2.b) the line items states FCT_REG_ACCOUNT_SUMMARY.N_OUTSTANDNG_PRINCIPAL_BAL_RCY as measure to be reported.

Cause

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