Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

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

1 Introduction

2 RIB Publication Designs

• Allocations Publication API
  • Functional Area
  • Integration Type
  • Business Overview
  • New Allocations
    • Allocation Header
    • Allocation Detail
    • Allocation Detail Component Items
    • New Allocation Details
    • Updated Allocations
    • Deleted Allocations
  • Error Handling
  • Message XSD
• ASNOUT Publication API
  • Functional Area
  • Business Overview
    • On-line Shipping/Receiving
    • Franchise Order Shipment and Return
  • Package Impact
    • Business Object ID
    • Package name: RMSMFM_SHIPMENT
    • Function Level Description - GETNXT
    • Function Level Description - PUB_RETRY
    • Function Level Description - PROCESS_QUEUE_RECORD (local)
    • Function Level Description - BUILD_HEADER_OBJECT (local)
    • Function Level Description - BUILD_DETAIL_OBJECTS (local)
    • Function Level Description - LOCK_THE_BLOCK (local)
    • Function Level Description - HANDLE_ERRORS (local)
    • Function Level Description - UPDATE_QUEUE_REC (local)
  • Trigger Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Available Inventory for Store and Warehouse Publication API
  • Functional Area
  • Integration Type
  • Business Overview
    • Item-Location Level Available to Sell Message
  • Error Handling
  • Message XSD
• Available Inventory for Store Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Function Level Description - ADDTOQ
  • Function Level Description - GETNXT
  • Function Level Description - PUB_RETRY
  • Function Level Description - PROCESS_QUEUE_RECORD (local)
  • Function Level Description - HANDLE_ERRORS (local)
  • Message XSD
  • Table Impact
  • Design Assumptions
• Banner Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Create
    • Modify
    • Delete
  • Trigger Impact
  • Table Impact
  • Design Assumptions
• Codes and Diff Types
  • Functional Area
  • Integration Type
  • Business Overview
    • New Code Types
    • Updated Code Types
    • Deleted Code Types
    • New Codes
    • Updated Codes
    • Deleted Codes
    • New Diff Types
    • Updated Diff Types
    • Deleted Diff Types
  • Error Handling
  • Message XSD
• Company Closed Publication API
  • Functional Area
  • Business Overview
    • New Closings
    • Updated Closings
    • Deleted Closings
    • New Closing Exceptions
    • Updated Closing Exceptions
    • Deleted Closing Exceptions
  • Error Handling
  • Message XSD
• Countries
  • Functional Area
  • Integration Type
  • Business Overview
    • New Country
    • Updated Country
    • Deleted Country
  • Error Handling
  • Message XSD
• Customer Order Fulfillment Confirmation
  • Functional Area
  • Integration Type
  • Business Overview
  • Error Handling
  • Message XSD
• Delivery Slot Publication API
  • Functional Area
  • Integration Type
  • Business Overview
    • Add Delivery Slot
    • Delivery Slot Modification
    • Delivery Slot Deletion
    • Error Handling
  • Message XSD
• Diff Group Publication API
  • Functional Area
  • Integration Type
  • Business Overview
    • New Diff Group Header
    • New Diff Group Detail
    • Updated Diff Group Header
    • Updated Diff Group Detail
    • Deleted Diff Group
    • Deleted Diff Group Detail
  • Error Handling
  • Message XSD
• Differentiators Publication API
  • Functional Area
  • Integration Type
  • Business Overview
    • New Differentiator IDs
    • Updated Differentiator IDs
    • Deleted Differentiator IDs
  • Error Handling
  • Message XSD
• Item Publication API
  • Functional Area
  • Business Overview
    • Deposit items
    • Catch-Weight Items
    • Receiving and inventory movement impact on catch-weight items
    • Item Transformation
    • Item and Item Component Descriptions
    • New Item Message Processes
    • Basic Item Message
    • New Item Message Publication
    • Subordinate Data and XML Tags
    • Modify and Delete Messages
    • Modify Messages
    • Delete messages
    • Design Overview
    • Business Object Records
  • Package Impact
    • Business Object ID
    • Package Specification - Global Variables
    • Function Level Description - ADDTOQ
    • Function Level Description - GETNXT
    • Function Level Description - PUB_RETRY
    • Function Level Description - PROCESS_QUEUE_RECORD (local)
    • Function Level Description - MAKE_CREATE (local)
    • Function Level Description - HANDLE_ERRORS (local)
    • Function Level Description - BUILD_MESSAGE
    • Function Level Description - BUILD_DELETE_MESSAGE
    • Function Level Description - BUILD_HEADER_OBJECT (local)
    • Function Level Description - BUILD DETAIL functions (all local)
    • Function Level Description - GET_ITEM_INFO (local)
    • Function Level Description - BUILD_DIMENSION_DESCRIPTIONS (local)
    • Function Level Description - BUILD_ITEM_MASTER_CFA_EXT (local)
    • Function Level Description - BUILD_ITEM_SUPPLIER_CFA_EXT (local)
    • Function Level Description - BUILD_ITEM_SUPP_CTRY_CFA_EXT (local)
  • Trigger Impact
  • Message XSD
  • Table Impact
  • Design Assumptions
• Item Location
  • Functional Area
  • Integration Type
  • Business Overview
  • New Item Location Relationship
    • Item/Location Description
    • Item/Location Physical Location Details
    • Item/Location Virtual Location Details
    • Custom Flex Attributes
    • Item/Location Virtual Location Replenishment Details
    • Modified Item Location Relationship
    • Deleted Item Location Relationship
    • Item Replenishment Attributes
    • Custom Flex Attributes
  • Error Handling
  • Message XSD
• Merchandise Hierarchy Publication API
  • Functional Area
  • Integration Type
  • Business Overview
    • New Division
    • Updated Division
    • Deleted Division
    • New Group
    • Updated Group
    • Deleted Group
    • New Department
    • Updated Department
    • Deleted Department
    • New Class
    • Updated Class
    • Deleted Class
    • New Subclass
    • Updated Subclass
    • Deleted Subclass
    • Error Handling
  • Message XSD
• Organizational Hierarchy Publication API
  • Functional Area
  • Business Overview
    • New Chains/Areas/Regions/Districts
    • Updated Chains/Areas/Regions/Districts
    • Deleted Chains/Areas/Regions/Districts
  • Error Handling
  • Message XSD
• Partner Publication API
  • Functional Area
  • Business Overview
    • External Finishers
  • Package Impact
    • Function Level Description - ADDTOQ
    • Function Level Description - PUB_RETRY
    • Function Level Description - PROCESS_QUEUE_RECORD (local)
    • Function Level Description - MAKE_CREATE (local)
    • Function Level Description - BUILD_HEADER_OBJECT (local)
    • Function Level Description - BUILD_HEADER_OBJECT (local)
    • Function Level Description - BUILD_DETAIL_OBJECTS (local)
    • Function Level Description - BUILD_SINGLE_DETAIL (local)
    • Function Level Description - BUILD_DETAIL_CHANGE_OBJECTS (local)
    • Function Level Description - BUILD_DETAIL_DELETE_OBJECTS (local)
    • Function Level Description - LOCK_THE_BLOCK (local)
    • Function Level Description - HANDLE_ERRORS (local)
    • Function Level Description - DELETE_QUEUE_REC (local)
    • Function Level Description – BUILD_PARTNER_CFA_EXT (local)
    • Function Level Description - BUILD_ ADDR _CFA_EXT (local)
  • Message XSD
  • Design Assumptions
  • Table Impact
• Purchase Orders
  • Functional Area
  • Integration Type
  • Business Overview
    • New Purchase Orders
    • Updated Purchase Orders
    • Full Message Updates
    • Deleted Purchase Orders
    • Flex Attributes
  • Error Handling
  • Message XSD
• Receiver Unit Adjustment Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business object ID
    • Package name
  • Trigger Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• RTV Request Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Object ID
  • Trigger Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Seasons and Phases Publication API
  • Functional Area
  • Integration Type
  • Business Overview
    • New Seasons
    • Updated Seasons
    • Deleted Seasons
    • New Phases
    • Updated Phases
    • Deleted Phases
  • Error Handling
  • Message XSD
• Store Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Package Specification - Global Variables
    • Public Type
    • Function Level Description - ADDTOQ
    • Function Level Description - GETNXT
    • Function Level Description - PUB_RETRY
    • Function Level Description - PROCESS_QUEUE_RECORD (local)
    • Function Level Description - MAKE_CREATE (local)
    • Function Level Description - BUILD_HEADER_OBJECT (local)
    • Function Level Description - BUILD_DETAIL_OBJECTS (local)
    • Function Level Description - BUILD_SINGLE_DETAIL (local)
    • Function Level Description - BUILD_DETAIL_CHANGE_OBJECTS (local)
    • Function Level Description - BUILD_DETAIL_DELETE_OBJECTS (local)
    • Function Level Description - LOCK_THE_BLOCK (local)
    • Function Level Description - HANDLE_ERRORS (local)
    • Function Level Description - BUILD_STORE_CFA_EXT (local)
    • Function Level Description - BUILD_ ADDR _CFA_EXT (local)
    • Function Level Description - BUILD_STORE_HOURS_OBJECT (local)
  • Message XSD
  • Table Impact
  • Design Assumptions
• Transfers Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Object ID
    • Create Header
    • Approve
    • Modify Header
    • Create Details
    • Modify Details
    • Delete Details
    • Close
    • Delete
  • Trigger Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• UDA Publication API
  • Functional Area
  • Integration Type
  • Business Overview
    • New UDAs
    • Updated UDAs
    • Deleted UDAs
    • New UDA Details
    • Updated UDAs
    • Deleted UDAs
  • Error Handling
  • Message XSD
• Vendor Publication API
  • Functional Area
  • Integration Type
  • Business Overview
  • Vendor Creation
  • Vendor Header Modification
  • Vendor Detail Creation
  • Vendor Detail Modification
  • Vendor Detail Deletion
  • Flex Attributes
  • Full Message Updates
  • Error Handling
  • Message XSD
• Warehouse Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Function Level Description - ADDTOQ
    • Function Level Description - GETNXT
    • Function Level Description - PUB_RETRY
    • Function Level Description - PROCESS_QUEUE_RECORD (local)
    • Function Level Description - DELETE_QUEUE_REC (local)
    • Function Level Description - MAKE_CREATE (local)
    • Function Level Description - BUILD_HEADER_OBJECT (local)
    • Function Level Description - BUILD_HEADER_OBJECT (local)
    • Function Level Description - BUILD_DETAIL_OBJECTS (local)
    • Function Level Description - BUILD_SINGLE_DETAIL (local)
    • Function Level Description - BUILD_DETAIL_CHANGE_OBJECTS (local)
    • Function Level Description - BUILD_DETAIL_DELETE_OBJECTS (local)
    • Function Level Description - LOCK_THE_BLOCK (local)
    • Function Level Description - HANDLE_ERRORS (local)
    • Function Level Description - BUILD_WH_CFA_EXT (local)
    • Function Level Description - BUILD_ ADDR _CFA_EXT (local)
  • Message XSD
  • Design Assumptions
  • Table Impact
• Work Orders In Publication API
  • Functional Area
  • Integration Type
  • Business Overview
    • New Work Order
    • Updated Work Order
    • Deleted Work Order
  • Error Handling
  • Message XSD
• Work Orders Out Publication API
  • Functional Area
  • Business Overview
  • New Work Order
  • Deleted Work Order
  • Error Handling
  • Message XSD

3 RIB Subscription Designs

• Allocation Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Appointments Subscription API
  • Functional Area
  • Business Overview
    • Appointment status
    • Appointment processing
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• ASNIN Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • Error Handling
    • Private Internal Functions and Procedures
    • Validation
  • Message XSD
  • Design Assumptions
  • Table Impact
• Outbound ASNs
  • Functional Area
  • Integration Type
  • Business Overview
    • Other Notes
  • Shipment Message Details
    • ASNOUT Details
    • ASNOUT Distro Details
    • ASNOUT Carton Details
    • ASNOUT Item Details
  • Error Handling
  • Message XSD
• COGS Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Validation Mode
    • DML Module
  • Message XSD
  • Design Assumptions
  • Table Impact
• Cost Change Subscription
  • Functional Area
  • Integration Type
  • Business Overview
  • Error Handling
  • Message XSD
• Currency Exchange Rates Subscription API
  • Functional Area
  • Business Overview
    • Data Flow
    • Message Structure
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Customer Order Fulfillment Subscription API
  • Functional Area
  • Business Overview
  • Message XSD
  • Design Assumptions
• Diff Group Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating Diff Groups
  • Updating Diff Groups
  • Deleting Differentiator Groups
  • Error Handling
  • Message XSD
• Differentiator Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
    • Creating Differentiators
    • Updating Differentiators
    • Deleting Differentiators
  • Error Handling
  • Message XSD
• Direct Ship Receipt Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• DSD Deals Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Error Handling
  • Message XSD
  • Design Assumptions
• DSD Receipt Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Freight Terms Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating Freight Terms
  • Error Handling
  • Message XSD
  • Design Assumptions
• GL Chart of Accounts Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • Public API Procedures:
    • Private Internal Functions and Procedures (rmssub_glcoacreb.pls):
    • Private Internal Functions and Procedures (other):
    • XML Parsing:
    • Validation
  • Message XSD
  • Design Assumptions
  • Table Impact
• GL Chart of Account Validation Service
  • Functional Area
  • Overview
• Inventory Adjustment Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
    • Inventory Adjustment Transaction Codes
    • Other Notes:
  • Error Handling
  • Message XSD
• Inventory Request Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating Inventory Requests
  • Error Handling
  • Message XSD
• Item Subscription API
  • Functional Area
  • Design Overview
    • L10N Localization Decoupling Layer:
    • Import Brazil-specific Fiscal Item Attributes to the Flex Attributes Extension Table (ITEM_COUNTRY_L10N_EXT):
  • Package Impact
    • Consume Module
    • Bulk or Single DML Module
  • Message XSD
  • Design Assumptions
  • Tables
• Item Location Subscription API
  • Functional Area
  • Business Overview
  • Creating Locations
  • Updating Item Location
  • Flex Attributes
  • Error Handling
  • Message XSD
• Item Reclassification Subscription API
  • Functional Area
  • Integration Type
  • Design Overview
    • New/Updated Reclassifications
    • Deleting Reclassifications
  • Message XSD
• Location Trait Subscription API
  • Functional Area
  • Design Overview
  • Message XSD
• Merchandise Hierarchy Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating a Company
  • Updating a Company
  • Creating Divisions
  • Updating Divisions
  • Deleting Divisions
  • Creating Groups
  • Updating Groups
  • Deleting Groups
  • Creating Departments
  • Updating Departments
  • Deleting Departments
  • Creating VAT Information for Departments
  • Updating VAT Information for Departments
  • Creating Up-charges for Departments
  • Updating Up-charges for Departments
  • Deleting Up-charges for Departments
  • Creating Classes
  • Updating Classes
  • Deleting Classes
  • Creating Subclasses
  • Updating Subclasses
  • Deleting Subclasses
  • Error Handling
  • Message XSD
• Merchandise Hierarchy Reclassification Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating Merchandise Hierarchy Reclassifications
  • Updating Merchandise Hierarchy Reclassifications
  • Deleting Merchandise Hierarchy Reclassifications
  • Error Handling
  • Message XSD
• Organizational Hierarchy Subscription API
  • Functional Area
  • Business Overview
  • Other Notes:
  • Message XSD
• Payment Terms Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating Payment Terms
  • Updating Payment Terms
  • Message XSD
• PO Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating Purchase Orders
  • Updating Purchase Orders
    • Header Level Updates
    • Detail Level Updates
  • Deleting Purchase Orders
  • Creating a Purchase Order Letter of Credit
  • Updating a Purchase Order Letter of Credit
  • Deleting a Purchase Order Letter of Credit
  • Creating Expenses
  • Updating Expenses
  • Deleting Expenses
  • Creating HTS and Assessments
  • Updating HTS and Assessments
  • Deleting HTS and Assessments
  • Publishing Updates
  • Flex Attributes
  • Error Handling
  • Message XSD
• Receiving Subscription API
  • Functional Area
  • Business Overview
  • Carton-Level Receiving
    • Actual (A)
    • Overage (O)
    • Dummy BOL (D)
    • Closed (C)
    • Misdirected Container
    • Blind Receipt Processing
    • Doc Types
    • L10N Localization Decoupling Layer
  • Package Impact
  • Message XSD
  • Table Impact
• RTV Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
    • New RTVs
    • Updated RTVs
    • RTV Header
    • RTV Details
    • Custom Flex Attributes
  • Message XSD
• Stock Order Status Subscription API
  • Functional Area
  • Business Overview
    • Stock Order Status Explanations
    • Pack Considerations
  • Package Impact
  • Message XSD
  • Table Impact
• Stock Count Schedule Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating/Updating Stock Count Requests
  • Deleting Stock Count Requests
  • Error Handling
  • Message XSD
• Store Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • Consume Module
    • Business Validation Module
    • Bulk or Single DML Module
  • Message XSD
  • Design Assumptions
    • Tables
• Transfer Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
  • Creating Transfers
    • Location Validation
    • Inventory Validation
    • Status Validation
    • Transfer Type Specific Validation
  • Transfers with Finishing
  • Updating Transfers
  • Deleting Transfers
  • Publishing Updates
  • Flex Attributes
  • Error Handling
  • Message XSD
• Vendor Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • Public API Procedures
    • Private Internal Functions and Procedures (rmssub_vendorcre.pls):
    • Private Internal Functions and Procedures (other):
  • Message XSD
  • Design Assumptions
• Work Order Status Subscription API
  • Functional Area
  • Integration Type
  • Business Overview
    • Work Order Example
  • Work Order Status Creation
  • Message XSD

4 SOAP Web Services

• Using SOAP Services During Batch Window
• Common Characteristics of Merchandising SOAP Services
  • Security
  • Standard Success Response
  • Standard Error Response
  • URL Path
  • Web Service APIs Process Flow
  • Provider Services
  • Consumer Services
• Provider Services
  • Allocation Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Average Cost Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Cost Change Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Customer Credit Check Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Customer Order Fulfillment Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Customer Order Item Substitution Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Business Overview
    • Assumptions
    • Operation XSD
  • Diff Management Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Inventory Back Order Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Assumptions
    • Operation XSD
  • Inventory Lookup Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Assumptions
    • Operation XSD
  • Item Management Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Pay Term Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Pricing Cost Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Assumptions
    • Operation XSD
  • Purchase Order Management Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Report Locator Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Store Order Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Assumptions
    • Operation XSD
  • Supplier Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
  • Transfer Service
    • Functional Area
    • RSB Proxy WSDL
    • Merchandising Service WSDL
    • Overview
    • Operation XSD
• Consumer Services
  • Customer Address Service
    • Functional Area
    • Overview
  • Customer Order Address Service
    • Functional Area
    • Overview
  • Get Drill Back Forward URL Service
    • Functional Area
    • Overview
  • GL Chart of Accounts Validation Service
    • Functional Area
    • Overview

5 ReSTful Web Services

• Introduction
• Common Characteristics
  • Security
  • Standard Request and Response Headers
  • Standard Error Response
  • Merchandising URL Paths
  • Sales Audit URL Paths
  • Date Format
  • Paging
  • Web Service APIs Process Flow
• Merchandising ReSTful Web Services
  • Merchandising Common Services
    • Vdate
    • Procurement Unit Options
    • Functional Config Options
    • Inventory Movement Unit Options
    • Currencies
    • Department Search
    • Department Load
  • Book Transfer ReSTful Web Service
    • Functional Area
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • ItemDetail RDO
    • Example JSON Input
    • Output
    • JSON Structure
    • Table Impact
  • Code Detail Service
  • Create Inventory Transfer Services
    • Functional Area
    • Business Overview
    • Transfer Number
    • Search Items
    • Load Items
    • Search From Location
    • Search To Location
    • Load Locations
    • Create Transfer
  • Create Purchase Order Services
    • Order Number
    • Terms
    • Search Supplier
    • Load Supplier
    • Search Items
    • Load Items
    • Search Locations
    • Load Locations
    • Create Purchase Order
  • Recent Inventory Transfer Services
    • Functional Area
    • Business Overview
    • Transfer Location Search
    • Transfer Location Load
    • Transfer Status List
    • Transfer Type List
    • Search Transfer User IDs
    • Transfer Search
    • Get Transfer Detail
    • Update Transfer Status
  • Recent Purchase Order Services
    • Functional Area
    • Business Overview
    • Cancel Reason Code List
    • Origin Code List
    • Purchase Order Status List
    • Search Purchase Order User ID
    • Purchase Order Search
    • Get Purchase Order Summary
    • Get Purchase Order Items
    • Get Purchase Order Item Locations
    • Update Purchase Orders Date
    • Cancel Purchase Orders
    • Approve Purchase Orders
    • Reject Purchase Orders
  • Replenishment Schedule Services
    • Functional Area
    • Business Overview
    • Create Replenishment Schedule
    • Modify Replenishment Schedule
    • Delete Replenishment Schedule
  • Allocation Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Background Process Configuration
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Currency Rates Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Data Privacy Access Service
    • Business Overview
    • Service Type
    • ReSTURL
    • Accept
    • Query Parameters
    • Path Parameters
    • Default Response
    • Sample Response
    • Response Codes and Error Messages
    • Success Payloads
  • Data Privacy Forget Service
    • Business Overview
    • Service Type
    • ReSTURL
    • Accept
    • Query Parameters
    • Path Parameters
    • Default Response
    • Response Codes and Error Messages
    • Success Payloads
  • Diff Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • EOW Run Signal Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Half Data Budget Service
    • Business Overview
    • Functional Area
    • Modify Half Data Budget
  • Inventory Adjustment Service
    • Functional Area
    • Business Overview
    • Inventory Adjustment
  • Item Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Item Loc Inventory Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • MerchHierarchy Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Obligations Upload Services
    • Function Area
    • Business Overview
    • Create Obligation
    • Create Obligation Component
    • Create Obligation Component Location
    • Modify Obligation
    • Modify Obligation Comp
    • Modify Obligation Component Location
    • Delete Obligation
    • Delete Obligation Component
  • Purchase Order Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Reclass Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Shipment Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Stock Count Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Store Day User Service
    • Functional Area
    • Business Overview
    • Create Store Day User
    • Delete Store Day User
  • Store Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Supplier Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Transfer Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • VAT Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Warehouse Detail Service
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
• Sales Audit ReSTful Web Services
  • Summary of Open Store Days
    • Business Overview
    • Service Type
    • ReSTURL
    • Input Parameters
    • Output
    • Table Impact
  • Summary of Errors
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Summary of Over/Short Amount
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Summary of Over/Short Count
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Get Store Days
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Get Store Errors
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Get Store Aggregations
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Store Search
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Get Store Day Date Indicator
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Data Privacy Access Service
    • Business Overview
    • Service Type
    • ReSTURL
    • Accept
    • Query Parameters
    • Path Parameters
    • Default Response
    • Sample Response
    • Response Codes and Error Messages
    • Success Payloads
  • Data Privacy Forget Service
    • Business Overview
    • Service Type
    • ReSTURL
    • Accept
    • Query Parameters
    • Path Parameters
    • Default Response
    • Response Codes and Error Messages
    • Success Payloads

6 Scheduled Integration

• File-based Integration Overview
  • Standard File Layouts
    • Detail-Only Files
    • Master and Detail Files
  • Integration Batch Wrapper FAQ
    • For input files, are there any specific file format names?
    • How and where will files be moved?
    • When will files be unzipped?
    • What will happen to the files once they are processed?
    • Will processed file be archived?
    • What will happen if the file is rejected?
    • How will rejected files be reprocessed?
  • File Movement Flow
  • Input/Output File Naming Convention
• Bulk Data Integration Overview
• Outbound Scheduled Integration
  • Foundation Data
    • Brand Publication API (BDI_Brand_Fnd_PF_From_RMS_EOW_JOB)
    • Calendar Publication API (BDI_Calendar_Fnd_PF_From_RMS_EOW_JOB)
    • Code Detail Publication API (BDI_CodeDetail_Fnd_PF_From_RMS_JOB)
    • Code Head Publication API (BDI_CodeHead_Fnd_PF_From_RMS_JOB)
    • Company-wide Closings and Company Closed Exceptions (BDI_CompanyClosed_Fnd_PF_From_RMS_JOB)
    • Currency Conversion Rates Publication API (BDI_CurrConvRates_Fnd_PF_From_RMS_EOW_JOB)
    • Delivery Slot Publication API (BDI_DeliverySlot_Fnd_PF_From_RMS_JOB)
    • Diff Group Export (export_diffgrp.ksh)
    • Diff Group Publication API (BDI_DiffGrp_Fnd_PF_From_RMS_JOB)
    • Diff ID and Type Export (export_diffs.ksh)
    • Diff ID Publication API (BDI_Diff_Fnd_PF_From_RMS_JOB)
    • Finisher Address Publication API (BDI_FinisherAddr_Fnd_PF_From_RMS_JOB)
    • Location Closed Publication API (BDI_LocClosed_Fnd_PF_From_RMS_JOB)
    • Merch Hierarchy Publication API (BDI_MerchHier_Fnd_PF_From_RMS_JOB)
    • Merchandise Hierarchy Export (export_merchhier.ksh)
    • Organization Hierarchy Publication API (BDI_OrgHier_Fnd_PF_From_RMS_JOB)
    • Organizational Hierarchy Export (export_orghier.ksh)
    • Partner Address Publication API (BDI_PartnerAddr_Fnd_PF_From_RMS_JOB)
    • Partner Org Unit Publication API (BDI_PartOrgUnit_Fnd_PF_From_RMS_JOB)
    • Partner Publication API (BDI_Partner_Fnd_PF_From_RMS_JOB)
    • Store Address Publication API (BDI_StoreAddr_Fnd_PF_From_RMS_JOB)
    • Store Hours Publication API (BDI_StoreHours_Fnd_PF_From_RMS_JOB)
    • Store Publication API (BDI_Store_Fnd_PF_From_RMS_JOB)
    • Stores Export (export_stores.ksh)
    • Supplier Address Publication API (BDI_SupplierAddr_Fnd_PF_From_RMS_JOB)
    • Sups Publication API (BDI_Supplier_Fnd_PF_From_RMS_JOB)
    • Tax Download - Brazil (taxdnld)
    • Ticket Download (tcktdnld)
    • UDA Publication API (BDI_Uda_Fnd_PF_From_RMS_JOB)
    • UDA Values Publication API (BDI_UdaValues_Fnd_PF_From_RMS_JOB)
    • UOM Class Publication API (BDI_UomClass_Fnd_PF_From_RMS_JOB)
    • UOM Conversion Publication API (BDI_UomConversion_Fnd_PF_From_RMS_JOB)
    • VAT Codes, Regions, and Rates Export (export_vat.ksh)
    • VAT Publication API (BDI_Vat_Fnd_PF_From_RMS_JOB)
    • Warehouse (BDI_Wh_Fnd_PF_From_RMS_JOB)
    • Warehouse Address Publication API (BDI_WhAddr_Fnd_PF_From_RMS_JOB)
  • Items
    • Item Image Publication API (BDI_ItemImage_Fnd_PF_From_RMS_JOB)
    • Item Location Export (export_itemloc.ksh)
    • Item Location Publication API (BDI_ItemLoc_Fnd_PF_From_RMS_JOB)
    • Item Master Export (export_itemmaster.ksh)
    • Item Master Publication API (BDI_ItemHdr_Fnd_PF_From_RMS_JOB)
    • Item Supplier Country Dimensions Publication API (BDI_ItSupCtryDim_Fnd_PF_From_RMS_JOB)
    • Item Supplier Country Publication API (BDI_ItSupCtry_Fnd_PF_From_RMS_JOB)
    • Item Supplier Manufacturing Country Publication API (BDI_ItSupManCtry_Fnd_PF_From_RMS_JOB)
    • Item Supplier Publication API (BDI_ItemSupp_Fnd_PF_From_RMS_JOB)
    • Item Supplier UOM Publication API (BDI_ItemSuppUom_Fnd_PF_From_RMS_JOB)
    • Item VAT Rates Export (export_itemvat.ksh)
    • Pack Item Publication API (BDI_PckitemBrkout_Fnd_PF_From_RMS_JOB)
    • POS Configuration Data to 3rd Party POS (poscdnld)
    • Price History Publication API (BDI_PriceHist_Fnd_PF_From_RMS_JOB)
    • Related Items Export (export_relitem.ksh)
    • Related Item Publication API (BDI_RelatedItem_Fnd_PF_From_RMS_JOB)
    • UDA Item Date Publication API (BDI_UdaItemDate_Fnd_PF_From_RMS_JOB)
    • UDA Item FF Publication API (BDI_UdaItemFF_Fnd_PF_From_RMS_JOB)
    • UDA Item LOV Publication API (BDI_UdaItemLov_Fnd_From_RMS_JOB)
  • Financials
    • Daily or Weekly Donwload of Stock Ledger Data (stlgdnld)
    • Finance General Ledger to RFI (BDI_RFI_FinGenLdgr_Tx_PF_From_RMS_JOB)
    • Fixed Deal Income (dealfinc)
    • Franchise Billing Extract (wfbillex.ksh)
    • Item/Location Daily Stock Ledger Transactions (fifgldn1)
    • Monthly Stock Ledger Transactions (fifgldn3)
    • Open to Buy Download Stock Ledger (otbdlsal)
    • Rolled Up Daily Stock Ledger Transactions (fifgldn2)
    • Stage G/L Extracts (gl_extract.ksh)
    • Tran Data Publication (BDI_TranData_Tx_PF_From_RMS_EOW_JOB)
  • Ordering and Inventory
    • Purchasing
    • Import Management
    • Invoices
    • Inventory
  • Planning and Forecasting
    • Brand Extract to Planning (BDI_RPAS_Brand_Fnd_PF_From_RMS_JOB)
    • Calendar Extract to Planning and Forecasting (BDI_RPAS_Calendar_Fnd_PF_From_RMS_JOB)
    • Currency Rates Extract to Planning and Forecasting (BDI_RPAS_CurrConvRates_Fnd_PF_From_RMS_JOB)
    • Differentiator Extract to Planning (BDI_RPAS_Diff_Fnd_PF_From_RMS_JOB)
    • Inventory Extract to Planning (BDI_MFP_Inventory_Tx_PF_From_RMS_JOB)
    • Merchandise Hierarchy and Item Extract to Planning and Forecasting (BDI_RPAS_MerchHier_Fnd_PF_From_RMS_JOB)
    • On Order Extract to Planning (BDI_MFP_OnOrder_Tx_PF_From_RMS_JOB)
    • Organization Hierarchy Extract to Planning and Forecasting (BDI_RPAS_OrgHier_Fnd_PF_From_RMS_JOB)
    • Out of Stock Extract to Forecasting (BDI_RDF_StockOut_Tx_PF_From_RMS_JOB)
    • Store Extract to Planning and Forecasting (BDI_RPAS_Store_Fnd_PF_From_RMS_JOB)
    • Supplier Extract to Planning (BDI_RPAS_Supplier_Fnd_PF_From_RMS_JOB)
    • Transaction Data Extract to Planning (BDI_MFP_TranData_Tx_PF_From_RMS_JOB)
    • UDA Extract to Planning (BDI_RPAS_UdaAndUdaValues_Fnd_PF_From_RMS_JOB)
    • UDA Item Extract to Planning and Forecasting (BDI_RDF_UdaItemLov_Fnd_From_RMS_JOB)
    • Weekly Sales Extract to Forecasting (BDI_RDF_WeeklySales_Tx_PF_From_RMS_JOB)
  • Sales Audit
    • Download from Sales Audit to Account Clearing House (ACH) System (saexpach)
    • Download of Escheated Vouchers from Sales Audit for Payment (saescheat)
    • Export DSD and Escheatment from Sales Audit to Invoice Matching (saexpim)
    • Export from Sales Audit to Oracle Retail Insights (saexpdw)
    • Export Inventory Reservation/Release for In Store Customer Order & Layaway Transactions (saordinvexp)
    • Export of POS transactions from Sales Audit to Merchandising (saexprms)
    • Export of Revised Sale/Return Transactions from ReSA to SIM/SIOCS (saexpsim)
    • Export to Universal Account Reconciliation System from Sales Audit (saexpuar)
    • Extract of POS Transactions by Store/Date from Sales Audit for Web Search (ang_saplgen)
    • Post User Defined Totals from Sales Audit to General Ledger (saexpgl)
• Inbound Scheduled Integration
  • Item, Cost, and Price
    • Upload Competitor's Prices (cmpupld)
    • Upload Items and Cost Changes (iindbatch.ksh)
  • Ordering and Inventory
    • Purchasing
    • Import Management
    • Stock Counts
    • Franchise
    • Other Inventory
  • Sales Processing
    • Sales Audit
    • Sales Posting
  • Forecasting
    • Daily Demand Item Forecast Subscription API
    • Weekly Demand Item Forecast Subscription API
    • Weekly/Daily Item Forecast Upload (load_item_forecast)