11 Overview
Oracle Retail Supply Chain Hub works as the entry point to a group of applications that combines retailers and suppliers in the same portal. Depending on which applications are available in the Hub the users will be presented with a summary in the homepage and according to the user type (supplier or retailer) will have visibility on Operational News and Queries.
Operational News is a functionality that allows the retailers to share news with targeted suppliers in a central place, the retailers have permissions to create and edit them while the suppliers can only view them.
Another functionality is Queries, this functionality aims to allow the dialog between retailers and suppliers regarding a specific entity, like a Purchase Order or Shipments. This way the dialog is focused on that specific entity and makes easier the context.
Working as Hub, Oracle Retail Supply Chain Hub adapts to the applications that are installed in the system not only with different charts being presented in the homepage but also with a menu with access to all those applications so switching between applications keeps the context of the user in a seamless experience:
- Purchase Orders:
- Purchase Order Download/Upload
- Purchase Order Acknowledgment
- Purchase Order Changes/Approval
- Shipments:
- ASN Download/Upload
- ASN Creation/Update
- ASN Cancelation
- Finance Documents:
- Merchandise Invoice Creation
- ASN Creation/Update
- Finance Document Status View
- Item Creation
- Item Maintenance
- Item Download/Upload via Spreadsheet
- Cost Changes Creation
- Cost Changes Amendment/Cancellation
- Cost Changes Download/Upload via Spreadsheet
- RTV Creation Workflow
- RTV Download/Upload via Spreadsheet
- RTV Cancellation
- View Inventory
- View Sales
- Monitor Supplier Performance major KPIs
- Maintain and Record Supplier Questionnaires
- Create News
- View News
- Maintain News
- Create jobs manually
- View and Execute Jobs
- Download existing Jobs
- Upload new Jobs or execute existing ones
- Define, Update or View rules to automate Job creation
- Define, Update or View templates to be used in the Job creation process
- Deals Creation
- Deals Maintenance
- Deals Download/Upload via Spreadsheet
- Penalties Creation
- Penalties Maintenance
- View and Download Price Events
- Create new Price Event via UI
- Approve, Reject and Cancel Price Events
- Propose Changes to Price Events
- Upload new Price Events or update existing non extracted Price Events
- View Financial Transactions and Status
- Book and Maintain Appointments via UI
- Book and Maintain Appointments via Spreadsheet
- Appointments Slots Management via Download/Upload Spreadsheet
- Appointments Slot Exceptions Maintenance
- View Customer Orders
- Commit/Dispatch Customer Orders
- Customer Orders Download/Upload via Spreadsheet
- Customer Order Subscription
- Cancel Customer Orders
- Customer Orders Invoicing
- Share External Reports with Suppliers
Getting Started
Learn how to get started with Oracle Retail Supply Chain Collaboration Cloud Service.
Oracle Retail Data Store (RDS)
The Oracle Retail Data Store (RDS) is a set of infrastructure and tools that allows you to build extensions on top of the latest SaaS version for Retail application data without affecting the original Retail applications. These extensions may consist of database objects, web services, and user interfaces. The core of RDS is a data replication implementation that uses Oracle GoldenGate to replicate application data from Retail applications to a centralized database. The data is kept in sync with the source application database in near-real-time. This data is made available through Oracle REST Data Services (ORDS) and Application Express (APEX) workspaces.
The Oracle Retail Supply Chain Hub replicates its Data Model to RDS enabling the possibility of extending it.
Modules
The Oracle Retail Supply Chain Hub follows a modular approach where an application is composed of different modules that can evolve independently and can be reused in the future by other applications.
The following describes the modules and corresponding hierarchies between them that compose the Oracle Retail Supply Chain Hub. The Supply Chain Hub Frameworks section describes all modules and submodules.
Table 11-1 Modules
| MODULE_ID | MODULE_DESC | MODULE_ALIAS |
|---|---|---|
| APPOINTMENTS_MANAGEMENT | Appointments Management Module | SPAP |
| COST_CHANGES_MGMT | Cost Changes Management | SPCC |
| CUSTOMER_ORDER_FULFILLMENT | Customer Order Fulfillment | SPCO |
| DEALS_MANAGEMENT | Deals Management Module | SPDM |
| FINANCIAL_SUMMARY | Financial Summary Module | SPFS |
| INVENTORY_AND_SALES | Inventory and Sales | SPIS |
| ITEMS_MANAGEMENT | Items Management | SPIM |
| PRICE_MANAGEMENT | Retail Price Module | SPPM |
| PROCURE_TO_PAY | Procure to Pay Module | SPPP |
| QUALITY_CONTROL | Quality Control Module | QLCT |
| REPORTS | Reports Module | RPTS |
| RETURN_TO_VENDOR | Return To Vendor Module | SPRV |
| SUPPLIER_PENALTIES | Supplier Penalties Module | SPPY |
| SUPPLIER_PERFORMANCE | Supplier Performance | SPPF |
| SUPPLY_CHAIN_HUB | Supply Chain Hub Module | SPCH |
Table 11-2 Submodules
| MODULEID | SUBMODULEID1 | SUBMODULE ID2 | SUBMODULEID3 | SUBMODULEID4 |
|---|---|---|---|---|
| APPOINTMENTS_MANAGEMENT | NA | NA | NA | NA |
| APPOINTMENTS_MANAGEMENT | CUSTOM_VALIDATION | NA | NA | NA |
| APPOINTMENTS_MANAGEMENT | DASHBOARD | NA | NA | NA |
| APPOINTMENTS_MANAGEMENT | EVENTS | NA | NA | NA |
| APPOINTMENTS_MANAGEMENT | RCVDOC | NA | NA | NA |
| APPOINTMENTS_MANAGEMENT | UPLDNLD | NA | NA | NA |
| APPOINTMENTS_MANAGEMENT | UPLDNLD | APPOINTMENTS_DATA | NA | NA |
| APPOINTMENTS_MANAGEMENT | UPLDNLD | SLOTS_DATA | NA | NA |
| COST_CHANGES_MGMT | NA | NA | NA | NA |
| COST_CHANGES_MGMT | DASHBOARD | NA | NA | NA |
| COST_CHANGES_MGMT | PUBLISH | NA | NA | NA |
| COST_CHANGES_MGMT | PUBLISH | COST_CHANGE | NA | NA |
| COST_CHANGES_MGMT | RCVDOC | NA | NA | NA |
| COST_CHANGES_MGMT | SERVICES | ORDS | PUBLISH | NA |
| COST_CHANGES_MGMT | SERVICES | ORDS | PUBLISH | COST_CHANGE |
| COST_CHANGES_MGMT | UPLDNLD | NA | NA | NA |
| COST_CHANGES_MGMT | UPLDNLD | COST_CHANGE_DATA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | NA | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | CUSTOM_VALIDATION | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | DASHBOARD | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | EVENTS | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | INTEGRATION | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | PUBLISH | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | PUBLISH | ASNIN | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | PUBLISH | FINANCE_DOCUMENTS | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | PUBLISH | FULFILLMENT_ORDER | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | RCVDOC | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | SUBSCRIPTION | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | UPLDNLD | NA | NA | NA |
| CUSTOMER_ORDER_FULFILLMENT | UPLDNLD | COF | NA | NA |
| DEALS_MANAGEMENT | NA | NA | NA | NA |
| DEALS_MANAGEMENT | CUSTOM_VALIDATION | NA | NA | NA |
| DEALS_MANAGEMENT | DASHBOARD | NA | NA | NA |
| DEALS_MANAGEMENT | PUBLISH | NA | NA | NA |
| DEALS_MANAGEMENT | PUBLISH | DEAL | NA | NA |
| DEALS_MANAGEMENT | RCVDOC | NA | NA | NA |
| DEALS_MANAGEMENT | SERVICES | ORDS | NA | NA |
| DEALS_MANAGEMENT | UPLDNLD | NA | NA | NA |
| DEALS_MANAGEMENT | UPLDNLD | DEALS | NA | NA |
| FINANCIAL_SUMMARY | NA | NA | NA | NA |
| FINANCIAL_SUMMARY | DASHBOARD | NA | NA | NA |
| FINANCIAL_SUMMARY | SERVICES | ORDS | FINANCIAL_SUMMARY | NA |
| FINANCIAL_SUMMARY | SUBSCRIPTION | NA | NA | NA |
| FINANCIAL_SUMMARY | SUBSCRIPTION | PAYMENT | NA | NA |
| INVENTORY_AND_SALES | NA | NA | NA | NA |
| ITEMS_MANAGEMENT | NA | NA | NA | NA |
| ITEMS_MANAGEMENT | DASHBOARD | NA | NA | NA |
| ITEMS_MANAGEMENT | EVENTS | NA | NA | NA |
| ITEMS_MANAGEMENT | RCVDOC | NA | NA | NA |
| ITEMS_MANAGEMENT | SERVICES | ORDS | NA | NA |
| ITEMS_MANAGEMENT | UPLDNLD | NA | NA | NA |
| ITEMS_MANAGEMENT | UPLDNLD | ITEM_DATA | NA | NA |
| ITEMS_MANAGEMENT | UPLDNLD | SUPP_DFLT | NA | NA |
| PRICE_MANAGEMENT | NA | NA | NA | NA |
| PRICE_MANAGEMENT | CUSTOM_VALIDATION | NA | NA | NA |
| PRICE_MANAGEMENT | EVENTS | NA | NA | NA |
| PRICE_MANAGEMENT | PUBLISH | NA | NA | NA |
| PRICE_MANAGEMENT | PUBLISH | PRICE_EVENTS | NA | NA |
| PRICE_MANAGEMENT | RCVDOC | NA | NA | NA |
| PRICE_MANAGEMENT | UPLDNLD | NA | NA | NA |
| PRICE_MANAGEMENT | UPLDNLD | PCEVT_DATA | NA | NA |
| PRICE_MANAGEMENT | UPLDNLD | PCEVT_SIMP_DATA | NA | NA |
| PROCURE_TO_PAY | NA | NA | NA | NA |
| PROCURE_TO_PAY | DASHBOARD | NA | NA | NA |
| PROCURE_TO_PAY | RCVDOC | NA | NA | NA |
| PROCURE_TO_PAY | UPLDNLD | NA | NA | NA |
| PROCURE_TO_PAY | UPLDNLD | DOC_DATA | NA | NA |
| PROCURE_TO_PAY | UPLDNLD | PURCHASE_ORDER_DATA | NA | NA |
| PROCURE_TO_PAY | UPLDNLD | SHIPMENT_ASNIN_DATA | NA | NA |
| QUALITY_CONTROL | NA | NA | NA | NA |
| QUALITY_CONTROL | CUSTOM_VALIDATION | NA | NA | NA |
| QUALITY_CONTROL | DASHBOARD | NA | NA | NA |
| QUALITY_CONTROL | EVENTS | NA | NA | NA |
| QUALITY_CONTROL | PUBLISH | NA | NA | NA |
| QUALITY_CONTROL | PUBLISH | RTV | NA | NA |
| QUALITY_CONTROL | RCVDOC | NA | NA | NA |
| QUALITY_CONTROL | RULE_ENGINE | NA | NA | NA |
| QUALITY_CONTROL | UPLDNLD | NA | NA | NA |
| QUALITY_CONTROL | UPLDNLD | JOB | NA | NA |
| REPORTS | NA | NA | NA | NA |
| RETURN_TO_VENDOR | NA | NA | NA | NA |
| RETURN_TO_VENDOR | CUSTOM_VALIDATION | NA | NA | NA |
| RETURN_TO_VENDOR | DASHBOARD | NA | NA | NA |
| RETURN_TO_VENDOR | PUBLISH | NA | NA | NA |
| RETURN_TO_VENDOR | PUBLISH | RTV | NA | NA |
| RETURN_TO_VENDOR | RCVDOC | NA | NA | NA |
| RETURN_TO_VENDOR | UPLDNLD | NA | NA | NA |
| RETURN_TO_VENDOR | UPLDNLD | RTV | NA | NA |
| SUPPLIER_PENALTIES | NA | NA | NA | NA |
| SUPPLIER_PENALTIES | CUSTOM_VALIDATION | NA | NA | NA |
| SUPPLIER_PENALTIES | DASHBOARD | NA | NA | NA |
| SUPPLIER_PENALTIES | EVENTS | NA | NA | NA |
| SUPPLIER_PENALTIES | PUBLISH | NA | NA | NA |
| SUPPLIER_PENALTIES | PUBLISH | FINANCE_DOCUMENTS | NA | NA |
| SUPPLIER_PENALTIES | RCVDOC | NA | NA | NA |
| SUPPLIER_PENALTIES | RULE_ENGINE | NA | NA | NA |
| SUPPLIER_PERFORMANCE | NA | NA | NA | NA |
| SUPPLIER_PERFORMANCE | SERVICES | ORDS | NA | NA |
| SUPPLIER_PERFORMANCE | UPLDNLD | NA | NA | NA |
| SUPPLIER_PERFORMANCE | UPLDNLD | QUESTN | NA | NA |
| SUPPLIER_PERFORMANCE | UPLDNLD | QUESTN_REPLY | NA | NA |
| SUPPLY_CHAIN_HUB | NA | NA | NA | NA |
| SUPPLY_CHAIN_HUB | OPERATIONAL_NEWS | NA | NA | NA |