Sequence Counters

System counters keep track of record numbers (for example, ASN Numbers) that are automatically generated by the system. Additionally, sequence counters allow you to configure the record number generated for each label/document/output file, such as Inbound Shipment numbers, BOL numbers, and Outbound Load files.

You can only create new sequence counters by copying from existing ones. To do this, from the Sequence Counter screen, select the sequence counter that will be created, and click “Copy” ().

Note: Oracle WMS Cloud does not guarantee that the next up sequence counters will always be next up (for example, in instances where multiple processes use the same counter, or when there are processes with high concurrency and caching of data.)"

Description of Fields

  • Sub_code: This field is used in conjunction with Company Parameter “OBLPN_COUNTER_SUB_CODE_FIELD”. See description of this parameter for details.
  • Counter Description: The sequence counter description.
  • Recycle_flg: When the max number (“End Number”) is reached in the current sequence counter, this flag determines whether or not the system automatically restarts the counter back to the “Start Number”.
    • If CHECKED, WMS automatically resets the counter when the max number is reached.
    • If UNCHECKED, WMS does not reset the counter when the “End Number” is reached. When this happens, you will not be able to create the new record until its sequence counter is reset.

If the current number is at 1,000 and the “Max Number” is 1,000, the system returns an error message when attempting to generate a new number.

  • Prefix: Defines the prefix value that displays for the current record. For example, if the prefix is “BOL”, the system generates the number as “BOLXXXX”.
  • Start/End Number: Defines the start and max number for the given sequence counter. When the End Number is reached, you must either reset the counter by checking the ‘recycle_flg’ or increase the “End Number” value manually.
  • Nbr_suffix: Hardcodes a suffix to every sequence in that counter.
  • Current Number: Denotes the current number that the sequence counter is on.
  • Sequence Length: Denotes the string length of the sequence counter. Note that the prefix is NOT included in this count.
  • Append Facility Code to Prefix: Flag that automatically appends the facility code to the sequence counter.
  • Increment: The increment value in which the sequence counter increases.
  • Check Digit Method: The method that calculates the last digit of the LPN number. Supported methods are SSCC, BOL, and EAN13.
  • Destination Company/Facility: You can also make sequence counters exclusive to a Company and Facility. NOTE: Since this may lead to duplicate sequence counters, it is highly recommended to use a unique prefix for every Company/Facility sequence counter combination.