My Oracle Support Banner

STORE_CLOSED_DATETIME Not Updated In SA_STORE_DAY After Sending DCLOSE (Doc ID 2158648.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

in SA_TRAN_HEAD table, store_closed_datetime is not updated after sending DCLOSE for a Store/Day.

Steps to reproduce:

1) Create a Store/Day
2) Open the Store
3) Upload some sales transcations
4) Close the store
5) Close the Store/Day by sending DCLOSE

Note that in SA_STORE_DAY table STORE_STATUS is updated to 'C', but STORE_CLOSED_DATETIME is still null

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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