Less No Of Records Are Deleted From Switch Tables by SWDPURGE Batch (Doc ID 2636419.1)

Last updated on FEBRUARY 09, 2020

Applies to:

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

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