Overview

You are unable to batch and balance a specific till. You may get the following errors when trying to batch till sales:

KEY-COMMIT trigger raised unhandled exception ORA-06502

or 

"Error ORA-04092 - FRM - 40735"

Solution

The reason for such errors is usually transactions with no payment records. Voiding such transactions will allow the batch process to complete. Please reach out to the support team providing the till number and they will find and void the problem transaction/s for you.

select d.pos_num 
from pro.pos_defs d 
where d.till_num != '99' 
and d.ftrans_run = 'N' 
and d.till_num like '&till_num' 
and not exists ( 
select 1 
from pro.pos_payments e 
where e.pos_num = d.pos_num 
)

update pos_defs set ftrans_run = 'V', batch_run = 'Y' where pos_num in ('XXXX','YYYY');
commit;

Testing

Once the agent completes the void process for problem transaction/s, the batch process should be able to pass through.