Edit Product Location

Purpose: Use the Edit Product Location screen to review or update availability information for a product location, or to check the last time this information was updated.

Used for the Routing Engine module.

Product relationships: See Product, System Product and Product Location for an overview of the relationships among Order Broker elements, including product locations. Also, see the Product Locations screen for more information on how product locations are created in Order Broker.

Updated how? The availability information displayed at this screen can be updated by:

a periodic refresh from an external system (such as product import processing from the order management system)
entry at the Edit Product Location screen
the Fulfilled Inventory Export
the availability update request
the product update request
an on-demand refresh triggered by a locate items search or product availability search for an online system
OCDS Imports

Order Broker uses the availability information displayed here to select a fulfilling location or a sourcing location for a ship-for-pickup order when:

the location is in an offline system, or
the location is in an online system, but the Order Broker cannot communicate with the system and the No Offline Response Action setting at the Preferences screen is Use offline

Order Broker uses the availability information displayed here in the locate items response when:

the location is in an offline system, or
the location is in an online system, but the Order Broker cannot communicate with the system and the No Offline Response Action setting at the Preferences screen is Use offline

Systems that use purchase order layering: The Next PO date and quantity listed might not reflect the date and quantity on the next open purchase order for a product if you integrate with a system such as Order Management System, which uses purchase order layering. In purchase order layering, the system accounts for the total quantity backordered to determine which purchase order might be able to fulfill a new order for the product. For example, the backorder quantity for a product is 115. There are 2 open purchase orders for the item, each with an order quantity of 100. Purchase order layering uses the date of the second purchase order as the Next PO Date since the full order quantity of the first purchase order is already fully committed to prior backorders. Also, it reports that the Next PO Quantity is 85, since the first 15 on the second purchase order is also already committed.

Note:

It is important to run the Batch Purchase Order Layering program (BPOL) in Order Management System before importing inventory information into Order Broker.

About attributes: The product attributes (Daily Sell Through Quantity, Sell Quantity/Multiple, Minimum Sell Quantity, Shrink Rate %, and Sales Velocity) are metrics that you can define for a product location in order to use them in probability rules. For example, you might want to display an available quantity of 0 if the actual available quantity is not more than the daily sell-through quantity for an off-line location. You can also have the Routing Engine use the Sales Velocity for product location ranking.

Additional attributes (Status, On Clearance, Selling Price, Cost, and Margin) can be used as part of LocateItems Sequence and Splitting Examples (Standard Brokering).

How to display this screen:

Click Edit for a product location at the Browse Product Locations window
Select the edit icon () for a location at the Product Locations screen
Only users with Products authority can display this screen. See the Role Wizard for more information.
If the Edit Product Location screen was already open in another tab when you clicked the edit icon, you advance to this screen with the previously-selected product location displayed.

Updating a product location

Update any of the fields described below and click Save, or click Cancel to return to the Product Locations screen without making any changes.

Note:

Any changes you make at this screen can be overwritten the next time you import product location information, as described in Importing Items/Products, Inventory, Barcodes, Images, and Locations into the Database.

Fields at this screen

Field	Description
Informational fields:
Organization	The organization code and name are separated by a hyphen (-).
System Product	The system product code and name are separated by a hyphen (-).
Location	The location code and name are separated by a space.
Last Updated	The last date and time when this product location was updated through the product and inventory import process, Fulfilled Inventory Export, inventory inquiry, or interactively at this screen. Up to 6 positions. Display-only. Not updated when Order Broker updates the Reserved Quantity or Fulfilled Quantity.
Availability fields:
Available Quantity	The quantity of the product available in this location as of the most recent update, before subtracting the Reserved Quantity and any Fulfilled Quantity, or applying any probability rules. This information can by updated through: a periodic refresh from an external system (such as product import processing from the order management system) entry at the Edit Product Location screen the Fulfilled Inventory Export the availability update request the product update request an on-demand refresh triggered by a locate items search or product availability search for an online system interactive updates to product locations through the Retail Integration Bus (RIB) when Importing Data from Merchandising Cloud Services (RMFCS) through the Omnichannel Cloud Data Service (OCDS) is implemented. This information originates in Oracle Retail Merchandising Foundation Cloud Service (RMFCS). See the discussion above under Edit Product Location for more information. Order Broker uses this quantity to calculate the Available to Promise unless it receives an update from an online system. Note: The available quantity is a maximum of 6 positions, and can be a negative number. It cannot include decimals. Probability rules: Probability rules use the Available to Promise in tests, calculations, and results. See Probability Rule Wizard for background.
Reserved Quantity	The quantity on all order lines assigned to this product location that are in a status indicating the inventory is reserved for existing orders. The reserved quantity and any fulfilled quantity are subtracted from the Available Quantity to determine the Available to Promise quantity. Up to 6 positions. In the case of ship-for-pickup orders, the reserved quantity is updated at the sourcing location. You can use the System screen to select the statuses that indicate an order line is reserved. The reserved quantity displayed here is 0 if there are no order lines in a —toselected status assigned to this product location. Display-only. For more information: See the Reservation tab at the System screen for information on selecting reserved statuses, and see Calculating the Available to Promise Quantity for an overview.
Fulfilled Quantity	The quantity that has been fulfilled on delivery or pickup orders, or put in transit for ship-for-pickup orders, since the last fulfilled quantity export to the system, or inventory import from the system. The reserved quantity and any fulfilled quantity are subtracted from the Available Quantity to determine the Available to Promise quantity. Up to 6 positions. In the case of ship-for-pickup orders, the fulfilled quantity is increased at the sourcing location when the pickup location changes the status to fulfilled. Tracked when? The Track Fulfilled Quantity field at the System screen controls whether to track the fulfilled quantity and, if so, when to reset it. Display-only. For more information: See the Track Fulfilled Quantity field for a discussion of how the fulfilled quantity is updated, and see Calculating the Available to Promise Quantity for an overview.
Available to Promise	Used for: The quantity for the system to use when determining the available quantity to return in the LocateItems response and the product availability search, and to evaluate locations for order assignment. Up to 6 positions, and can be a negative number. Display-only. Calculation: Calculated by subtracting the Reserved Quantity and any Fulfilled Quantity from the Available Quantity for the product location. When you update the Available Quantity at this screen and press the tab key, the screen updates the Available to Promise quantity based on your entry. Probability rules: If a probability rule applies to the product location, it is calculated based on this quantity. For more information: See Calculating the Available to Promise Quantity for an overview.
Next PO Date	The next date when a purchase order for this product is expected for delivery. Order Management System integration: The date is calculated using purchase order layering, in which the expected quantity on a purchase order may be “reserved” for older backorders. This information is not updated automatically from Order Management System each time you enter or maintain a purchase order. Some other activity, such as a change to the available quantity above or below the specified threshold, is required to trigger an update from Order Management System to Order Broker.See the Order Management System online help for more information.
Next PO Quantity	The number of units ordered on the next purchase order. This quantity can be up to 6 positions. It cannot include decimals. Order Management System integration: This information is not updated automatically from Order Management System each time you enter or maintain a purchase order. Some other activity, such as a change to the available quantity above or below the specified threshold, is required to trigger an update from Order Management System to Order Broker.
Attributes The following product attributes are available to guide selection of fulfilling or sourcing locations for orders: probability rules: See the Probability Rule Wizard for more information standard brokering: optionally, the Routing Engine can use the Sales Velocity for ranking weighted brokering: the Science Engine can use various product location attributes based on the configured weighted brokering percentages Each of the product attributes are user-defined.
Daily Sell Through Quantity	Typically represents the average quantity of the product sold in this location on a daily basis. You might use this quantity as part of a probability rule that subtracts the daily sell-through quantity from the available quantity, especially if the location is in an offline system. This quantity can be up to 6 positions, and must be a whole number. It cannot be a negative number.
Status	The status of the product in this location. Informational only. Possible statuses are: Active (default) = Can be ordered. Inactive = Cannot currently be ordered. Discontinued = Can still be ordered, but will be inactive at some point in the future. Required.
Sell Quantity/Multiple	Typically represents the selling multiple for a product; for example, you might sell tires in quantities of 4. You might use this quantity as part of a probability rule that indicates to exclude a product location, or display an available quantity of 0, if the available quantity is lower than the sell quantity/multiple. This quantity can be up to 6 positions, and must be a whole number. It cannot be a negative number. You might also use the Minimum Sell Quantity to fulfill the same function.
On Clearance	Indicates whether the product is on clearance in this location: Selected = The product is on clearance. Unselected (default) = The product is not on clearance. Used in LocateItems Sequence and Splitting Examples (Standard Brokering) calculation. If you use LocateItems Sequence and Splitting Examples (Standard Brokering) and this flag is selected, the Science Engine uses a selling price of .01 to calculate margin.
Minimum Sell Quantity	See the Sell Quantity/Multiple, above. This quantity can be up to 6 positions, and must be a whole number. It cannot be a negative number.
Selling Price	The single-unit selling price of the product in this location. Can be up to 19 positions with a 4-position decimal. It can also be 0, but cannot be a negative number, and should not include a currency symbol. Optional, but should be specified if Gross Margin is used in the LocateItems Sequence and Splitting Examples (Standard Brokering) calculation.
Shrink Rate %	Typically represents the percentage loss experienced for the product in this location due to theft or breakage. You might use the shrink rate as part of a probability rule that reduces the available quantity by the shrink rate percentage. This percentage can be up to 2 positions, and must be a whole number. It cannot be a negative number.
Cost	The single-unit cost of the product in this location. Can be up to 19 positions with a 4-position decimal. It can also be 0, but cannot be a negative number, and should not include a currency symbol. Optional, but should be specified if Gross Margin is used in the LocateItems Sequence and Splitting Examples (Standard Brokering) calculation.
Sales Velocity	A numeric ranking you can use to indicate how well a product sells in a particular location. You can use the sales velocity ranks assigned to product locations as part of the criteria for selecting fulfilling or sourcing locations for orders, either through standard or weighted brokering. Numeric; 2 positions with an optional 2-position decimal. Can be blank, or any number from 0 to 99.99. See the Standard Brokering or Weighted Brokering tabs at the Preferences screen for more information.
Margin	The Selling Price minus the Cost. If no Cost is specified, the Margin is equal to the Selling Price. If a Cost is specified, but no Selling Price, the Margin is negative. If no Cost or Margin is specified or if you set them to 0, the Margin is blank or 0.0000. System-calculated when either the Selling Price or Cost is entered. Display-only.