Quote Numbering Is Not Consistent (Doc ID 428235.1)

Last updated on MAY 05, 2015

Applies to:

Oracle Quoting - Version 11.5.9 to 12.2.4 [Release 11.5.9 to 12.2]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Quote numbers and id's generation is consistent all through the day but jumps by 20 at beginning of each day.

-- Research:
select quote_header_id, creation_date, created_by, quote_name, quote_number, quote_version, quote_status_id, quote_source_code
from aso_quote_headers_all where quote_number between X and Y

QUOTE_HEADER_ID   CREATION_DATE       QUOTE_NUMBER   QUOTE_VERSION
---------------   -----------------   ------------   ---------------
             82   4/3/2007 11:59           42           1
             83   4/3/2007 16:28           43           1
            102   4/4/2007 10:11           62           1
            103   4/4/2007 10:42           63           1

==>> It can be verified that sequence is correct during the same day, but jumps by 20 the next day
==>> Both quotes on April 3rd are quote_header_id 82 and 83, then jumps to 102 on April 4th.

Cause

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