Working with Order Broker (WOBR)

Purpose: Use this menu option to review the records and history of all order lines sent to or received from Order Orchestration for shipment or customer pickup. You can also use this menu option to cancel fulfillment of a brokered backorder request to Order Orchestration and leave the order line open, so you can fulfill it from your warehouse using your standard process.

Determining the Order Orchestration type: A Delivery type of retail pickup, delivery, store pickup, or ship-for-pickup is indicated on the Display Order Broker Screen. The Delivery type at this screen is blank for a brokered backorder. This screen is available by selecting Display for an Order Orchestration record at the Work with Order Broker screen.

Both originating and fulfilling orders listed: If the Use OROB for Fulfillment Assignment (M31) system control value is selected, both the originating order submitted to Order Orchestration and the fulfilling order assigned in Order Administration to fulfill it are included in these totals.

Example: Order 12345 was submitted to Order Orchestration for assignment, and Order Orchestration submitted the order to Order Administration to fulfill from the warehouse. Order Administration created order 12346 to fulfill order 12345. Lines from both order 12345 and 12346 are listed with their respective statuses.

For more information: See the Order Orchestration Integration for an overview.

In this topic:

Work with Order Broker Screen

How to display this screen: Enter WOBR in the Fast path field at the top of any menu, or select Work with Order Broker from a menu.

Column sort: You can sort on any column except Line # on this screen by clicking on the column name. An arrow pointing up displays next to the field when the values for the field display in ascending sequence; an arrow pointing down displays next to the field when the values for the field display in descending sequence.

When you first advance to this screen, Order Orchestration records display in ascending create date, order number sequence.

Field Description

Status

The current status of the Order Orchestration request. Possible statuses are described at the Order Orchestration Status Summary Table.

Search: Select a status and select OK to display Order Orchestration records that match your entry.

Create date

The date when the Order Orchestration request was created.

Search: Enter a date and select OK to display Order Orchestration records that match your entry.

Numeric, 6 positions (user date format); optional.

Order #

The order number and ship-to number that originated a brokered backorder, store pickup, or ship-for-pickup order, or was created as a result of a retail pickup or delivery request. The ship-to number is set to 1 if there is a single shipping address.

Note:

Ship-for-pickup orders are not listed here until you generate a pick slip and Order Administration submits the order to Order Orchestration.

Search: Enter an order number and select OK to display Order Orchestration records that match your entry.

Order number: numeric, 8 positions; optional.

Ship-to number: numeric, 3 positions; optional.

Line #

The sequence number in the Order Detail table that identifies the order line to be fulfilled through the Order Orchestration integration. The sequence number might differ from the order line number displayed in order maintenance or order inquiry if, for example, you deleted one of the previous lines on the order.

Numeric, 5 positions; optional.

Item/SKU

The item to be fulfilled through Order Orchestration. If the item has SKU’s, the SKU code also displays.

Search: Enter a valid item number and select OK to display Order Orchestration records that contain your entry. If the item has SKU’s, you can search on item number only.

Alphanumeric, 12 positions; optional.

Qty

The current quantity to be fulfilled at the Fulfilling location. Displayed regardless of status.

Numeric, 5 positions; display-only.

Fulfilling location

See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Search: Enter a full or partial fulfilling location code and select OK to display Order Orchestration records that contain your entry.

Alphanumeric, 50 positions; optional.

Request ID

A unique ID number assigned by Order Orchestration to identify the order. If the Use Split Order (L56) system control value is:

  • unselected: each individual brokered backorder item submitted to Order Orchestration receives a unique request ID, and Order Orchestration treats it as a separate order.

  • selected: Order Administration sends a single submit order request for all backordered lines that are eligible for brokering.

The Use Split Order (L56) system control value does not affect how Order Administration creates or processes ship-for-pickup, retail pickup, delivery, or store pickup orders.

The request ID is blank for requests whose status is:

  • Z: Canceled

  • C: Closed

  • J: Rejected

  • R: Ready

  • W: Waiting

The field might also be blank for requests in E (Error) status, depending on the nature of the error. For example, requests that Order Orchestration did not receive and create successfully are not assigned request ID’s.

Although the field in Order Administration is up to 25 positions, Order Orchestration does not support a request ID longer than 10 positions.

Search: Enter a valid request ID and select OK to display Order Orchestration records that match your entry.

Numeric, 25 positions; optional.

Option Procedure

Display details of an Order Orchestration request

In the Action field, select Display to advance to the Display Order Broker Screen.

Review history for an Order Orchestration request

In the Action field, select History to advance to the Display Order Orchestration History Screen.

Cancel an Order Orchestration request

In the Action field, select Cancel to cancel a brokered backorder and return the order line to standard backorder processing. See Canceling a Brokered Backorder Request for more information.

Note:

  • To cancel both the Order Orchestration request and the order line itself, use the cancel option in order maintenance. See the discussion under Canceling a Brokered Backorder Request for background.

  • The Cancel option is available only for brokered backorders, only if you have authority under the Cancel Order Broker Lines (B19) secured feature, and only if the Order Orchestration request is in a status eligible for cancellation (not closed, shipped, canceled, cancel pending, unfulfillable or error).

Print the Order Orchestration Aging Report

Select Print to advance to the Print Aging Report Window. See Printing the Order Orchestration Aging Report for more information.

Display Order Broker Screen

Purpose: Use this screen to review details about an Order Orchestration request.

How to display this screen: Select Display in the Action field for a record at the Work with Order Broker Screen.

Field Description

Order #

The order number that originated the brokered backorder, store pickup, or ship-for-pickup, or that was created as a result of the retail pickup or delivery request. The order number is separated from the ship-to number by a hyphen.

Numeric, 8 positions; display-only.

Ship To #

The order ship to number that originated the brokered backorder, store pickup, or ship-for-pickup, or that was created as a result of the retail pickup or delivery request. The order number is separated from the ship-to number by a hyphen.

Numeric, 3 positions; display-only.

Line #

The sequence number in the Order Detail table that identifies the order line to be fulfilled through the Order Orchestration integration. The sequence number might differ from the order line number displayed in order maintenance or order inquiry if, for example, you deleted or canceled one of the previous lines on the order.

Numeric, 5 positions; display-only.

Item/SKU

The item and SKU fulfilled through the Order Orchestration integration.

Item: alphanumeric, 12 positions; display-only.

SKU: alphanumeric, three 4-position fields; display-only.

Description

A description of the item. If the item has SKUs, the SKU description displays.

Alphanumeric, 120 positions (item) or 40 positions (SKU); display-only.

Order qty

The ordered quantity for the order detail line. This field is used for all order types.

Numeric, 5 positions; display-only.

Qty

The quantity of a brokered backorder line that is currently assigned to Order Orchestration for fulfillment, or has been fulfilled or canceled. Might be less than the ordered quantity if this is a brokered backorder, the Use Split Order (L56) system control value is selected, and the Allow Split Order and Allow Split Line preferences in Order Orchestration are also selected. See the Use Split Order (L56) system control value for a discussion.

Numeric, 5 positions; display-only.

Status

The current status of the Order Orchestration request. The description is to the right. Possible statuses are described at the Order Orchestration Status Summary Table.

Alphanumeric, 1 position; display-only.

Create date

The date when the Order Orchestration request was created.

Numeric, 6 positions (user date format); display-only.

Create time

The time when the Order Orchestration request was created.

Numeric, 6 positions (HH:MM:SS format); display-only.

Last request date

The last date when Order Administration sent an order or status request to Order Orchestration.

Numeric, 6 positions (user date format); display-only.

Last request time

The last time when Order Administration sent an order or status request to Order Orchestration.

Numeric, 6 positions (HH:MM:SS format); display-only.

Request ID

A unique ID number assigned by Order Orchestration to identify the order. If the Use Split Order (L56) system control value is:

  • unselected: each individual brokered backorder item submitted to Order Orchestration receives a unique request ID, and Order Orchestration treats it as a separate order.

  • selected: Order Administration sends a single submit order request for all backordered lines that are eligible for brokering.

The request ID is blank for requests whose status is:

  • Z: Canceled

  • C: Closed

  • J: Rejected

  • R: Ready

  • W: Waiting

The field might also be blank for requests in E: Error status, depending on the nature of the error. For example, requests that Order Orchestration did not receive and create successfully are not assigned request ID’s.

Numeric, 30 positions; display-only.

Originating location

See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Alphanumeric, 50 positions; optional.

Fulfilling location

See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Alphanumeric, 50 positions; optional.

Pickup location

See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Alphanumeric, 50 positions; optional.

Broker delivery type

The type of order:

Option Procedure

Review history for the Order Orchestration request

Select History to advance to the Display Order Orchestration History Screen.

Display Order Orchestration History Screen

Purpose: Use this screen to review the order, status, and cancel requests sent from Order Administration to Order Orchestration, and the responses received. History is listed in chronological order (oldest to newest).

Not included in this history:

  • Fulfillments request and response messages

  • SubmitOrder request and response messages for store pickup or ship-for-pickup orders

  • Changes to a brokered backorder’s Under Review flag that can occur if the Send Held Orders to OROB (M18) system control value is selected

How to display this screen: Select History in the Action field for a record at the Work with Order Broker Screen, or select History at the Display Order Broker Screen.

Field Description

Order #

The order number and ship-to number related to the Order Orchestration request. The order number is separated from the ship-to number by a hyphen.

Order number: numeric, 8 positions; display-only.

Ship-to number: numeric, 3 positions; display-only.

Line #

The sequence number in the Order Detail table that identifies the order line to be fulfilled through the Order Orchestration integration. The sequence number might differ from the order line number displayed in order maintenance or order inquiry if, for example, you deleted or canceled one of the previous lines on the order.

Numeric, 5 positions; display-only.

Item/SKU

The item and SKU to be fulfilled through the Order Orchestration integration.

Item: alphanumeric, 12 positions; display-only.

SKU: alphanumeric, three 4-position fields; display-only.

Item/SKU description (unlabeled field to the right of the Item/SKU)

The description of the item and SKU. This field displays up to 52 positions; however, if the SKU description is truncated, you can display the rest by putting your cursor in the field and advancing it to the right.

Item description: alphanumeric, 120 positions; display-only.

SKU description: alphanumeric, 40 positions; display-only.

Order qty

The ordered quantity for the order detail line. This field is used for all order types.

Numeric, 5 positions; display-only.

Originating Location

See Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Alphanumeric, 50 positions; optional.

Pickup Location

See Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Alphanumeric, 50 positions; optional.

For each Order Orchestration History record:

 

Date/Time

The date and time when the request was sent to Order Orchestration, or when the response was received in Order Administration.

There might be a difference between the time of the Send Status Request and Receive Status Response activities, because the status list request can include up to 1000 records, resulting in a delay between generating the request and processing the response for an individual order line.

Date: numeric, 6 positions (user date format); display-only.

Time: numeric, 6 positions (HH:MM:SS format); display-only.

Transaction type

The type of activity that occurred. Possible transaction types are:

A - Send Order Request = Order Administration sent the initial submit order message to Order Orchestration (brokered backorders).

B - Receive Order Response = Order Administration received the order response message from Order Orchestration (brokered backorders).

C - Send Status Request = Order Administration sent an request to Order Orchestration to inquire about the order’s current status.

D - Receive Status Response = Order Administration received the status inquiry response message from Order Orchestration.

M - Maintenance Transaction = You canceled the brokered backorder or store pickup request. You can cancel a brokered backorder either through order maintenance, or by canceling the Order Orchestration request itself (but not the order line) at the Work with Order Broker Screen; however, you can only cancel a store pickup request through order maintenance.

E - Send Update Request = Order Administration sent a status update request message to Order Orchestration.

F - Receive Update Response = Order Administration received the status update response message from Order Orchestration.

See Sample Order Orchestration Messages for examples of the different messages generated or received by Order Administration as part of the Order Orchestration integration.

Alphanumeric, 25 positions; display-only.

Status

The current status of the Order Orchestration request. The description is to the right. Possible statuses are described at the Order Orchestration Status Summary Table.

Alphanumeric, 1 position; display-only.

Fulfilling location

See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Alphanumeric, 50 positions; optional.

Qty

The quantity of the Order Orchestration line at the time of the activity. Might be less than the ordered quantity if this is a brokered backorder, the Use Split Order (L56) system control value is selected, and the Allow Split Order and Allow Split Line preferences in Order Orchestration are also selected. See the Use Split Order (L56) system control value for a discussion.

Numeric, 5 positions; display-only.

OROB Ln #

The sequence number in the Order Detail table that identifies the order line to be fulfilled through the Order Orchestration integration. The sequence number might differ from the order line number displayed in order maintenance or order inquiry if, for example, you deleted or canceled one of the previous lines on the order.

Numeric, 5 positions; display-only.

Error

The error, if any, received from Order Orchestration. The error message is truncated if it exceeds 30 positions. An error of Null response from OROB indicates that the OROB Account (K49) system control value is not set correctly.

See Troubleshooting the Order Orchestration Integration and the Order Orchestration Operations Guide for more information on possible errors.

Alphanumeric, 30 positions; display-only.

Canceling a Brokered Backorder Request

Overview: Your options in canceling a brokered backorder request in Order Administration are:

Cancel the brokered backorder request and reassign fulfillment: to return the order line to standard backorder and fulfillment processing in Order Administration, use the cancel option from the Work with Order Broker Screen.

Cancel both the brokered backorder request and the order line itself: to prevent the order line from shipping to the customer, use the:

Important:

  • Before canceling a brokered backorder request, it is important to confirm that the assigned fulfilling location is not in the process of shipping it. Even if the current status in Order Administration indicates that the order is not in the process of fulfillment, depending on the setting of the Order Broker Status Update Interval (K10) this information could be out of date.

  • If the Use OROB for Fulfillment Assignment (M31) system control value is selected you can cancel the delivery order that was created to fulfill the originating broker backorder. In this situation, the system changes the Order Orchestration record’s status to Canceled and sends a status inquiry request to Order Orchestration. See Canceling an Item in Order Maintenance for more information.

  • If you broker ship-for-pickup orders for fulfillment assignment (the Use OROB for Ship for Pickup Fulfillment Assignment (M34) system control value is set to ALWAYS and the Send B/O to OROB (K08) system control value is selected), when you cancel a ship-for-pickup order, the system sends an update to Order Orchestration so that the order can be updated to canceled. In addition, if a retail pickup order was created in Order Administration to fulfill the ship-for-pickup order, when you run pick slip generation for the retail pickup order, the system does not generate a pick slip and assigns the hold reason defined in the Order Broker Hold Reason (Cancel) (L02) system control value to the order. The system also writes an order transaction history message for the retail pickup order: Order held - line(s) canceled in Order Orchestration.

Secured feature: The Cancel Order Broker Lines (B19) secured feature controls the authority to cancel a brokered backorder. If you do not have authority under this secured feature:

  • the Cancel option is not available at the Work with Order Broker Screen

  • you cannot cancel a brokered backorder line in order maintenance

  • if you select the Cancel Order option in order maintenance, Order Administration does not cancel any brokered backordered lines and displays an error message: Not authorized to cancel Order Broker line.

Note:

You cannot use the e-commerce cancel request message to cancel a backordered line assigned to Order Orchestration. See E-Commerce Cancel Process for background.

Confirm Order Orchestration Cancel Window

How to display this window: Select Cancel for:

  • an Order Orchestration request at the Work with Order Broker Screen

  • in order maintenance:

    • a backordered order line assigned to Order Orchestration

    • an order that includes a backordered order line assigned to Order Orchestration

Cancel option available? The Cancel option is available only if you have authority under the Cancel Order Orchestration Lines (B19) secured feature and if the Order Orchestration request has not already been shipped or submitted for cancellation, it is not in error, and Order Orchestration has not indicated that it is unfulfillable.

Field Description

Status

The current status of the Order Orchestration request.

Note:

The BROKER IJCT job no longer calls the OOCS Status List request message for the latest status where the brokered status is still considered open. Instead, a web service is used to accept status updates from OOCS real-time. After each status update is complete in OOCS, a new Status Update message is sent immediately to OACS giving the current Quantity and Status of every line that was sent in the Status Update request.

A brokered backorder request is eligible for cancellation only if its status is:

  • A - Accepted = The assigned fulfilling location has accepted the order.

  • K - Acknowledged = Order Orchestration has received the order request, assigned a request ID, selected a fulfilling location, and created the order in its database.

  • P - Polled = The assigned fulfilling the location has polled Order Orchestration for new orders and been notified of this order.

  • R - Ready = The request is ready to be sent to Order Orchestration, but the BROKER process has not yet generated the request message.

  • W - Waiting = The order request message has been sent to Order Orchestration, but Order Administration has not yet received the response.

Item/SKU

The backordered item and SKU to be fulfilled through Order Orchestration.

Item: alphanumeric, 12 positions; display-only.

SKU: alphanumeric, three 4-position fields; display-only.

Fulfilling location

The code identifying the store location assigned to fulfill the backorder. In the case of a retail pickup or delivery order, this is the Order Administration warehouse. See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Alphanumeric, 50 positions; optional.

Completing this screen: Click OK to submit.

Updates at accept: When you confirm the cancellation:

  • An Order Orchestration History message tracks the activity. The Transaction type is M - Maintenance Transaction.

  • The order detail line is updated immediately. If you cancel the Order Orchestration request but not the order line itself, the Drop ship flag and Printed quantity are cleared, and the order line returns to standard backorder processing.

  • Order Orchestration status change:

    • If the order has not yet been sent to Order Orchestration (the status of the Order Orchestration request is R (ready), the status of the Order Orchestration request changes to C (closed). No further updates take place.

    • If the order has been sent to Order Orchestration (the status of the Order Orchestration request is W (waiting), K (acknowledged), P (polled), or A (accepted): the status of the Order Orchestration request changes to Y (pending cancel). Once the BROKER job receives confirmation of the cancellation from Order Orchestration, it changes the status of the Order Orchestration request to Z (canceled), and writes an Order Transaction History message (for example, Ln#: 2 Cancel Acknowledged by Broker).

Status update message: The status update message includes the cancel reason code and description. See the Order Status Update Cancel Request Message Sample (Brokered Backorder or Store Pickup) for information about the fields submitted to Order Orchestration for the cancellation of a brokered backorder.

Printing the Order Orchestration Aging Report

Purpose: Use the Order Orchestration Aging Report to review order lines that have been assigned to Order Orchestration for fulfillment.

Print Aging Report Window

How to display this window: Select Print at the Work with Order Broker Screen.

Field Description

Status

The BROKER job no longer calls the OOCS Status List request message for the latest status where the brokered status is still considered open. Instead, a web service is used to accept status updates from OOCS real-time.

Optionally, select a status to include Order Orchestration records that are currently in this status, or leave this field unselected to include records regardless of status. Statuses that are eligible for selection are:

  • A (Accepted) = Brokered backorder or store pickup: The location assigned to fulfill the order has accepted it.

  • F (Picking) = Retail pickup, delivery, or ship-for-pickup: The pick slip has been printed. (Status in Order Orchestration is New_Order or Picked).

  • G (Resend Fulfilled) = Delivery: The Order Status Update request message to change the status in Order Orchestration to fulfilled did not generate a response message from Order Orchestration, possibly because message authentication failed or communication is down. In this case, the BROKER_ORD job re-sends the Order Status Update request the next time it runs.

  • H (Resend Intransit) = Ship-for-pickup: The Order Status Update request message to change the status in Order Orchestration to intransit did not generate a response message from Order Orchestration, possibly because message authentication failed or communication is down. In this case, the BROKER_ORD job re-sends the Order Status Update request the next time it runs.

  • I (In Process) = Retail pickup or delivery: The order was received from Order Orchestration and created without error. (Status in Order Orchestration is Accepted.)

  • J (Rejected) =

    • Retail pickup or delivery: The order was sold out after creation in Order Administration.

    • Store pickup: The selected store location has rejected the order.

  • K (Acknowledged) = Brokered backorder or store pickup: Order Orchestration has received the order request, assigned a request ID, selected a fulfilling location, and created the order in its database. (Status in Order Orchestration is New_Order.)

  • L (Partial Fulfill) = Retail pickup, ship-for-pickup, or store pickup: The customer has picked up one or more items on the order, but not the complete order. (Status in Order Orchestration is Partially Fulfilled.)

  • N (New) = Retail pickup or delivery: The order was received from Order Orchestration but is in error. (Status in Order Orchestration is Polled.)

  • O (Posted) = Brokered backorder, store pickup, or ship-for-pickup: Order Orchestration has submitted the order or order line for enterprise fulfillment. See Enterprise Order Integration (Future Receipts and Active PO/Pre-Order Processing) for background.

  • P (Polled) = Brokered backorder or store pickup: The assigned fulfilling location has polled Order Orchestration for new orders and been notified of this order. (Status in Order Orchestration is Polled.)

  • R (Ready) =

    • Brokered backorder: The request is ready to be sent to Order Orchestration, but the BROKER process has not yet generated the request message.

    • Store pickup: Order Administration attempted to send the order to Order Orchestration, but Order Orchestration has not responded. In this case, Order Administration retains the order information in the Store Pickup tables until communication with Order Orchestration resumes.

  • S (Received by Store) = Retail pickup or ship-for-pickup: The order has been received by the store location but not yet picked up by the customer. (Status in Order Orchestration is Received.)

  • T (In Transit) = Retail pickup or ship-for-pickup: You have confirmed shipment of the order to the store. (Status in Order Orchestration is Intransit.)

  • W (Waiting) = Brokered backorder: The request message has been sent to Order Orchestration, but the response has not yet been received.

  • Y (Pending Cancel) =

    • Brokered backorder: You have canceled the order line (including the Order Orchestration request), or you have canceled just the Order Orchestration request at the Work with Order Broker Screen, but you have not yet received a confirmation of the cancellation from Order Orchestration.

    • Store pickup: You have canceled the order through order maintenance, but have not yet received the confirmation of the cancellation from Order Orchestration.

Note:

You cannot include Order Orchestration records on the report if their status is Unfulfillable (U), Closed (C), Completed (X), or Error (E).

Optional.

Fulfilling location

Optionally, select a single store location, or leave this field blank to select records regardless of fulfilling location. This information is from Work with Store Cross Reference (WSCR). See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion.

Alphanumeric, 50 positions; optional.

Older than

Optionally, enter a number of days to have the report include Order Orchestration records only if their age exceeds this number, or leave this field set to 00000 to select records that are at least two days old.

Note:

It is not possible to include Order Orchestration records from the current or previous day on the report. Only records that are at least two days old are eligible for selection.

Numeric, 5 positions; optional.

Note:

The Order Orchestration Aging Report is accessible at the Document Management Screen. It is not available by selecting a submitted job at the Job Management Screen.