My Oracle Support Banner

Saimptlogfin Fails Because of Null Cashier (Doc ID 2690611.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Oracle Retail Sales Audit - Version 16.0.3 and later
Information in this document applies to any platform.

Symptoms

When running saimptlogfin, the batch fails and the below error message is faced:


saimptlogfin_1~20200708103041~CreateBalanceGroup~sa_tran_head~103~RET-0103: generic function processing error~Non-fatal error. Register or Cashier is Null for store_day sequence = 6017286
saimptlogfin_1~20200708103041~CreateBalanceGroup~sa_balance_group~-24333~ORA-24333: zero iteration count~Inserting cashiers for store_day_seq_no 6017286


The issue can be reproduced with the following steps:

1. Set the balance_level_ind to 'C' in sa_system_options.
2. Upload an rtlog file with null cashier. Run sagetref, saimptlogi.
2. Complete the rtlog import process with the batch saimptlogfin.
3. Verify Loading Data (Data Status) in ReSA (Retail Sales Audit) in Store Day Audit.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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