STORE_CLOSED_DATETIME Is Not Updated in SA_STORE_DAY when Store Is Closed Using the RESA Screen

(Doc ID 2395559.1)

Last updated on MAY 09, 2018

Applies to:

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

Symptoms

STORE_CLOSED_DATETIME is not updated in the SA_STORE_DAY table when the Store is closed using the RESA screen.

Steps To Reproduce:

1. Go to RESA>Store Day Search.
2. Go to Store Day Summary>Manually Update Data Status>Set Fully Loaded.
3. Click Yes on Pop-up.
4. Click Save and Close.
5. Note SA_STORE_DAY.STORE_CLOSED_DATETIME is not updated.

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