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:
- 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.
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