My Oracle Support Banner

SMTB_SMS_LOG Table Not Archiving And Getting Locked Frequently (Doc ID 2811936.1)

Last updated on JANUARY 24, 2022

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
Bank team noticed that SMTB_SMS_LOG getting locked during operation hours while SMTB_SMS_LOG_HIST table has no records.

EXPECTED BEHAVIOR
-----------------------
SMTB_SMS_LOG table data should get archived into SMTB_SMS_LOG_HIST table

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform operations in flexcube, unless locks are manually removed.

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.