Contents

List of Figures

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 Technology Network
• Conventions

1 Introduction

• Message Publication and Subscription Designs
  • External Subscription RIB Application Programming Interface
  • Parallel processing for Performance Purpose
    • Subscription APIs
    • Publishing APIs
• Web Service Provider Implementations API Designs

2 Publication Designs

• Allocations Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Object ID
    • Create Header
    • Modify Header
    • Create Detail
    • Modify Detail
    • Approve
    • Close
    • Delete
    • Package Name: RMSMFM_ALLOC
  • Trigger Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• 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
• Banner Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Create
    • Modify
    • Delete
  • Trigger Impact
  • Message XSD
  • Table Impact
  • Design Assumptions
• Customer Order Fulfillment Confirmation Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Object ID
  • Trigger Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Delivery Slot Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Create Delivery_Slot
    • Update Delivery_Slot
    • Delete Delivery_slot
    • Function Level Description - ADDTOQ
    • Function Level Description - GETNXT
    • Function Level Description - PUB_RETRY
    • Function Level Description - PROCESS_QUEUE_DLVY_SLT (local)
  • Trigger Impact
  • Message XSD
  • Table Impact
  • Design Assumptions
• Differentiator Groups Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Create Diff Group
    • Modify Diff Group
    • Create Diff Group Detail
    • Modify Diff Group Detail
    • Delete Diff Group Detail
    • Delete Diff Group
    • Function Level Description - GETNXT
  • Trigger Impact
  • Message XSD
  • Table Impact
  • Design Assumptions
• Differentiator ID Publication API
  • Functional Area
  • Business Overview
    • Diff message processes
  • Package Impact
    • Function Level Description - ADDTOQ
    • Function Level Description - GETNXT
    • Function Level Description - GETNXT(local)
  • Trigger Impact
  • Message XSD
  • Table Impact
  • Design Assumptions
• 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 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 - BUILD_DETAIL_OBJECTS (local)
    • Function Level Description - BUILD_DETAIL_DELETE_OBJECTS (local)
    • Function Level Description - HANDLE_ERRORS (local)
    • Function Level Description - BUILD_ITEM_LOC_CFA_EXT (local)
  • Trigger Impact
  • Message XSD
  • Table Impact
  • Design Assumptions
• Merchandise Hierarchy Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Object ID
    • 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)
    • Function Level description - BUILD_DEPS_CFA_EXT
    • Function Level description - BUILD_CLASS_CFA_EXT
    • Function Level description - BUILD_SUBCLASS_CFA_EXT
  • Message XSD
  • Design Assumptions
  • Table Impact
• Order Publication API
  • Functional Area
  • Business Overview
    • Creating of Purchase Orders
    • Purchase Order Messages
    • Order Message Processes
  • Package Impact
    • Modify Pre-Approved
    • Approve
    • Modify in 'A' status
    • Redistribute
    • Unapprove
    • Modify
    • Close
    • Reinstate
    • Delete
  • Message XSD
  • Design Assumptions
  • Table Impact
• Organization Hierarchy Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Object ID
  • Message XSD
  • Design Assumptions
  • Table Impact
• 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
• 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
• Season Phase Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Object ID
  • Message XSD
  • Design Assumptions
  • Table Impact
• Seed Data Publication API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Seed Object Publication API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Table Impact
• 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 - 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)
  • 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
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Vendor Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Function Level Description - ADDTOQ
    • Function Level Description - GETNXT
    • Function Level Description - CREATE_PREVIOUS (local)
    • Function Level Description - CLEAN_QUEUE (local)
    • Function Level Description - CAN_CREATE (local)
    • Function Level Description - MAKE_CREATE (local)
    • Function Level Description - DELETE_QUEUE_REC (local)
    • Function Level Description - REPLACE_QUEUE_SUP (local)
    • Function Level Description - REPLACE_QUEUE_ADR (local)
    • Function Level Description - CHECK_STATUS (local)
    • Function Level Description - MAKE_CREATE_POU (local)
    • Function Level Description - BUILD_SUPS_CFA_EXT (local)
    • Function Level Description - BUILD_SUPPLIER_ADDR_CFA_EXT (local)
    • Function Level Description - MAKE_CREATE_CFA (local)
  • Message XSD
  • Design Assumptions
  • Table Impact
• 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
  • Business Overview
  • Package Impact
    • Business Object ID
    • Create
    • Modify
    • Delete
  • Trigger Impact
  • Message XSD
  • Table Impact
  • Design Assumptions
• Work Orders Out Publication API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Object ID
    • Approve
    • Delete
    • Unapproved
  • Trigger Impact
  • Message XSD
  • Design Assumptions
  • Table Impact

3 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
• ASNOUT Subscription API
  • Functional Area
  • Business Overview
    • L10N Localization Decoupling Layer
    • BOL Message Structure
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• COGS Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • Business Validation Mode
    • DML Module
  • Message XSD
  • Design Assumptions
  • Table Impact
• Cost Change Subscription API
  • Functional Area
  • Design Overview
    • Consume Module
    • Business Validation Module
    • Cost Change Modify
    • POPULATING RECORD
  • Bulk or Single DML Module
    • Cost Change
  • Message XSD
  • Design Assumptions
  • Table Impact
• Currency Exchange Rates Subscription API
  • Functional Area
  • Business Overview
    • Data Flow
    • Message Structure
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Diff Group Subscription API
  • Functional Area
  • Design Overview
    • Differentiators
  • Package Impact
    • Business Validation Module
  • Message XSD
  • Design Assumptions
  • Table Impact
• Diff ID Subscription API
  • Functional Area
  • Design Overview
  • Package Impact
    • Business Validation Module
  • Message XSD
  • Design Assumptions
  • Table Impact
• Direct Ship Receipt Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• DSD Deals Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • RMSSUB_DSDDEALS.COMPLETE_TRANSACTION
    • RMSSUB_DSDDEALS.HANDLE_ERRORS
  • Message XSD
  • Design Assumptions
  • Table Impact
• DSD Receipt Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Freight Terms Subscription API
  • Functional Area
  • Business Overview
    • Message Structure
  • Package Impact
    • Public API Procedures
    • Private Internal Functions and Procedures (rmssub_frttermcre.pls):
    • Private Internal Functions and Procedures (rmssub_fterm.pls):
    • Main Consume Function
    • XML Parsing
    • Validation
  • Message XSD
  • Design Assumptions
  • Table Impact
• 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
• Inventory Adjustment Subscription
  • Functional Area
  • Business Overview
    • Inventory Quantity and Status Evaluation
    • Stock Adjustment Transaction Codes
    • L10N Localization Decoupling Layer
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Inventory Request Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• 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
  • Design Overview
    • L10N Localization Decoupling Layer:
  • Package Impact
    • Consume Module
    • Business Validation Module
    • Bulk or single DML module
  • Message XSD
  • Tables
• Item Reclassification Subscription API
  • Functional Area
  • Design Overview
  • Bulk or Single DML Module
    • Consume Module
    • Business Validation Module
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• Location Trait Subscription API
  • Functional Area
  • Design Overview
  • Package Impact
    • Consume Module
    • Business Validation Module
    • Bulk or Single DML Module
  • Message XSD
  • Table Impact
• Merchandise Hierarchy Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • Filename: rmssub_xmrchhrs/b.pls
    • Filename: rmssub_xmrchhr[family_name]vals/b.pls
    • Filename: rmssub_xmrchhr[family_name]sqls/b.pls
    • Filename: rmssub_xmrchhrdept_cfa (rmssub_xmrchhrdept_cfas/b.pls)
    • Filename: rmssub_xmrchhrcls_cfa (rmssub_xmrchhrcls_cfas/b.pls)
    • Filename: rmssub_xmrchhrscls_cfa (rmssub_xmrchhrscls_cfas/b.pls)
    • Message XSD
  • Design Assumptions
  • Table Impact
• Merchandise Hierarchy Reclassification Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • Consume Module
    • Business Validation Module
    • Bulk or single DML module
  • Message XSD
  • Design Assumptions
  • Table Impact
• Organizational Hierarchy Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Tables
• Payment Terms Subscription API
  • Functional Area
  • Business Overview
    • Data Flow
    • Message Structure
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Table Impact
• PO Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
  • Message XSD
  • Design Assumptions
  • Tables
• Price Event Subscription API
  • Functional Area
  • Design Overview
  • Package Impact
    • Consume Module
    • Business Validation Module
    • Bulk or Single DML Module
  • Message XSD
  • Tables
• Receiving Subscription API
  • Functional Area
  • Business Overview
    • Carton-Level Receiving
    • Actual (A)
    • Overage (O)
    • Dummy BOL (D)
    • Doc Types
    • Blind Receipt Processing
    • L10N Localization Decoupling Layer
  • Package Impact
  • Message XSD
  • Table Impact
• RTV Subscription API
  • Functional Area
  • Business Overview
    • L10N Localization Decoupling Layer:
  • Package Impact
  • Message XSD
  • Table Impact
• 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
  • Business Overview
  • Package Impact
  • Message XSD
  • Table Impact
• 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
  • Business Overview
    • L10N Localization Decoupling Layer:
  • Package Impact
  • Message XSD
  • Table Impact
• 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
  • Business Overview
  • Package Impact
  • Message XSD
  • Table Impact

4 SOAP Web Service Provider Implementation

• Supplier Service API
  • Functional Area
  • Business Overview
  • Package Impact
    • Public API Procedures
    • Private Internal Functions and Procedures (rmsaiasub_supplierb/s.pls)
    • Private Internal Functions and Procedures (rmsaiasub_supplier_valb/s.pls)
    • Private Internal Functions and Procedures (rmsaiasub_supplier_sqlb/s.pls)
    • Private Internal Functions and Procedures (rmsaiasub_supplier_cfab/s.pls)
  • Design Assumptions
  • Table Impact
• Pay Term Service
  • Functional Area
  • Business Overview
  • Package Impact
    • Public API Procedures
    • Filename: rmsaiasub_ptrms/b.pls
    • Filename: rmsaiasub_ptrmvals/b.pls
    • Filename: rmsaiasub_ptrmsqls/b.pls
    • Filename: termsqls/b.pls
  • Message XSD
  • Table Impact
• Customer Order Fulfillment Subscription API
  • Functional Area
  • Business Overview
    • Web Service Deployment
    • RIB Deployment
  • Package Impact
    • Public Interface
    • Business Validation Module
    • Subscription Package
  • Message XSD
  • Design Assumptions
  • Table Impact
• Customer Order Item Substitution Service
  • Functional Area
  • Business Overview
  • Package Impact
    • Service Provider Layer
  • Message XSD
  • Design Assumptions
  • Table Impact
• Inventory Detail Lookup Service
  • Functional Area
  • Business Overview
  • Package Impact
    • PL/SQL Web Service Wrapper
    • Service Provider Layer
    • Core Logic Layer
  • Message XSD
  • Table Impact
• Inventory Back Order Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • PL/SQL Web Service Wrapper
    • Service Provider Layer
    • Core Logic Layer
  • Message XSD
  • Design Assumptions
  • Tables
• Customer Credit Check Web Service
  • Functional Area
  • Business Overview
    • Web Service Deployment
  • Package Impact
  • Design Assumptions
  • Table Impact
• Store Order Subscription API
  • Functional Area
  • Business Overview
  • Package Impact
    • PL/SQL Web Service Wrapper
    • Service Provider Layer
    • Core Logic Layer
  • Message XSD
  • Design Assumptions
  • Tables
• Item Number Reservation Service API
  • Functional Area
  • Design Overview
  • Package Impact
    • API Modules
  • Message XSD
  • Design Assumptions
  • Tables
• Order Management Service API
  • Functional Area
  • Design Overview
  • Package Impact
    • API Modules
  • Message XSD
  • Design Assumptions
  • Tables
• Average Cost Subscription API
  • Functional Area
  • Design Overview
  • Package Impact
    • API Modules
  • Message XSD
  • Design Assumptions
  • Tables
• Diff Management Service API
  • Functional Area
  • Design Overview
  • Package Impact
    • PL/SQL Web Service Wrapper
    • Package: DiffManagementServiceProviderISpec/Body.sql
    • Service Provider Layer
    • Core Logic Layer
    • Package: xdiffgrpb.pls
  • Message XSD
  • Design Assumptions
  • Tables

5 SOAP Web Service Consumer Implementation

• GL Account Validation Service
  • Functional Area
  • Business Overview
  • Package Impact
    • Public API Procedures
  • Message XSD
  • Design Assumptions
  • Table Impact
• Customer Order Address Service
  • Functional Area
  • Business Overview
  • Query Customer Order Address (queryCustomerOrderAddress)
    • Business Overview
    • Input Parameter
    • Output
    • Package Impact
    • Table Impact
• Customer Address Service
  • Functional Area
  • Business Overview
  • Retrieve Customer (retrieveCustomer)
    • Business Overview
    • Input Parameters
    • Output
    • Package Impact
    • Table Impact
• Transfer Management API
  • Functional Area
  • Design Overview
  • Package Impact
    • PL/SQL Web Service Wrapper
    • Package: TransferManagementServiceProviderImplSpec/Body.pls
    • Package: svcprov_xtsfs/b.pls
  • Message XSD
  • Design Assumptions
  • Tables

6 RESTful Web Service Implementation for RMS

• RMS Common Services
  • Vdate
  • Procurement Unit Options
    • Table Impact
  • Functional Config Options
  • Inventory Movement Unit Options
  • Currencies
  • Department Search
  • Department Load
• Code Detail Service
• VDATE Service
• Create Inventory Transfer Services
  • Functional Area
  • Business Overview
  • Transfer Number
  • Search Items
  • Load Items
    • Business Overview
  • Search From Location
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Search To Location
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Load Locations
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Create Transfer
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
• Create Purchase Order Services
  • Order Number
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Terms
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Search Supplier
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Load Supplier
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Search Items
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Load Items
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Search Location
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Load Locations
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Create Purchase Order
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
• Recent Inventory Transfer Services
  • Functional Area
  • Business Overview
  • Transfer Location Search
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Transfer Location Load
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Transfer Status List
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Transfer Type List
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Search Transfer User IDs
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Transfer Search
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Get Transfer Detail
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Update Transfer Status
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
• Recent Purchase Order Services
  • Functional Area
  • Business Overview
  • Cancel Reason Code List
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Origin Code List
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Purchase Order Status List
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Search Purchase Order User ID
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Purchase Order Search
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Get Purchase Order Summary
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Get Purchase Order Items
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Get Purchase Order Item Locations
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Update Purchase Orders Date
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Cancel Purchase Orders
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Approve Purchase Orders
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Reject Purchase Orders
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
• Replenishment Schedule Services
  • Functional Area
  • Business Overview
  • Create Replenishment Schedule
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Modify Replenishment Schedule
    • Business Overview
    • Service Type
    • ReST URL
    • Input Parameters
    • Output
    • Table Impact
  • Delete Replenishment Schedule
    • 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
• Purchase Order 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
• Allocation Detail Service
  • 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
• Diff Detail Service
  • Business Overview
  • Service Type
  • ReST URL
  • Input Parameters
  • Output
  • Table Impact
• Half Data Budget Service
  • Business Overview
  • Functional Area
  • Modify Half Data Budget
    • Business Overview
    • Service Type
    • Rest URL:
    • Input Parameters
    • Output
    • Table Impact
• 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
• Reclass 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 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
• Platform Data Privacy REST Services
  • Functional Area
  • Business Overview
  • Configuration Files
  • Package Impact
    • Right to Access
    • Right to Forget
    • Tables

7 Bulk Data Integration

• Business Overview
• Brand Publication BDI
  • Functional Area
  • Design Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Calendar Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Code Detail Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Code Head Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Currency Conversion Rates Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Delivery Slot Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Finance General Ledger Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Finisher Address Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Diff Group Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Diff ID Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Inventory Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Item Image Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Item Location Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Item Master Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Item Supplier Country Dim Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Item Supplier Country Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Item Supplier Manufacturing Country Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Item Supplier UOM Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Item Supplier Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Merch Hierarchy Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• On Order Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Organization Hierarchy Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Pack Item Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Partner Address Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Partner Org Unit Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Partner Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Price History Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Related Item Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Replenishment Item Location Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Store Address Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Store Available Inventory Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Store Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Supplier Address Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Sups Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Tran Data Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• UDA Item Date Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• UDA Item FF Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• UDA Item LOV Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• UDA Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• UDA Values Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• UOM Class Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• UOM Conversion Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
  • Data Definition XML
  • Table Impact
• Warehouse Inventory Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Warehouse Address Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact
• Warehouse Publication BDI
  • Functional Area
  • Business Overview
  • Package Impact
    • Bulk Interface Module
  • Data Definition XML
  • Table Impact

A RIB_XML

• Generating XML Documents
  • Adding Elements to the Tree
  • Example 1: Generating an XML document
  • Reading XML documents
  • Example 2: Reading an XML document
  • Additional Reading