Why Does the Sequence for Creating New Orders Not Take Into Consideration Any Canceled Order Numbers That Were Not Committed to the DB? (Doc ID 1920869.1)

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.

Goal

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.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms