Issue While Creating Over Short Total at Cashier Level
Last updated on APRIL 27, 2018
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:
- While creating over / short total, use the following realms:
sa_store_day - This is for store day information
- System shows the message: 'Cashier Summary Information must be available.'
- 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.
- 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.
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