OBO: Value Too Large For Column "RPM_TW_TD_INTEREST_DETAILS"."UDE_ID" Facing In Interest Details Tab (Doc ID 2947432.1)

Last updated on MAY 09, 2023

Applies to:

Symptoms

On : 14.6.0.2.0 version, Implementation Support
Patch set : 14.6.0.2.0 , Maintenance line
OBO: value too large for column "RPM_TW_TD_INTEREST_DETAILS"."UDE_ID" facing in interest Details tab

ACTUAL BEHAVIOR
----------------------------
In Term Deposit Application Entry stage, Interest Details add the Margin filed value and click next getting internal server error in obremo-rpm-term-deposit-service. In the logs getting following error
Error Code: 12899
Call: INSERT INTO RPM_TW_TD_INTEREST_DETAILS (ID, COMPONENT_CODE, CUSTOMER_MARGIN, EFFECTIVE_RATE, INTEREST_MASTER_ID, INTEREST_RATE, INTEREST_TYPE, MAIN_COMPONENT, MARGIN_ALLOWED, PROCESS_REF_NO, RATE_CODE, SEQ_NO, UDE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [1091293706197278721, TDIN, 1.0, 1.0, 1091293706197278720, 0.0, Interest Rate, N, Y, 001TDAUTO0000126, null, 1, TD_INT_RATE]
Query: InsertObjectQuery(InterestDetailsWork [interestMasterId=1091293706197278720, processRefNo=001TDAUTO0000126, componentCode=TDIN, mainComponent=N, udeId=TD_INT_RATE, interestType=Interest Rate, interestRate=0.0, effectiveRate=1.0, customerMargin=1.0, marginAllowed=Y, seqNo=1, interestDetailsMasterWork=null, rateCode=null]); nested exception is javax.persistence.RollbackException: Exception [Link-4002] (Persistence Services - 2.7.6.v20200131-b7c997804f): org.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-12899: value too large for column "TDACC"."RPM_TW_TD_INTEREST_DETAILS"."UDE_ID" (actual: 11, maximum: 10)
 
EXPECTED BEHAVIOR
--------------------------------
User needs to increase the "UDE_ID" column size.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot increase the "UDE_ID" column size  in the Margin field value.

Changes

 Will be able to  increase the "UDE_ID" column size in the Margin field value .

Cause

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