Set Up Sequences for Sales Order Numbers

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.

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.

Note

• 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.

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.