Catm_eca_block_detail Table Has Mismatch In Outstanding_block_amount,req_block_amount (Doc ID 3077372.1)

Last updated on APRIL 03, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
 catm_eca_block_detail table has mismatch in outstanding_block_amount,req_block_amount

EXPECTED BEHAVIOR
-----------------------
 catm_eca_block_detail table shall not have any mismatch in outstanding_block_amount,req_block_amount

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. As part of OBPM txn, the ECA block is marked in catm_eca_block detail.
2. As part of accounting req from OBPM, the block to be released in FCUBS.
3. We observed that even though handoff issuccess in OBPM, the block is not released in fCUBS table and there is outstanding block amount column.

Cause

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