Why Does the Sequence for Creating New Orders Not Take Into Consideration Any Canceled Order Numbers That Were Not Committed to the DB?
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 12.0.9 and later
Information in this document applies to any platform.
In Oracle Retail Merchandising System (RMS), why does the sequence for creating new orders not take into consideration the canceled order numbers that were never committed to the database?
When creating a new order and after entering some data, if the user clicks the 'Cancel' button instead of clicking 'OK', that sequence number is wasted. The next time the user opens the new order form, the next incremented value is displayed in the 'order no.' field, though the previous sequence was not committed to the database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms