Reviewing Order Inquiry Detail Information

Purpose: Depending on how the Default Version for Order Inquiry (C34) system control value is set, you advance to the Order Inquiry Header Screen or Order Inquiry Detail Screen when you select a quote or order to review.

This topic assumes that you advance first to the DETAIL screen for Order Inquiry; however, you can also advance to this screen from the Order Inquiry Header Screen by selecting OK.

The Order Inquiry Detail screen gives you access to quote or order information at the item level. Use this screen when you need to review individual items, their reservation status, order messages, history, and other information on a specific item.

Streamlined order inquiry: As an alternative to standard order inquiry, the Streamlined Order Inquiry (DORI) option provides a consolidated, one-page view of the order, including information on the order details.

In this topic:

Not in this topic: This topic does not discuss the function keys displayed at the side of this screen. These options, common to both the Order Inquiry header and detail screens, are described in Options Available in Order Inquiry.

Order Inquiry Detail Screen

Purpose: This screen highlights the items on the quote or order. You cannot modify any fields on this screen.

How to display this screen:

Select a quote or order at an order inquiry scan screen; Using the Order Inquiry Scan Screens (OIOM)
Select Order Inquiry for a held order at a Release Held Orders Screen (Working with Releases)
Select Order Inquiry at the Work with Returns for Order Screen in Work with Return Authorizations (streamlined version)
Select Ord Inq for a refund at the Work with Refunds Screen
Select Order Inquiry at the Work with Order Broker Screen
Select an order for review at the Pending Order Details Screen

Originating order message: If the E-Commerce order number in the Order Header Extended table begins with the text ORIG#:, indicating the originating system for a retail pickup or delivery order is Order Administration, the message This order is fulfilling another order: 9999-001 displays for the sourcing order, where 9999 is the originating order number in Order Administration, and 001 is the ship to number. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for more information.

Additional fields: See Reviewing the Order Inquiry Header Screen for descriptions of the additional fields on this screen.

Field	Description
Whse (Warehouse)	The code for the warehouse this item shipped from, if the order entry operator selected a warehouse other than the one the system assigned; otherwise, the warehouse code is zero. You can review the actual warehouse code on the Display Order Detail Screen (Reviewing Order Line Detail); however, the warehouse code does not appear on this screen either until the order has been shipped. Numeric, 3 positions; display-only.
Ln #	A number the system assigns to each item as it is added to the order. The Order Inquiry detail screen displays lines in descending numeric sequence by line number so that the most recently entered item appears first. A quote or order can have up to 999 lines. The code RTN appears below the line number if there has been a return against the order line. The code EXC appears below the line number if there has been an exchange against the order line. The system identifies an order detail line as containing an exchange item if an associated Order Line History record contains an exchange reason code. You can review order line history on the Display Order Line History Screen. Numeric, 3 positions; display-only.
S (Status)	A one-position code indicating the current status of the item on the order. Possible statuses are: blank = The order line is currently open. Express Bill = You have entered the order using an express-bill ship via, but the BILL_ASYNC process has not yet processed the invoice. See Working with the BILL_ASYNC Job for background. Cancelled = You have canceled the item using a cancel reason code that is not flagged to reduce demand. See Establishing Cancel Reason Codes (WCNR) for background on cancel reason codes. Error = The order line is currently flagged with an error, and the order is suspended in an order batch. See Order Creation Errors for background. Held = The order line is currently held. You can hold a line on an open order to prevent it from printing on a pick slip, even if it is available. Soldout = The item has been sold out. An order line can be sold out: manually in order entry or maintenance through the Sell Out option automatically in order entry or maintenance, based on the soldout control code assigned to the item through the Process Auto Soldouts option See Managing Soldouts and Backorders for background. Closed = The item has been shipped, canceled with a cancel reason flagged to reduce demand, or partially shipped and the remainder of ordered quantity canceled. Display-only.
Item #	A code that identifies a unit of inventory. Item codes are defined in and validated against the Item table. Note: An item alias is displayed if the customer ordered using an alias and the Display Item Alias (D56) system control value is selected. Alphanumeric, 12 positions; display-only.
SKU (Stock keeping unit)	An item's unique characteristics, such as its size and color. The first 14 positions of the SKU description defined at the Create SKU 1 of 2 (With Overrides) Screen are displayed in place of the SKU elements if the Display SKU Description in place of SKU Element (F25) system control value is selected. Alphanumeric, three 4-position fields; display-only.
H (Handling)	Represents the type of special handling for the item. Handling codes are defined in and validated against the Additional Charge Codes table. See Establishing Additional Charge Codes (WADC). Alphanumeric, 2 positions; display-only.
Ord (Ordered)	The number of units of an item the customer ordered. Numeric, 5 positions; display-only.
Rsv (Reserved)	The quantity of the item that the system has reserved from stock. The system does not reserve stock on quotes until they are converted to standard orders; see Converting Quotes to Orders. The reserved quantity is reduced when an item is canceled, confirmed for shipment, or unreserved using Interactive Reservation. The system updates this quantity at billing. Numeric, 5 positions; display-only.
Shp (Ship)	The number of units that have shipped. The system updates this quantity at billing. If an item has shipped, the shipping date displays below this number. Numeric, 5 positions; display-only.
Prt (Print)	The number of units included on a printed pick slip. Pre-generated picks: The system does not update this field when you create a pre-generated pick for the order line during pick slip preparation; the system updates this quantity when you generate a pick slip. See Applying Pick Slip Preparation to an Order and Performing Pick Slip Generation. Voiding a pick slip: The system reduces the printed quantity if you void the pick slip and don't reprint, or when shipment of the item is confirmed. Order Orchestration? For a brokered backorder or a store pickup order line that has been selected for fulfillment through integration with Order Orchestration, the print quantity is equal to the ordered quantity unless a shipment or pickup has already taken place, the order line has been canceled, or a partial quantity of the line is unfulfillable through Order Orchestration (brokered backorders only). See Brokered Backorders or Store Pickup Orders for an overview. Numeric, 5 positions; display-only.
Price	The unit price of the line. The item price is highlighted in a different color if the price represents a discount over the regular offer price for the item, and if the Display Order Line Discount Messages (F01) system control value is selected. However, the system does not highlight the price if the price was overridden on the detail line, and: no item/SKU offer price exists, or the price override reason code’s Override item offer price is selected. See Overriding the Item/SKU Offer Price for more information on the effects of the Override item offer price field. Note: The setting of the Override item offer price field has no effect on orders you receive through the e-commerce interface. If there is a price override reason code in the new order message, the system always processes these orders as if the field is unselected. Numeric, 13 positions with a 2-place decimal; display-only.
Brokered? (unlabeled field below the Ln#)	Order Orchestration? The line is flagged as: OBR if the order line: has been assigned to Order Orchestration for fulfillment (brokered backorder) has been assigned to Order Administration for fulfillment by the Order Broker (retail pickup or delivery) ships to a store location, where the customer picks it up (ship-for-pickup) a return or exhange has not been processed against the line; in this situation, RTN or EXC displays instead SPU if the customer is picking up the order at a retail store location where the inventory is already available (store pickup) and a return or exhange has not been processed against the line (in this situation, RTN or EXC displays instead) Note: The OBR or SPU flag remains on the order line even if the line has been fulfilled, canceled, or rejected by the fulfilling store location. For a brokered backorder or a store pickup order line that has been selected for fulfillment through integration with Order Orchestration: the print quantity is equal to the ordered quantity unless a shipment or pickup has already taken place, or a partial quantity of the line is unfulfillable through Order Orchestration (brokered backorders only) if the order line has not yet been fulfilled, the Drop ship flag for the order line is set to D
	Reviewing Order Orchestration details: You can select D/S Status for the item to advance to the Display Order Broker Details Screen and review information about a brokered backorder line, or a line on a retail pickup, delivery, ship-for-pickup, or store pickup order. This option is available whenever there is a related Order Orchestration record in Order Administration, regardless of whether the line has been fulfilled or canceled, or rejected by the fulfilling store location. Note: If the order line on a retail pickup, delivery, or ship-for-pickup order is also fulfilled through integration with Order Orchestration’s Supplier Direct Fulfillment module, and the drop ship information has already been sent to Order Orchestration, you advance first to the Display P/O Drop Ship Screen. From that screen, you have the option to advance to the Display Order Broker Details Screen. See Order Orchestration Integration for background. Alphanumeric, 3 positions; display-only.
Item description (unlabeled field below the item code)	The description of the item. Alphanumeric, 120 positions; display-only.
Expected ship date	Backordered item: the date a purchase order for this backordered item is expected. Note: This field is not displayed for a reserved item, or if there are no open purchase orders for the item. Drop ship item, including brokered item: This date is displayed for drop ship items if the Assign Drop Ship Expected Ship Date (I59) system control value is selected. See that system control value for more information. Numeric, 6 positions (in user date format); display-only.
Invoice date	The most recent date when you billed for shipment on this order detail line. This field is blank for order detail lines that have not yet shipped. Numeric, 6 positions (in user date format); display-only.
Extended price	The extended price of the line, calculated as: `Unit price x Order quantity = Extended price` Numeric, 20 positions with a 2-place decimal; display-only.

See Options Available in Order Inquiry for a listing of all functions and options available.

Screen Option	Procedure
Review line details	Select Display for an item to advance to the Display Order Detail Screen (Reviewing Order Line Detail).
Review a page or document associated with an order detail line	Select Attached Link for an item to advance to the Display Hyperlink Screen. This screen is available only if a link for the order detail line was passed in the Inbound Order XML Message (CWORDERIN). For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).
Review coupon discounts	Select Coupons for an item to advance to the Coupon Discount Window. You cannot change any information on this screen.
View Order Orchestration drop ship status information about a purchase order detail line	Select D/S Status for an item to advance to the Display P/O Drop Ship Screen, if: the item is a drop ship item, and you use the Order Orchestration interface to process drop ship items for this vendor (see Drop ship output), and you have already sent the drop ship purchase order to Order Orchestration’s Supplier Direct Fulfillment module Both drop ship and fulfilled through Order Orchestration? If this is a delivery, retail pickup, or ship-for-pickup order and the item is fulfilled through drop ship integration with Order Orchestration as described above, you advance first to the Display P/O Drop Ship Screen, with an option to advance to the Display Order Broker Details Screen.
Review the Order Orchestration information for any order line being fulfilled through the integration with the Order Orchestration Integration	Select D/S Status for an item to advance to the Display Order Broker Details Screen, if: the item has been submitted to Order Orchestration for fulfillment (brokered backorder), or the customer picks up the order up at a retail location where the inventory is available (store pickup), or the order was assigned to Order Administration for fulfillment (retail pickup or delivery), or the order ships to a store location, where the customer picks it up (ship-for-pickup), and a pick slip or drop ship pick slip or purchase order has already been generated for the order line See Order Orchestration Integration. Both fulfilled through Order Orchestration and drop ship? If this is a delivery, retail pickup, or ship-for-pickup order and the item is fulfilled through integration with Order Orchestration’s Supplier Direct Fulfillment module, you advance first to the Display P/O Drop Ship Screen, with an option to advance to the Display Order Broker Details Screen.
Review stored value cards	Select SVC for an item to advance to the Display Stored Value Cards Screen if the item is a stored value card item (SVC type is P, E, or V). An error message indicates if the item on the order line is not a stored value card or the stored value card has not yet been billed: `SVC do not exist for this item/SKU`.
Review history	Select History for an item to advance to the Display Order Line History Screen.
Review order line messages	Select Messages for an item to advance to the Work with Order Line Messages Screen.
Review reserved lines	Select Reserved lines for an item to advance to the Display Reserved Order Lines Screen.
Review special handling	Select Special Handling for an item to advance to the Display Special Handling Screen or the Display Custom Special Handling Screen.
Review zone reservation dates	Select Zone Resv for an item to view the Display Zone Reservation Dates Window.

Scan Order Detail Screen

Purpose: Use this screen to review detail information in a simple tabular format. This format allows more items to display on the screen at one time, and can make it easier for you to scan certain types of information quickly.

How to display this screen: Select Scan Lines at the Order Inquiry Detail Screen. Also, if the Default Version for Order Inquiry (C34) system control value is blank, you advance to this screen when you:

Select a quote or order at an order inquiry scan screen; Using the Order Inquiry Scan Screens (OIOM)
Select Sold To at the Order Inquiry Detail Screen
Select Release for a held order at a Release Held Orders Screen (Working with Releases)
Select Order Inquiry at the Work with Returns for Order Screen in Work with Return Authorizations (streamlined version)
Select Ord Inq for a refund at the Work with Refunds Screen
Select Order Inquiry at the Work with Order Broker Screen
Select an order for review at the Pending Order Details Screen

Field descriptions: See Order Inquiry Detail Screen and Reviewing the Order Inquiry Header Screen for each field not described.

Field	Description
Inv dt (Invoice date)	The date when the item was billed. Numeric, 6 positions (in user date format); display-only.
Rtn (Returned quantity)	The quantity of the item that has been returned. Numeric, 5 positions; display-only.

Field

Description

Inv dt (Invoice date)

The date when the item was billed.

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

Rtn (Returned quantity)

The quantity of the item that has been returned.

Numeric, 5 positions; display-only.

Available options: Select Detail at this screen to display the Order Inquiry Detail Screen. See Options Available in Order Inquiry for information on the remaining function keys.

Display Order Broker Details Screen

Purpose: Use this screen to review the details of an order line that:

was backordered and submitted to Order Orchestration for fulfillment (brokered backorder), even if the line was not fulfilled through Order Orchestration and has returned to standard warehouse processing or has shipped, or is on an order that:
- originated in Order Administration, and the customer picks up at a store location where the merchandise is already available (store pickup order), or
- originated in Order Administration, and ships to a store location where the customer picks it up (ship-for-pickup order), or
- Order Orchestration sent to Order Administration for shipment directly to the customer (delivery order), or
- Order Orchestration sent to Order Administration for shipment to the originating store location, where the customer picks it up (retail pickup order)

Each field on this screen is display-only.

Note:

This screen does not display activity related to changing the setting of the order’s Under Review flag in Order Orchestration based on the order’s hold status in Order Administration, although the Display Order History Screen does display a related message. This activity can occur if the Send Held Orders to OROB (M18) system control value is selected; see that system control value for a discussion.

For more information: See the Order Orchestration Integration for background on different types of orders fulfilled through integration with Order Orchestration’s Order Orchestration module.

How to display this screen: Select D/S Status for an order line at the Order Inquiry Detail Screen. This option is available only for items fulfilled through integration with Order Orchestration (flagged on the Order Inquiry Detail Screen as OBR or SPU).

If the order line is fulfilled through integration with Order Orchestration’s Supplier Direct Fulfillment module: You advance first to the Display P/O Drop Ship Screen, with an option to advance to the Display Order Broker Details screen, if:

this is a delivery, retail pickup, or ship-for-pickup order, and
the item is fulfilled through integration with Order Orchestration’s Supplier Direct Fulfillment module, and
Order Administration has already sent the purchase order information to Order Orchestration

To display this screen from the Display P/O Drop Ship Screen, select Order Broker Detail.

Note:

If you advance to this screen by selecting Order Broker Detail at the Display P/O Drop Ship screen, you return to the Display P/O Drop Ship screen when you exit this screen.

Field	Description
Order #	A unique number the system assigns to identify the order. The ship-to number is to the right, separated by a hyphen. Order number: numeric, 8 positions. Ship-to number: numeric, 3 positions.
Line #	A number the system assigns to each item as it is added to the order. Numeric, 3 positions.
Broker delivery type	Indicates the type of order: blank = brokered backorder. See Brokered Backorders for background. DELIVERY: See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for background. RETAIL PICKUP: See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for background. SHIP FOR PICKUP: See Ship-for-Pickup Orders for background. STORE PICKUP: See Store Pickup Orders for background.
Originating Location	The location originally assigned to fulfill the order. From the cross-reference record set up through Work with Store Cross Reference (WSCR). The description of the location is separated from the location code by a hyphen (-). See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion, including information on when the location field is blank. The location description is truncated if it exceeds the allotted space. Location code: alphanumeric, 10 positions. Location description: alphanumeric, 40 positions.
Pickup Location	The location where the customer has selected to pick up the order. From the cross-reference record set up through Work with Store Cross Reference (WSCR). The description of the location is separated from the location code by a hyphen (-). See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion, including information on when the location field is blank. The location description is truncated if it exceeds the allotted space. Location code: alphanumeric, 10 positions. Location description: alphanumeric, 40 positions.
Item/SKU	A code that identifies a unit of inventory. Item codes are defined in and validated against the Item table. Note: The regular item code is displayed, regardless of whether the customer ordered using an alias and the Display Item Alias (D56) system control value is selected. Alphanumeric, 12 positions.
Order qty	The number of units of the item that the customer ordered. Numeric, 5 positions.
Details tab	Multiple locations? If you use the split order and split line options and Order Orchestration cannot find a single location to fulfill a brokered backorder line, it might split the across multiple fulfilling locations; splitting can occur either when Order Orchestration initially receives the order, or if the first assigned location rejects the line and Order Orchestration “reshops” it. The Use Split Order (L56) system control value controls this option in Order Administration, while the Allow Split Order and Allow Split Line settings at Order Orchestration’s Preferences screen control these options in Order Orchestration. In this situation, there is a single request ID assigned by Order Orchestration. If the Create Separate Picks for Ship for Pickup Orders (L89) system control value is selected and a line on a ship-for-pickup order splits across multiple warehouses for shipment, Order Administration creates a separate SubmitOrder request to Order Orchestration for each warehouse. In this situation, each SubmitOrder request creates a separate request ID assigned by Order Orchestration. Note: It is not possible to have a split line on other types of Order Orchestration orders.
Fulfilling Location	The location where: the item is currently assigned for fulfillment, which might be a store location (brokered backorder) or the Order Administration warehouse (retail pickup or delivery order) the customer picks up the order (store pickup or ship-for-pickup order) From the cross-reference record set up through Work with Store Cross Reference (WSCR). The description of the location is separated from the location code by a hyphen (-). See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion, including information on when the location field is blank. The location description is truncated if it exceeds the allotted space. Location code: alphanumeric, 10 positions. Location description: alphanumeric, 40 positions.
Status	The current status of the Order Orchestration request. Possible statuses are described at the Order Orchestration Status Summary Table.
Qty	The quantity currently assigned to the fulfilling location. 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. Numeric, 5 positions.
Created date/time	The date and time when the Order Orchestration request was created. Date: Numeric, 6 positions (in user date format). Time: Numeric, 6 positions (HH:MM:SS format).
Polled date/time	The most recent date and time when the BROKER job evaluated whether to request a status update for the order line. The job uses the Order Broker Status Update Interval (K10) system control value to determine how often to check on status. Not used for retail pickup or delivery orders, which do not originate in Order Administration. Date: Numeric, 6 positions (in user date format). Time: Numeric, 6 positions (HH:MM:SS format).
Request ID	A unique ID number assigned by Order Orchestration to identify the order line or order: If you do not split orders, each individual brokered backorder item submitted to Order Orchestration receives a unique request ID, and Order Orchestration treats it as a separate order; otherwise, lines on an order create a single request ID in Order Orchestration when the system submits the lines to Order Orchestration in the same request message. If the Create Separate Picks for Ship for Pickup Orders (L89) system control value is selected, Order Administration submits each order line to Order Orchestration as a separate order, and Order Orchestration assigns each its own request ID. Store pickup orders cannot be split. 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. Numeric, 25 positions.
History tab	History records sort by the line number assigned in Order Orchestration, and then by date and time within line number. The most recent 101 history records are displayed.
Date	The date when the request was sent to Order Orchestration, or when the response was received in Order Administration. Numeric, 6 positions (in user date format).
Time	The time when the request was sent to Order Orchestration, or when the response was received in Order Administration. Numeric, 6 positions (HH:MM:SS format).
OROB Ln#	The line number currently assigned in Order Orchestration at the time the response was sent or received. The line number is blank for history that occurs before Order Orchestration sends a response message indicating the current line number. If the order line is initially split at creation in Order Orchestration, the first few history records might have blank line numbers. Numeric, 5 positions.
Transaction type	The type of activity that occurred. Possible transaction types are: 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. Note: Once the order line is in Accepted status, Order Administration does not write a history record for the status inquiry response as long as the record remains in this status. 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 the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1) for examples of the different messages generated or received by Order Administration as part of the Order Orchestration integration. Alphanumeric, 25 positions.
Status	The status of the Order Orchestration line at the time of the activity. Possible statuses are described at the Order Orchestration Status Summary Table.
Fulfilling Location	The location where the item was assigned for fulfillment (brokered backorder, retail pickup, or delivery) or pickup (store pickup, ship-for-pickup) at the time the activity occurred. The description of the location is separated from the location code by a hyphen (-). If there is no Store Cross Reference record for the location, no description is displayed. See the Order Orchestration Originating Location, Fulfilling Location, and Pickup Location for a discussion. The location description is truncated if it exceeds the allotted space. Location code: alphanumeric, 10 positions. Location description: alphanumeric, 40 positions.
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. Numeric, 5 positions.
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 Web Services Guide https://support.oracle.com (ID 2953017.1) for more information on possible errors. Alphanumeric, 30 positions; display-only.