Store Is Not Available For Viewing/editing Store Day Details
(Doc ID 2776742.1)
Last updated on MAY 25, 2021
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