Oracle® Retail Xstore Suite 21.0/Oracle® Retail Merchandising Suite 22.1.301.0 Implementation Guide Release 21.0 F60431-01 |
|
![]() Previous |
![]() Next |
This chapter describes configuration options for the service integration, where Xstore Office calls Merchandising and Pricing services directly or through OCDS. This chapter does not apply to the flat file-based integration.
The direct service integration is set up through the Xadmin Integration Management feature and are stored in the Xstore Office Cloud Service database.
Note: The Integration Management feature is only available for Xstore Office Cloud Service. |
Table 4-1 RMFCS Connection Configuration
Fields | Description |
---|---|
|
A URL describing protocol, host name, and port of the Merchandising and Pricing Web Services. Example: |
|
A comma separated list of the chain ids in Merchandising containing stores in the Xstore Organization. |
For Merchandising and POM configurations required for direct service integration from Merchandising and Pricing, see the sections Merchandising Configuration and POM Configuration below.
To enable direct service integration, Oracle Retail Xstore Suite needs to be selected to have service based integration in the Integration section of System Options screen in Merchandising. For more information on System Options, refer to the Oracle Retail Merchandising Foundation Cloud Service Implementation Guide.
These services are operationalized by background processes that can be enabled and configured for running frequency in the Batch Administration screen of POM. For more information on these batch jobs, refer to the Oracle Retail Merchandising Foundation Cloud Service Operations Guide.
Note: When these services are initialized, some services need a few hours for initial data processing before they can be used. It is recommended to enable these services a day in advance before Xstore Office starts subscribing. |
Xstore Office requests changes to Merchandising and Pricing data in OCDS by calling the REST web services.
[ON PREMISE ONLY] The Xstore Office xcenter.properties file contains properties for the OCDS URL; service path prefix, org/chain mapping and properties.
[CLOUD ONLY] The properties for the OCDS integration are set up through the Xadmin Integration Management feature and are stored in the Xstore Office Cloud Service database.
Note: The Integration Management feature is only available for Xstore Office Cloud Service. |
Table 4-2 OCDS Connection Configuration
Fields | Description |
---|---|
|
A URL describing protocol, host name, and port of the OCDS Web Services. Example: |
Service Path Prefix |
The root service path for OCDS. Example: \ |
|
A comma separated list of the chain ids in the Merchandising system containing stores in the Xstore Organization. |
|
The username used to authenticate web service communication with OCDS. |
|
The password used to authenticate web service communication with OCDS. |
The OCDS system settings are used to enable and configure the integration.
[ON PREMISE ONLY] The Xstore Office xcenter.properties file contains properties for the OCDS configuration options.
[CLOUD ONLY] Use the Xadmin Integration Management feature to set OCDS configuration options.
Table 4-3 OCDS Configuration Options
Setting | Description |
---|---|
OCDS Retain Job History |
The number of days to retain OCDS Job History data in the Xadmin database. |
OCDS Scheduled Job Interval Minutes |
This is the frequency with which Xadmin requests data from OCDS. The value should be greater than or equal to 30 minutes. |
OCDS On Demand Job Interval Minutes |
This is the maximum amount of time that will elapse between when an on-demand job is created and is executed. The value should be greater than or equal to 5 minutes. |
OCDS Orphan Data Protection Offset Seconds |
This is the minimum amount of time data must age in OCDS before it can be visible to Xcenter. The offset helps to prevent related-data from becoming orphaned due to system latency. The value should be greater than or equal to 30 seconds. |
OCDS Records Per Request Limit |
This specifies the number of records to request in calls to OCDS. If no limit is defined then OCDS will determine the maximum number of records. |
OCDS Retail Location: Till Accountability |
This specifies if Retail Locations/Stores created from OCDS data are to use Till Accountability or not. |
OCDS Retail Location: Default Locale |
This specifies the Locale to use in Retail Locations created from OCDS data when a LANG_ISO_CODE is not defined for a location. This setting defines the value assigned to a Retail Location in the Xstore database if the store was not assigned a Locale in Merchandising |
OCDS Item: Tax Group ID for non-taxable Items |
This specifies the Tax Group ID assigned to non-taxable items created from OCDS data. |
OCDS Item: Include future date to determine VAT code with the greatest active date |
This specifies if future date should be included to determine VAT code with the greatest active date. |
OCDS VAT Rounding Code |
Specifies how the system will round when calculating the tax amount. Valid values are CEILING, DOWN, FLOOR, HALF_DOWN, HALF_EVEN, HALF_UP, and UP. For example, |
OCDS VAT Rounding Digits |
Specifies how many decimal places to round to when calculating the tax amount.The minimum rounding digit is 0 and the maximum rounding digit is 10. For example, |
OCDS VAT Rounding at Transaction Level |
Specifies the ability to round at transaction level when calculating the tax amount. When setting is set to When setting is set to |
The Xstore Suite provides the opportunity to organize data by Organization, where centralized and store-level data can be isolated according to a retail organization structure. The Merchandising Suite supports the use of one or more Chains, where a chain can be used to group various store formats.
The Integration in the On Premise and Cloud Xstore Office requires that at least one Merchandising Chain be mapped to an Xstore Organization. This configuration must not be changed once the mapping is established.
There are three database tables in the Xadmin database that are exclusively used for integration with Merchandising and Pricing for both integration methods described in this document. See the Oracle® Retail Xstore Point-of-Service Software Database Dictionary for complete details on these tables.
Table 4-4 Integration Database Tables
Table Name | Description |
---|---|
OCDS_JOB_HISTORY |
When enabled in Xadmin, an integration job is executed by scheduled-interval or on-demand, to detect foundation data changes in integration service and extract them out into .mnt files. An entry in this table records the status, start/end time and other information of a job executed. |
OCDS_ON_DEMAND |
An entry in this table represents an on-demand job request. On-demand jobs can be system generated (as in the case of new store detection), or user generated (from the Xadmin UI). |
OCDS_SUBTASK_DETAILS |
An integration job executes a list of subtasks. Each subtask represents a foundation data area to detect and extract out changes. The table defines metadata for all subtasks. For a scheduled job, each and every active subtask is executed. For an on-demand job, a subset of subtasks specified for the job is executed. |
The only table that requires seed data is the OCDS_SUBTASK_DETAILS; the other two tables will populate during operations of the integrations.
Retailers can determine the types of data requested from the integration service by Xstore Office. For example, if VAT information is not needed, then the integration can be configured to prevent requests for VAT data.
In Xstore Office Cloud Service's Integration Manager, use the Configure tab when completing the wizard UI to establish the integration. In on-premise Xstore Office, set the value of ocds.<Data Type>.properties in xcenter.properties to establish which datatypes should be active for the integration.
The OCDS_SUBTASK_DETAILS table includes the column DOWNLOAD_TIME, which specifies when .mnt files should be downloaded for data loading at the store. The column contains null for those Subtasks that only populate the Xcenter database. The out-of-the-box seed data is configured so that only Pricing data will flow to the store immediately.
The integration has been designed to not import items that represent an Xstore ”NOT ON FILE” item. The integration compares Item Ids of item records in the Xstore Office database having the type code ”NOT_ON_FILE” with item records in REST responses from the integration system so that it can skip records having the same item ID as an Xstore ”NOT ON FILE” item.