ORPOS Integration Point With Other System

Interfaces Descriptions

The following interface descriptions are relative to Oracle Retail Strategic Store Solutions (ORSS), suite of applications where import implies that the ORSS application is importing the data originating from an external system and export means that the ORSS application is exporting the data to be consumed by an external system.

 1)- Tax Import 

This interface is used for distributing Tax data in Central Office and the stores. This data is provided by any third party application like Vertex.Tax Geocodes for stores or TaxGroup IDs for items needs to provided by third-party tax application system. It is the responsibility of the implementation team to intercept the following download data and use a third-party tax application to apply the appropriate tax information:

2)- Store Hierarchy Import

This interface is used for distributing Store Hierarchy data originating from any master system to Central Office and the stores.Retail store is organized into departments offering a variety of merchandise; commonly part of a retail chain.

3)-Merchandise Hierarchy Import

This interface is used for distributing Merchandise Hierarchy data originating from any master system to Central Office and to the stores. This interface would be used to maintain the Merchandise Hierarchy for items in the store.The merchandise hierarchy allows you to create the relationships necessary to support

the product management structure of your company. You can assign a buyer and merchandiser at the division, group, and department levels of the merchandise hierarchy.

4)-Item Import

This interface is used for distributing item data originating from any master system to Central Office and the stores. This interface will be used to maintain the store item database.

 

5)-Price Import

This interface is used for distributing price changes originating from any master system or dedicated Pricing module or system such as ORPM to Central Office and the stores. This interface would be used to maintain the price and promotion for items in the store.

6)-Employee Import

This interface is used for distributing Employee data originating from OIM/LDAP to Central Office and the 

stores.

7)-Customer & their Price Profile

This interface is used for distributing Customer data originating from dedicated customer management system or customer loyalty management system to Central Office and the stores.  

8)-LDAP

This interface is used to authenticate users/employee login credentials against the enterprise LDAP server.

Its mandatory one Service user has been configured in LDAP.

9)-Transaction Posting

This interface is used to purge transaction data and customer data from store database to corporate database with in certain time frame or some third party such as loyalty management system.The purge period may vary.

10)- Order Management System

This interface is used for online ordering as well as offline ordering such as an order in advance by customer when he/she found an item out of stock in store and he/she needed that item ASAP.

11/12)-Missing Item look-up /Customer look-up

13)-ISD

This interface is used for Tender Authorization system.  such as bank gateway , payment switch etc.

14)-ISD to Master System Integration if required

15)- Other System

This interface is used to integrate ORPOS system to legacy system.