Unlocking a Stranded Order or Batch (MULO)
Purpose: Use this menu option to clear the locked status of stranded order or order batch so that you can work with it.
Why are orders and batches locked? CWDirect locks an order or batch when a user or process is working with the order, so that another user or process cannot update the order or batch at the same time.
What does the lock consist of? When a user is entering an order or selects an order for maintenance, or when a function is updating an order, CWDirect locks the order by entering the user’s login ID or the function name in the User field in the Order Header file. Similarly, CWDirect locks an order batch by entering the user’s login ID in the Entry user field in the Order Batch file.
How does an order or batch become stranded? Typically, an order or batch becomes stranded when a user is working with it and the session ends unexpectedly, such as when the workstation shuts down. In this situation, the system does not have an opportunity to clear the user ID from the order or order batch record. Similarly, an order or batch can become stranded if a process that is currently updating the record ends abnormally.
How can you tell when an order or batch is locked?
• Order: You can tell that an order is locked if the system displays the Warning: Order Locked window when you attempt to maintain it. This window indicates the name of the user or process using the order, based on the current entry in the User field in the Order Header file.
Warning: Order Locked
Order # 5227 in use by EKAPLAN
F12=Cancel |
• Batch: You can tell that a batch is locked if a user ID is displayed in the In use by field at the Work with Order Batches Screen.
Unlock Order or Batch Screen
How to display this screen: You can display this screen by entering MULO in the Fast path field at the top of any menu, or by selecting Unlock Order or Batch from a menu.
MSR1438 ENTER Unlock Order or Batch 3/10/04 10:54:06 EZK Mail Order
Order # . . . . . . 7508 or Batch # . . . . . . . Order status . . . : H Batch date . . . : Order date . . . . : 8/21/02 Locked by . . . : Entered date . . . : 8/21/02 Entered time . . . : 10:29:51 Workstation . . . : QPADEV000N Entered by . . . . : EKAPLAN Locked by . . . . : BATCH_OM
Customer # . . . . : 299 JACKRABBIT, OPHELIA
F3=Exit F9=Proceed with unlock |
Field |
Description |
Order # |
To unlock a stranded order, enter the order number here. You can enter either an order number or a batch number. Your entry must identify an order that is currently locked and whose status is not S (suspended) or E (error). Numeric, 8 positions; optional. |
Batch # |
To unlock a stranded batch, enter the batch number here. If your entry in the Order # field was created as part of a batch, the batch number defaults here. You cannot enter both an order number and a batch number. If a batch number has defaulted from the entry of a previous order number, you must clear this field before entering another order number. Numeric, 5 positions; optional. |
Order status |
The current status of the order. Displayed for orders only. Possible statuses are: Blank = Open A = Archived to optical disk C = Canceled E = In error H = Held S = Suspended X = Closed Alphanumeric, 1 position; display-only. |
Batch date |
The date when the batch was created. Displayed only if you enter a batch number, not if a batch number defaults because it is associated with the entered order number. Displayed for batches only. Numeric, 6 positions (MM/DD/YY format); display-only. |
Order date |
The effective date of the order for the purposes of aging and backorder analysis. When you enter an order, the current date defaults, but you can override it. Displayed for orders only. Numeric, 6 positions (MM/DD/YY format); display-only. |
Locked by (order) |
The user ID or process name that was updating the order at the time it became stranded. Displayed for orders only. Alphanumeric, 10 positions; display-only. |
Entered date |
The date when the order was created. Displayed for orders only. Numeric, 6 positions (MM/DD/YY format); display-only. |
Entered time |
The time when the order was created. Displayed for orders only. Numeric, 6 positions (HH:MM:SS format); display-only. |
Workstation |
The ID of the workstation where the user was working when creating the order, or the name of the process that created the order; for example, the workstation is E-COMMERCE for orders created through the e-commerce interface or the Generic Order Interface (Order API). Displayed for orders only. Alphanumeric, 10 positions; display-only. |
Entered by |
The user ID of the person who entered the order, or the name of the process that created the order. For orders created through the generic order API, this is either the entered_by_user specified in the Inbound Order XML Message (CWORDERIN), or *DEFAULT if the entered_by_user is not specified. Displayed for orders only. Alphanumeric, 10 positions; display-only. |
Locked by (batch) |
The user ID or process name that was working with the batch at the time that it became stranded. Displayed for batches only. Alphanumeric, 10 positions; display-only. |
Customer # |
A unique number to identify the customer who placed the order (sold-to customer). Displayed for orders only. Numeric, 9 positions; display-only. |
Customer name (unlabeled field below the customer number) |
The name of the sold-to customer. Displayed for orders only. Alphanumeric, 41 positions; display-only. |
Unlocking an order: Enter the order number and press Enter to display information about the order and confirm that your entry was correct; if so, press F9 to unlock the order. The system clears the User field from the Order Header file, and the order is now available to be maintained by another user.
Unlocking a batch: Enter the batch number and press Enter to display information about the batch and confirm that your entry is correct; if so, press F9 to unlock the batch. The system clears the Entry user field from the Order Batch file, and the batch is now available to be maintained by another user.
Note: If your initial entry is not correct, exit the screen and then re-enter to clear the information from your previous entries from displaying.
| iCAT Electronic Commerce Interface | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Resetting the Order Billing History File (ROBH) |
SO03_11 CWDirect 18.0.x 2018 OTN