My Oracle Support Banner

SA_SYS_VALUE Does Not Get Updated with a New Revision Number After Re-Totaling (Doc ID 2879568.1)

Last updated on JUNE 28, 2022

Applies to:

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


After the Oracle patch 19.3.006 upgrade, the SA_SYS_VALUE revision update is not happening correctly. It is not creating a ‘New’ VALUE_REV_NO – it is UPDATING the existing record.

Steps to Reproduce
1. Edit Store/Day transaction in error
2. Fix the error (for example, correct invalid item)
3. Retotal the Store/Day
4. Check whether SA_SYS_VALUE creates a new record with a new VALUE_REV_NO for the new SYS_VALUE. (Error at this step, as it updates existing revision)




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.