Skip to main content
Solved

Increasing Shipment ID#


Forum|alt.badge.img+2

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#?

Best answer by Fredrik Johansson LKP

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?

View original

Forum|alt.badge.img+11

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?


Marcel.Ausan
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • August 21, 2024

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings