My Oracle Support Banner

AGLIE_RP_EBA_8.1x: Failure Of T2T T2T_FCT_REG_ACCOUNT_SUMMARY for the data loading of column 'n_contrctl_maturity_term' (Doc ID 2737142.1)

Last updated on DECEMBER 21, 2020

Applies to:

Oracle Financial Services Regulatory Reporting for European Banking Authority - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

Agile RP EBA 8.1.0.1.0

T2T "T2T_FCT_REG_ACCOUNT_SUMMARY" load into column 'n_contrctl_maturity_term' fails with the following error.
"ORA-01438: value larger than specified precision allowed for this column"


T2T uses below logic to compute the n_contrctl_maturity_term
TO_DATE(
  coalesce(
  fct_common_account_summary.n_eff_maturity_date_skey,
  fct_common_account_summary.n_maturity_date_skey,
  fct_common_account_summary.n_orig_maturity_date_skey
  ),
  'YYYYMMDD'
 ) - TO_DATE(
  fct_common_account_summary.n_origination_date_skey,
  'YYYYMMDD'
 )

Changes

 NA

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
References


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