Imbalance in VAULT/TILL Balance due to Deposit Trnasction Not Updating On Tilll id (Doc ID 2561651.1)

Last updated on APRIL 29, 2021

Applies to:

Symptoms

Cash deposit transaction Posted Successfully but till is not Updated. Due to N/w Error the Till Updation has Failed.

Retail Teller transaction is in Discarded status with customer balance updated and the specific till balance not updated.

To further analyze this scenario, one will have to collect Till details (using wb_till_info.sql) along with the retail teller transaction details spool listing (using Brn_Trn_Info.sql). The following steps and queries will help you to identify such discrepancies.

1)    Transaction tables have status DIS(Discarded) in place of COM (Completed).
select txnstatus, stagestatus from FBTB_TXNLOG_MASTER where XREFID='&Ref_no';

OR

select txnstatus, stagestatus from FBTB_TXNLOG_MASTER_HIST where XREFID='&Ref_no';

select * from fbtb_till_totals where branchcode ='&BRNCODE';

select * from fbtb_till_detail_ccy where branchcode ='&BRNCODE';

2)    Verifying from accounting table if the accounting is authorized and if the customer balance is updated.

  Select * from acvw_all_ac_entries where external_ref_no='&Ref_no';

3)    If both the above are true and if the Gl balance is matching with the Physical Cash and only till balance is not matching with physical cash balance then proceed to the workaround under solution section.

Changes

Cause

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