My Oracle Support Banner

Store Is Not Available For Viewing/editing Store Day Details (Doc ID 2776742.1)

Last updated on AUGUST 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.


User can see records for few store days in SA_STORE_DAY_WRITE_LOCK and SA_STORE_DAY_READ_LOCK locked by X user and are unable to view / edit store details in ReSA for these stores.

Steps To Recreate:

1. Make sure sa_fif_gl_cross_ref table is missing a mapping records (store/total_id) on a month end.

2. Fully audit and close the store so that totals can be exported to GL.

3. Run saexpgl and notice that saexpgl aborts due to missing mapping.

4. Check the locked records in sa_store_day_read_lock table.


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.