My Oracle Support Banner

DETB_UPLOAD_EXCE_HIST INSERTING ERROR AT EOD TIME (Doc ID 3014744.1)

Last updated on APRIL 16, 2024

Applies to:

Oracle FLEXCUBE Universal Banking - Version 14.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.6.0.5.0 version, Production Support-SET

DETB_UPLOAD_EXCE_HIST INSERTING ERROR AT EOD TIME

Dear Team,

Version: 14.6.0.5.0
We are facing error inserting into DETB_UPLOAD_EXCE_HIST at the time of EOD.

Package: depks_msc

Analysis:
------------
in DETB_UPLOAD_EXCE_HIST table seq_no data type in NUMBER(4) and DEZB_UPLOAD_EXCEPTIONS seq_no data type is NUMBER(8).
While doing DE upload and seq_no is 5 digit(>9999), its throwing an error for inserting to DETB_UPLOAD_EXCE_HIST.

Regards,
<PERSON>

 

ERROR
-----------------------
ORA-01438: value larger than specified precision allowed for this column


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot execute EOD.

Changes

 

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.