Imbalance in VAULT/TILL Balance due to Deposit Trnasction Not Updating On Tilll id
(Doc ID 2561651.1)
Last updated on SEPTEMBER 09, 2019
Applies to:Oracle FLEXCUBE Universal Banking - Version 12.2 and later
Information in this document applies to any platform.
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';
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.
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