Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Customer Support
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Help Center (docs.oracle.com)
• Conventions

1 Introduction

2 Integration Architecture

• Domain Value Maps (DVMs)

3 Integration Errors

• Universal Service Mapper (USM)

4 Data Conversion

• Manual Conversion
  • Order Types
    • Stock Orders
    • Customer Orders
    • Return to Vendor Request
  • Reason Codes
    • Customer Order Returns
    • Receiver Unit Adjustments
  • Lock Codes
• Convert Master Data
  • Stores, Partners, and Warehouses
    • Stores
    • External Finishers
    • Warehouses
  • Vendors
  • Items
    • Item Header
    • Item Barcodes
    • Item Pre-packs
• Convert Transactional Data
  • Purchase Orders
  • Inventory

5 Integration Configuration

• Schedule Jobs
• Enabled Auto Send
• Configure Outbound Interfaces
  • Inventory History Export
  • Outbound Loads Export
  • Outbound Manifest
• Other Configurations
  • Sequence Counters
    • BOL Number
    • Inbound Shipment Number
    • Load and Parcel Manifests
  • IB Shipment Types
  • Company Configurations
    • Decimal Support
  • Facility Configurations
  • RF Configuration
    • Create LPN
    • Receive LPN
• Configure Integration Layer
  • Configure USM
    • Configure Static DVMs
  • Configure RIB
• Configure Merchandising
• Configure OMS

A Appendix - Solution Overviews

• Oracle Warehouse Management Cloud
• Retail Integration
• Merchandising
• Retail Store Inventory and Operations Cloud Service
• Retail Order Broker Cloud Service

B Appendix - Outbound and Inbound Interfaces

• Outbound from WMS Cloud
• ASN Outbound
  • WMS Cloud Integrations
  • ASN Out (ASNOutCre)
• Inventory Adjustments
  • WMS Cloud Integrations
  • Inventory Adjustment (InvAdjustCre)
• Return to Vendor Shipments
  • WMS Cloud Integrations
  • RTV (RTVCre)
• Receiving
  • WMS Cloud Integrations
  • Receipt (ReceiptMod)
• Stock Order Status
  • WMS Integrations
  • SO Status (SOStatusCre)
• Inbound to WMS Cloud
  • Store
    • WMS Cloud Integrations
    • Create and Modify (StoreCre)
    • Delete (StoreDel)
  • Vendor
    • WMS Cloud Integrations
    • Vendor Create (VendorCre) and Modify (VendorFulRep)
    • Vendor Delete (VendorDel)
  • External Finisher
    • WMS Cloud Integrations
    • Partner Create (PartnerCre PartnerDtlCre) and Modify (PartnerDtlMod, PartnerMod)
    • Partner Delete (PartnerDel)
    • Partner Details Delete (PartnerDtlDel)
  • Items
    • WMS Cloud Integrations
    • Item Create (ItemCre, ItemUpcCre, ItemBomCre) and Modify (ItemUpcMod, ItemBomMod, ItemFulRep)
  • ASN Inbound
    • WMS Cloud Integrations
    • Create (ASNInCre or Modify (ASNInMod)
    • Delete (ASNInDel)
  • Order
    • WMS Cloud Integrations
    • PO Create (POCre) and Modify (POFulRep)
    • PO Delete (PODel)
  • Stock Order
    • WMS Cloud Integrations
    • Stock Order Create (SOCre) or Modify (SOFulRep)
    • Stock Order Header Delete (SOHdrDel)
  • RTV Requests
    • WMS Cloud Integrations
    • Create RTV Request (RTVReqCre) or Modify (RTVReqFulRep)
    • Delete RTV Request (RTVReqDel)

C Appendix - Activity Codes

• Activity Code Mappings

D Appendix - Known Issues

E Appendix - Other Resources

• WMS Cloud
• Oracle Retail Integration
• Oracle Retail Merchandising
• Other Documentation References