Less No Of Records Are Deleted From Switch Tables by SWDPURGE Batch
(Doc ID 2636419.1)
Last updated on SEPTEMBER 22, 2021
Applies to:
Oracle FLEXCUBE Universal Banking - Version 12.0.3 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
SWDPURGE Batch configured in one branch only (head office) for Swtb_Txn_Log the purging happens for all the branches regardless of the branch whose EOD is executed but for tables swtb_settlement, swtb_mer_settlement, swtb_retry_log only the specific branch data is deleted where all the branches data moves to respective history tables
EXPECTED BEHAVIOR
-----------------------
1. The SWDPURGE batch is expected to configure in one main branch, batch should delete all the record despite of related branch.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Configure the SWDPURGE batch in one branch and run the EOD and verify the remaining records in tables swtb_settlement, swtb_mer_settlement, swtb_retry_log only, only that branch records are deleted whose EOD is been executed.
BUSINESS IMPACT
-----------------------
The issue has the following business impact
Purging of swtb_settlement, swtb_mer_settlement, swtb_retry_log only will not be done.
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 |