1. Oracle Warehouse Management Cloud User Guide
  2. System Overview

5Extra Configuration

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.

Barcode Types

You can also configure the company to have a fixed barcode format depending on the barcode type. The configurable barcode types are:

  • Asset
  • Seal
  • Batch
  • Cart
  • Inbound LPN
  • Inbound Shipment
  • Item
  • Location
  • Outbound LPN
  • Pallet

Description of Fields

  • Barcode Type: Denotes the barcode type that is being edited/created.
  • Sequence Nbr: Used as a number identifier for a group of Barcode Types.
  • Description: Displays the barcode type’s description.
  • Length: Denotes the string length required for the barcode type. Note that the Prefix is included in this count. For example, if the Prefix = “LPN” and Length = 10, the system accepts the value “LPN0000001” (10 digits total). NOTE: If you want to disable to the barcode type validation in the system, the length must be set to “-1”. This will override any other configuration existing for that barcode type.
  • Prefix: Denotes the prefix used for the barcode type.
  • Remove Prefix: If this flag is checked, the barcode type ignores the “Prefix” field.
  • Numeric_flg: Forces the barcode type to only accept numeric values.

Custom_barcode: Calls custom scanning logic for scanning inbound LPNs into the system.

Configuring Barcode Types

Barcode Types are used for situations where the company requires a fixed barcode prefix/length for a given label.

The company only accepts barcodes of prefix “LPN” and “CS”, each of length 10.

The configuration would be as follows:

Configuring IBLPN Barcode Types

With the configuration above, the system only accepts Inbound Containers that have the barcode of prefix LPN and CS. For example: “LPN0000001” & “CS00000001”. Scanning a barcode that is different from either one of these formats produces the following error message in the RF:

"Invalid Barcode for type IBLPN"

Printers

Setting up printers in WMS is a two-fold process:

  1. Setting up printers on the back-end (connection between the facility and WMS network)
  2. Adding the configured printers from step 1 to WMS.

Configuring Printers on the Back End

This step requires the help of ORACLE WMS CLOUD Support. To do this, create a Happy Fox ticket requesting printers to be set up. When you create the ticket, make sure that the “Request Type” is set to “Application Admin Request”. Within the ticket, provide the following printer information:

  • The printer name
  • The printer’s IP and port address
  • The printer model number.

Adding the Configured Printers from Step 1 to WMS

  1. Once ORACLE WMS CLOUD Support configures the printers into the server, create the printer records in WMS.
  2. Go to the “Printers” screen and click the “Create” button.
  3. Populate the printer type, name and description.
  4. If this is the first time the printer is set up, select the printer record and click on “Restart Print Service”.
  5. Test the printer.

The “Printers” screen also provides some visibility to the printers in WMS through two buttons:

  • printer_status
  • Printer Logs

The “printer_status” button displays information about the printer’s current status. See example below:

Device for PRINTER1: lpd://123.456.789.012:345/PRINTER1

Printer PRINTER1 is idle. Enabled since Fri Oct 24 14:16:02 2014

Data file sent successfully

The “Printer Logs” displays all the printing jobs that have been executed, ordered by date.

Configure and Generate Custom WebReport for OBLPN Packing Slip

For example, if a custom OBLPN Packing Slip has been designed using Web Reports and if you need this custom report to be printed by clicking “Packing List” button on OBLPN UI, the following configuration needs to be in place.

  1. From the Web Report UI:
    • Create a web report for category : “AllocationToContainer”.
    • User can also add other categories with AllocationToContainer_ID
  2. From the Company Report Type UI select the following:
    • Report type: OBLPN_PACKING
    • “Report Sub Type” = WebReport
    • “web report path” = folder_name\web_report_name ,OR folder_name/web_report_name
    • “Web report format”: select your preference
  3. From the OBLPN Inquiry
    • When you select single/multiple records and click on 'Packing List' button, the system generates the custom OBLPN packing slip for the selected record(s)
    • o PDF format will be displayed in a Dashboard
    • o CSV and XLS format will get auto-downloaded
  4. From RF Print Ship Label (Module: rf.outbound.cwrfprintshiplbl)
    • When the screen parameter “print-packing-slip” is set as “OBLPN”, the system generates the custom OBLPN packing slip for scanned OBLPN in the “Output interface file UI.”
      • When screen parm “print-packing-slip” is set as “Both” system generates the custom OBLPN packing slip for scanned OBLPN in “Output interface file UI”.
      • Along with the OBLPN packing slip, system generates ORDER Packing Slip w.r.t the configuration mentioned below.
  5. From RF Print Packing Slip (Module: rf.outbound.cwrfprintlpnpackingslip)
  • When the screen parameter “packing-slip-type” is set as “OB LPN packing”, the system generates the custom OBLPN packing slip for the scanned OBLPN in “Output interface file UI.”
  • When the screen parameter “packing-slip-type” is set as “Both”, the system generates the custom OBLPN packing slip for the scanned OBLPN in the “Output interface file UI”.
  • Along with the OBLPN packing slip, the system generates the ORDER Packing Slip with respect to the configuration mentioned below.

Configure and Generate Custom WebReport for ORDER Packing Slip

  1. From the Web Report UI:
    • Create a web report for category: “Order”.
    • You can also add other categories with Order_HDR ID
  2. From the Company Report Type UI:
    • Report type: ORDER_PACKING
    • “Report Sub Type” = WebReport
    • "web report path" = folder_name\web_report_name ,OR folder_name/web_report_name
    • "Web report format" : select as preference
  3. From theOrder Header View UI:
    • When you select single/multiple records and click on the 'Packing Slip' button, the system generates the custom ORDER packing slip for the selected record(s)
    • PDF format will be displayed in a Dashboard
    • CSV and XLS format will get auto-downloaded
  4. From RF Print Ship Label (Module: rf.outbound.cwrfprintshiplbl)
    • When the screen parameter “print-packing-slip” is set as “Order” system generates the custom ORDER packing slip for the Order associated with the scanned OBLPN in the “Output interface file UI”
    • When the screen parameter “print-packing-slip” is set as “Both”, the system generates the custom ORDER packing slip for the Order associated with the scanned OBLPN in the “Output interface file UI”.
    • Along with the ORDER packing slip, the system generates the OBLPN Packing Slip with respect to the configuration mentioned above
  5. From RF Print Packing Slip (Module: rf.outbound.cwrfprintlpnpackingslip)
    • When the screen parameter “packing-slip-type” is set as “Order LPN packing”, the system generates the custom ORDER packing slip for the Order associated with the scanned OBLPN in “Output interface file UI”.
    • When the screen parameter “packing-slip-type” is set as “Both”, the system generates the custom OBLPN packing slip for the Order associated with the scanned OBLPN in the “Output interface file UI”.
    • Along with the ORDER packing slip, the system generates the OBLPN Packing Slip with respect to the configuration mentioned above.
      Note: The generation of custom OBLPN/Order packing slip might fail:
      • If the web report category is not valid
      • If the web report category has a filter, which doesn’t match the RF scanned/UI selected record(s).

Reports Supported

“Company Report Type” UI supports sub report type “WebReports” for the following reports:

  • OBLPN Packing Slip – Generated by clicking “Packing List” on the OBLPN UI. “OBLPN_PACKING” in “Company Report Type” needs to be configured with the sub report type “WebReports”.
  • Order Packing Slip - Generated by clicking “Packing Slip” button on the Order Header UI. “ORDER_PACKING” in “Company Report Type” needs to be configured with sub report type “WebReports”
  • Task Report – Generated by clicking “Task Reports” on the Wave Inquiry UI. “TASK” in “Company Report Type” needs to be configured with the sub report type “WebReports”.
  • Inbound Receipt Report - Generated by clicking “Inbound Receipt” on the IB Shipment UI. “INBOUND_RECEIPT_REPORT” in “Company Report Type” needs to be configured with the sub report type “WebReports”.
  • Pallet Packing List - Generated by clicking “Pallet Packing List” on the Pallet View UI. “PALLET_PACKING” in “Company Report Type” needs to be configured with the sub report type “WebReports”.
  • Pick Travel Report - Generated by clicking “Pick Travel Report” on the Wave Inquiry UI. “PICK_TRAVEL” in “Company Report Type” needs to be configured with sub report type “WebReports”.
  • Receiving Variance Report - Generated by clicking “Receiving Variance Report” button on the Appointment UI. “RCV” in “Company Report Type” needs to be configured with sub report type “WebReports”
  • BOL - Generated by clicking “Bill of Lading” button on the OB Load UI. “BOL” in “Company Report Type” needs to be configured with sub report type “WebReports”
  • Commercial Invoice - Generated by clicking “Commercial Invoice” on the OB Load UI. “COMM INV” in “Company Report Type” needs to be configured with sub report type “WebReports”.
  • Export Shipment Packing List - Generated by clicking “Export Shipment Packing List” on the OB Load UI. “EXPL” in “Company Report Type” needs to be configured with the sub report type “WebReports”.
  • Shipper’s Export Declaration - Generated by clicking “Shipper’s Export Declaration” on the OB Load UI. “SED” in “Company Report Type” needs to be configured with sub report type “WebReports”
Note: Custom reports designed through WebReports cannot be invoked from RF. (This note is only applicable for reports that can be printed via RF). Also, Custom Reports should not have parenthesis.