My Oracle Support Banner

Issue While Creating Over Short Total at Cashier Level (Doc ID 2210496.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Retail Sales Audit - Version 16.0 to 16.0 [Release 16.0]
Oracle Retail Sales Audit - Version 16.0.1 to 16.0.1 [Release 16.0]
Information in this document applies to any platform.


Issue while creating Over Short total at Cashier level.

Steps to Recreate:

  1. While creating over / short total, use the following realms:
    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.


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

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