Issue While Creating Over Short Total at Cashier Level

(Doc ID 2210496.1)

Last updated on MARCH 31, 2017

Applies to:

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

Symptoms

Issue while creating Over Short total at Cashier level.


Steps to Recreate:

  1. While creating over / short total, use the following realms:
    sa_tran_tender
    sa_tran_head 
    sa_store_day - This is for store day information

  2. System shows the message:  'Cashier Summary Information must be available.'

  3. Try adding V_SA_BALANCE_GROUP_CASHIER. - This is for cashier information, as the system does not allow the user to add "SA_BALANCE_GROUP" table.

  4. Total is created successfully. However, it is not calculating anything, because the view defined has a constraint specifying "where register is null".   For Cashier (BALANCE_LEVEL_IND='C'),  SA_BALANCE_GROUP table was updating both register & cashier column.  Since both columns are not null, system is unable to fetch the record from V_SA_BALANCE_GROUP_CASHIER view.



Changes

 

Cause

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 hundreds of Community platforms