Skip to main content

I have a client who wants to increase the beginning Shipment ID # to a higher number. There is no Shipment ID option in the Coordinators Group to change this. Is there any known option of changing/increasing the beginning Shipment ID#?

Shipment ID is an oracle sequence:

 

There is no way a “normal” user can change this similar to how we can do with Customer Order Numbers via Coordinator group.

If it is really needed I think a DBA could change the Next Number and/or Min Value directly in the database in the sequence above?

@aconsult agree with @Fredrik Johansson LKP. This can be changed only by altering the sequence in the DB. However if you decide to go this route, please be mindful this is a ‘global’ sequence that is shared across all the sites in your environment.

So your shipment ids will not be in sequence per site.

Site A → shipment id - 90000001

Site B → shipment id -  90000002

Site C → shipment id -  90000003

Site D → shipment id -  90000004

Reply


Terms & ConditionsCookie settings