Work with Store Cross Reference (WSCR)
Purpose: Use this screen to set up cross-reference information between a store location and Order Management System. This information can be used to:
• display a description of the store location assigned to fulfill a brokered backorder. See the Work with Order Broker Screen for an example, and see Brokered Backorders for background.
• enable the customer to select a store location for pickup of a ship-for-pickup order at the Store Location Screen, or for a store pickup order at the Store Pickup Search Results Screen. When the customer selects the store, the store’s shipping address defaults to the order. See Ship-for-Pickup Orders and Store Pickup Orders for background.
• indicate the source code to default to a retail pickup or delivery order. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for background.
• display a description of an Order Management System warehouse at the Work with Order Broker Screen when it is assigned to fulfill a retail pickup or delivery order. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for background.
• display a description of an Order Management System warehouse at the Work with Order Broker Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for background.
• provide default information for your unique POSLog extract. See the Default Location for ORCE Integration (K69) system control value for more information.
• provide the pickup location displayed in the store pickup notification email. See Store Pickup Confirmation Email Program (L48) for more information.
• provide the store name, address, and phone number to include in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut) for:
• a retail pickup, delivery, ship-for-pickup, or store pickup order; or,
• for a sales rep’s Home store, if it is flagged as active, or for the Originating store from the Order Header table
Note: The Store Cross Reference record is not used:
• as part of the Merchandise Locator API.
• to display store descriptions or addresses at the Store Pickup Search Results Screen, although the Store Cross Reference record defaults to the Order Ship To Address when you accept the order.
Other ways to create store cross references: You can also create records in the Store Cross Reference table by:
• uploading them from an external system: see Store Upload for instructions. Using this option, you can also update existing records.
• importing them from Order Broker through a web service: see Importing Store Cross Reference Locations through Order Broker’s Discovery Web Service for more information. Using this option, you can create records, but cannot update them.
In this topic:
• Work with Store Cross Reference Screen
• Create Store Cross Reference Screen
Work with Store Cross Reference Screen
How to display this screen: Enter WSCR in the Fast path field at the top of any menu or select Work with Store Cross Reference from a menu.
When you first advance to this screen, stores display in ascending store code sequence.
Column sort: You can sort on any column 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.
|
Field |
Description |
|---|---|
|
Store |
A code identifying an external store location. Can also act as a cross-reference to a Order Management System warehouse. Enter a full or partial store code to display stores that begin with your entry. Alphanumeric, 10 positions. |
|
Description |
The description of the store location or warehouse. This description is displayed in Working with Order Broker (WOBR) as the name of the store assigned to fulfill a brokered backorder, or the description of the warehouse assigned to fulfill a retail pickup or delivery order or that is shipping a ship-for-pickup order; also, it defaults to the Company field at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See the Order Broker Integration for a discussion. Enter a full or partial description to display stores that contain your entry. Alphanumeric, 40 positions. |
|
Option |
Procedure |
|---|---|
|
Create a store cross reference |
Select Create for a store cross reference to advance to the Create Store Cross Reference Screen. Note: You can also use the Importing Store Cross Reference Locations through Order Broker’s Discovery Web Service process or the Store Upload to create store cross reference records. |
|
Change a store cross reference |
Select Change for a store cross reference to advance to the Change Store Cross Reference screen. See the Create Store Cross Reference Screen for field descriptions. |
|
Display a store cross reference |
Select Display for a store cross reference to advance to the Display Store Cross Reference screen. You cannot change any information on this screen. See the Create Store Cross Reference Screen for field descriptions. |
|
Delete a store cross reference |
Select Delete for a store cross reference. At the Confirm Delete window, select Yes to delete the record; otherwise, select No. |
Create Store Cross Reference Screen
Purpose: Use this screen to enter store cross-reference information for:
• transferring invoice data or sales transactions to your unique POSLog integration.
• integration with the Order Broker; see the Order Broker Integration for background.
Note: You can also use the Importing Store Cross Reference Locations through Order Broker’s Discovery Web Service process or the Store Upload to create store cross reference records.
How to display this screen: Select Create at the Work with Store Cross Reference Screen.
|
Field |
Description |
|---|---|
|
A code identifying an external store location. Can also act as a cross-reference to a Order Management System warehouse. Used in certain integrations: • POSLog: Set the Default Location for ORCE Integration (K69) to the store number representing Order Management System. • Order Broker: Set up a cross-reference for each store location to send retail pickup or delivery orders to Order Management System, or where you will send ship-for-pickup or pickup orders from Order Management System. Also, set up a cross-reference record for each Order Management System warehouse that you integrate with Order Broker if you would like to display the related description at the Work with Order Broker Screen. Alphanumeric, 10 positions. Create screen: required. Change screen: display-only. |
|
|
The phone number for the store. Included in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut); see the OriginatingStore element for more information. Alphanumeric, 14 positions; optional. |
|
|
Description |
The description to: • display in Working with Order Broker (WOBR) as the name of the store assigned to fulfill a brokered backorder. See Brokered Backorders for a discussion. • display as the fulfilling location for the warehouse assigned to fulfill a retail pickup or delivery order. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders. • display as the fulfilling location for the warehouse shipping a ship-for-pickup order. See Ship-for-Pickup Orders. • default to the Company field at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. • identify Order Management System in your POSLog integration. • include in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut). Note: If the description exceeds 30 positions, it is truncated at the Store Location Screen and at the Create One Time Ship To Address Screen. Also, any additional characters do not print on the pick slip and are not sent to the Order Broker. Alphanumeric, 40 positions. Create screen: required. Change screen: optional. |
|
Active? |
Defines whether the store location is active. • Selected = The store location is active. • Unselected = The store location is not active. The system validates that the store location is active when you define the store on the Work with Order Ship to Properties Screen in Order Entry or receive an order through the Generic Order Interface (Order API) that specifies a sales_rep_store location. |
|
The system associated with the store location in Order Broker. Used to identify the fulfilling location when sending a SubmitOrder request to Order Broker for a store pickup or ship-for-pickup order, and acts as an override to the Name in OROB for Point of Sale (L09). If this field is: • blank, the Name in OROB for Point of Sale (L09) is used instead • not a valid system code in Order Broker that is associated with the selected location, Order Broker cannot create the order, and returns an error Your entry must be a valid system code associated with the fulfilling location in Order Broker and the case must match exactly. Used only for store pickup and ship-for-pickup orders. Note: You still need to complete the Name in OROB for Point of Sale (L09) system control value, or you cannot create a ship-for-pickup order even if a valid system code is specified here. |
|
|
Register # |
The register number for transactions to pass to the point-of- sale (POS) system as part of a POSLog integration. Numeric, 3 positions; optional. |
|
Employee ID |
The employee identification to pass to the POS system as part of a POSLog integration. Alphanumeric, 12 positions; optional. |
|
Discount Code |
The discount code used to pass discount information for items to the POS system as part of a POSLog integration. Alphanumeric, 12 positions; optional. |
|
Price Override Code |
The price override reason code used as a cross reference as part of a POSLog integration. Not validated against the Price Override Reason Code table. Alphanumeric, 3 positions, optional. |
|
Item Hierarchy Level 1-4 |
Optionally, select the level of the item hierarchy in Order Management System that matches to the hierarchy level in an external system. Possible settings: • L/S (Long SKU) Division • L/S Department • L/S Class • Item Class • Item Category Optional. |
|
Indicates whether the store location is available for selection as a destination for a ship-for-pickup order. Only store locations that have this field selected are listed at the Store Location Screen in order entry. See Ship-for-Pickup Orders for an overview. If you select this field, the system validates that you enter: • the first Address line • a valid Country code • a valid State for the Country if state is required for the country • a Postal code that starts with a valid SCF for the State if postal code is required for the country Note: Select this field only for stores whose Ship For Pickup Receiving/Pickup Available setting is selected in Order Broker. |
|
|
Source Code |
The source code to assign to retail pickup or delivery orders received from the Order Broker. Used as follows for orders created through the fulfillments response message based on whether the order originated in Order Management System: • If the order did originate in Order Management System: • Use the Order Broker Source Code (K93), if specified; otherwise, if this system control value is blank, • Use the source code, if any, specified for the store cross reference record for the originating location, which is based on the Originating Location to Pass to OROB (M32) system control value; otherwise, • Use the source code passed in the fulfillments response message from Order Broker, which would be from the originating order. • If the order did not originate in Order Management System: • Use the source code, if any, passed in the fulfillments response message from Order Broker; otherwise, • Use the source code, if any, specified for the store cross reference record for the originating location; otherwise, • Use the Order Broker Source Code (K93), if specified; otherwise, if this system control value is blank, • The order is created in error status because of the missing source code. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for an overview. Your entry must be an existing source code. See Working with Source Codes (WSRC) for more information. Alphanumeric, 9 positions; optional. |
|
OriginatingStore element in the CWEmailOut message The following address fields, plus the Phone Number, are included in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut). See the OriginatingStore for more information. |
|
|
The address to default to the Address fields at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. Alphanumeric, four 32-position fields; optional. |
|
|
City |
The city to default to the City field at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. Alphanumeric, 25 positions; required if you select the Ship for Pickup flag; otherwise, optional. |
|
The state to default to the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. Required only if the Ship for Pickup flag is selected, and if the Require state? flag is selected for the country (see Setting Up the Country Table (WCTY)). Alphanumeric, 2 positions; required if you select the Ship for Pickup flag; otherwise, optional. |
|
|
The postal or zip code to default to the Postal code field at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. Required only if the Require postal code? flag is selected for the country (see Setting Up the Country Table (WCTY)) and if the Ship for Pickup flag is selected for the store cross reference. If a postal code is required, it is validated against the Zip/City/State (Postal Code) table; see Setting Up the Zip/City/State (Postal Code) Table (WZIP). Alphanumeric, 10 positions; required if you select the Ship for Pickup flag; otherwise, optional. |
|
|
The country code to default to the Country field at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. If the Ship for Pickup flag is selected, you need to enter a valid country code. The Default Country for Customer Address (B17) defaults. Alphanumeric, 3 positions; required if you select the Ship for Pickup flag; otherwise, optional. |
|
Importing Store Cross Reference Locations through Order Broker’s Discovery Web Service
Purpose: You can use Order Broker’s discovery web service to request the codes, descriptions and addresses of locations from Order Broker, and use this information to create Store Cross Reference records in Order Management System. A periodic function calls the web service and specifies the system in Order Broker whose locations should be imported and used to create the cross-reference records.
Location discovery setup:
• Periodic function: Create a periodic function such as IMPSTLC using the Program name PFR0122 and assign it to a periodic process. The Parameter for the periodic function is composed of up to 11 positions, where:
• position 1 = Y or y if the store cross-reference records should be created with the Ship for Pickup flag selected; otherwise, you would typically set the first position to N. If the first position is set to anything other than Y or y, the Ship for pickup flag is unselected for the Store Cross Reference record.
• positions 2-11 = The code identifying the system associated with the locations. Must be a valid system code in Order Broker.
Example: If the parameter is set to NPOS, the periodic function imports location records for system POS in Order Broker, and leaves the Ship for pickup flag for each imported location unselected.
• Required property file setting: To import locations using the discovery web service, you need to set the OROB_DISCOVERY_SERVICES_WSDL_LOCATION property in Working with Customer Properties (PROP) to the endpoint for the Discovery Services web service. This entry should be set to https://SERVER:8443/Locate/DiscoveryServices, where SERVER is the name of your Oracle Retail Order Broker server.
Note: If the discovery web service requires basic web service authentication, you must define a valid web service authentication user and password in Working with Web Service Authentication (WWSA), or client ID if using OAuth.
Location discovery processing: The periodic function:
• Sends a request to Order Broker’s discovery web service for locations in the system specified in the Parameter for the periodic function, as described above.
• Receives a response from Order Broker’s discovery web service, listing all locations in the specified system, excluding the Default Unfulfillable Location.
• For each location code specified in the response message that does not match an existing record, creates a new Store Cross Reference record in the company specified for the periodic process, using the first position of the periodic function’s Parameter to determine whether to select the Ship for Pickup flag for the new record. See below for mapping details.
Note:
• Prior to Order Broker 15.0, the Default Unfulfillable Location is labeled the Default Shipping Location at the Preferences screen.
• If there is already a Store Cross Reference record for a location specified in the response message, the function does not update it.
• If the first position of the Parameter is not Y or y, the Store Cross Reference records are created with the Ship for pickup flag unselected.
• If a valid system in Order Broker is not specified by positions 2-11 of the Parameter, Order Broker does not return any locations in the response, and no Store Cross Reference records are created.
• All characters are converted to uppercase when creating the Store Cross Reference records.
• If the information passed for a field from Order Broker exceeds the length of the corresponding field in Order Management System, it is truncated.
• Only the fields listed below are mapped. For example, the apartment or suite, if any, for the location is not mapped from Order Broker to Order Management System.
• Order Broker does not log the discovery web service messages; however, Order Management System logs the activity in the OROB (Oracle Retail Order Broker) Log.
• The function does not validate the data passed, such as city, state, or postal code, when creating new records.
For more information: See:
• the Order Broker Operations Guide for details on the discovery web services.
• Working with Periodic Functions (WPER) and Working with Periodic Processes (WPPR) for information on setting up and running the periodic function.
• Work with Store Cross Reference (WSCR) for information on working with Store Cross References and on how they are used.
Location data mapping: The table below describes how the function maps the data from the web service response when creating Store Cross Reference records.
|
From OROB |
Store Cross Reference Record |
Comments |
|---|---|---|
|
N/A |
Company code |
From the Company specified when executing the periodic process. |
|
location code |
Store # |
|
|
Name |
Description |
|
|
N/A |
Ship for Pickup |
From the first position of the Parameter specified for the periodic function; see above. |
|
Address lines 1-4 |
Address lines 1-4 |
Truncated if they exceed 32 positions. |
|
City |
City |
|
|
State or province |
State |
Truncated if it exceeds 2 positions. |
|
Postal code |
Postal code |
|
|
Country code |
Country code |
|
|
Telephone number |
Telephone number |
Truncated if it exceeds 14 positions. |
|
N/A |
Active |
Selected (set to Y). |
________________________________
Contents SCVs Reports XML Messages Glossary
Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
Legal Notices