My Oracle Support Banner

GL Reconciliation : FSI_ADJ_ENTRY_ATTRIBUTES.V_DEFAULT_COL_VALUE - Varchar2(60) - Datalength Limitation (Doc ID 2624200.1)

Last updated on JANUARY 02, 2020

Applies to:

Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

In 'Allocation' tab, Auto Adjustments to post directly to the product processor table in GL recon definitions, where one of the defaulting attribute from the PP Table (STG_LOAN_CONTRACTS.V_PURPOSE) has values more than 60 chars of length, which is not getting applied to the GL plug record/row created by the recon engine, due to data length overflow and the GL Reconciliation rule execution fails with below error

ORA-12899 VALUE TOO LARGE FOR COLUMN 'FSI_ADJ_ENTRY_ATTRIBUTES.V_DEFAULT_COL_VALUE'(ACTUAL:62, MAXIMUM:60)

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
References


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