1. Implementing Order Management
  2. Set Up Sequences for Sales Order Numbers

Set Up Sequences for Sales Order Numbers

You can set up the starting value for your sales order numbers.

In this example, you set up Order Management so it uses 1,000 as the order number for the first order that your users create on January 1, 2019.

Here's your setup.

set up Order Management so it uses 1,000 as the order number for the first order that your users create on January 1, 2019

This topic uses example values. You might need different values, depending on your business requirements.

  1. In the Setup and Maintenance work area, click Tasks > Search, search for, then open Manage Document Sequences.

  2. On the Manage Document Sequences page, search for the value.

    Attribute

    Value

    Document Sequence Name

    ORA_FOM_DOC_SEQUENCE_AUTO

  3. In the search results, click Expand, set the values, then click Save and Close.

    Attribute

    Value

    Initial Value

    1000

    Display

    Ignore this attribute. Don't set it. It's for Oracle use only.

    Start Date

    01/01/19

    End Date

    Leave empty. Order Management will continue to increment the sales order number in perpetuity.

Guidelines

  • Order Management uses the predefined ORA_FOM_DOC_SEQUENCE_AUTO number sequence to create order numbers, starting with the value that you set in Initial Value.

  • Each order number is unique.

  • The order number is permanent. Order Management doesn't change the order number throughout fulfillment.

  • If you import orders from a source system through a web service, REST API, a file, or any other way, and if you set the DOO_RT_USE_ORDER_NUMBER order profile to Y, then Order Management uses order numbers from your source system and ignores ORA_FOM_DOC_SEQUENCE_AUTO. For details about this profile, see Keep Your Order Number When You Import.

In Oracle Order Management, you can't:

  • Use your own number sequence, except for order numbers that you import.

  • Specify sequence according to determinant type.

  • Specify gapless or manual sequencing.

For details and examples, go to REST API for Oracle Supply Chain Management Cloud, expand Order Management, then click Sales Orders for Order Hub.

Modify the Initial Value

You can modify the initial value after you set up and start using your document sequence, but the revised value must greater than the highest current order number plus 1. Assume you set Initial Value to 1000 and you create three sales orders, 1001, 1002, and 1003. If you need to modify the Initial Value attribute, then you must set it to 1005 or greater.

Use this SQL to find the current, highest order number:

SELECT
    a.last_number
FROM
    dba_sequences a,
    fusion.fnd_document_sequences b
WHERE
        b.db_sequence_name = a.sequence_name
    AND b.name = 'ORA_FOM_DOC_SEQUENCE_AUTO';

Run this query when you aren't creating new sales orders, such as outside of business hours and when you aren't doing maintenance. This way you'll avoid creating new sales orders before you have a chance to modify the initial value.

Related Topics