Retail Merchandising System (MOSC)

MOSC Banner

tran_no in ReSA start after POS last used tran_no for Store/Register/Day - lands in SA_MISSING_TRAN

edited Sep 15, 2017 4:08PM in Retail Merchandising System (MOSC) Question

I have a client that is having an issue where it is creating TRAN_NO in ReSA that is higher than the last TRAN_NO used from the store/register for that day.

If the store had actually transactions of 6601-6650 during a given day, in ReSA, SA_MISSING_TRAN table, it will start with TRAN_NOs at 6651-6700.   Those transaction numbers are then processed through the store the next day, or sometimes the next couple of days.  Out of 450 stores, this is only happening to one store/register combination.  One last comment, it happens intermittently, meaning it will happen certain days, such as the 6th, 8th, and 10th, but not the 7th or 9th, and will stop doing this for a week, two weeks, or more, then pop back up.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center