RMS Functional Interfaces

Disclaimer: This document is a general data mapping and reference guide for data coming in and out of Oracle Retail application systems via RIB messages; it is not meant to give detailed information about every possible data scenario

Publishes	Subscriber To
Allocations (Stock Orders)	ASN Out Bound (BOL)
Differentiators (Group and Detail)	ASN Inbound
Item Location	Direct Store Delivery (DSD) Deals
Items	Direct Store Delivery (DSD) Receipt
Merchandising Hierarchy	Inventory Adjustments
Purchase Order	Inventory Requests
Partners	Return To Vendor (RTV)
Return To Vendor Requests	Receiving
Receiver Unit Adjustment	Regular Price Change
Seed Data	Stock Order Status
Locations (Stores, Partners,Warehouse)	Stock Count Schedule
Stores
Transfers (Stock Orders)	Allocations (Stock Orders)  (E)
UDAs	Differentiators (Group and Detail) (E)
Vendor	Clearances  (E)
Warehouse	Cost Changes (E)
Work Order Inbound	Cost of Goods Adjustment  (E)
Work Order Outbound	Customer Order Sales / Return Sales  (E)
	Currency Rates (E)
	Direct Ship Receipt (E)
	Freight Terms  (E)
Banners / Channels (Brands) (E)	General Ledger (GL) Chart of Accounts (COA)  (E)
	Item Location (E)
	Item Reclassification  (E)
	Item (E)
	Location Trait (E)
	Merchandise Hierarchy Reclassification  (E)
	Merchandising Hierarchy (E)
	Purchase Order (E)
	Organizational Hierarchy (E)
	Payment Terms (E)
	Price Change Requests (E)
	Seed Object (E)
	Store (E)
	Transfers (Stock Orders)  (E)
	Vendor (E)
	Work Order Status (E)

* E = External (3^rd Party) Application Integration – Not Oracle Retail
RMS Adapters and JMS Topics

Functional Area	RMS PUB	RMS PUB JMS Topics
Allocations (Stock Orders)	Alloc_pub	etAllocFromRMS
Banners / Channels (Brands) (E)	Banner_pub	etBannerFromRMS
Differentiators Group	DiffGrp_pub	etDiffGrpFromRMS
Differentiators Detail	Diffs_pub	etDiffsFromRMS
Item Location	ItemLoc_pub	etItemLocFromRMS
Items	Items_pub	etItemsFromRMS
Merchandising Hierarchy	MerchHier_pub	etMerchHierFromRMS
Purchase Order	Order_pub	etOrderFromRMS
Partners	Partner_pub	etPartnerFromRMS
Return To Vendor Requests	RcvUnitAdj_pub	etRTVReqFromRMS
Receiver Unit Adjustment	RTVReq_pub	etRcvUnitAdj
Seed Object (E)	SeedObj_pub	etSeedObj
Seed Data	SeedData_pub	etSeedData
Stores	Stores_pub	etStoresFromRMS
Transfers (Stock Orders)	Transfers_pub	etTransfersFromRMS
UDAs	UDAs_pub	etUDAsFromRMS
Vendor	Vendor_pub	etVendorFromRMS
Warehouse	WH_pub	etWHFromRMS
Work Order Inbound	WOIn_pub	etWOInFromRMS
Work Order Outbound	WOOut_pub	etWOOut
Functional Area	RMS SUB	RMS SUB JMS Topics
ASN Inbound	ASNIn_sub	etASNIn
ASN Out	ASNOut_sub	etASNOutAT
Cost of Goods Adjustment  (E)	COCogs_sub	etCOCogs
Customer Order Return Sales (E)	COReturn_sub	etCOReturn
Customer Order Sales (E)	COSale_sub	etCOSale
Currency Rates (E)	CurRate_sub	etEXTCurRate
Direct Ship Receipt (E)	DSRcpt_sub	etDSRcpt
Direct Store Delivery (DSD) Deals	DSDDeals_sub	etDSDDeals
Direct Store Delivery (DSD) Receipt (PUBs to DSDDeals)	DSDReceipt_sub	etDSDReceipt
Freight Terms  (E)	FrtTerm_sub	etEXTFrtTerm
General Ledger (GL) Chart of Accounts (COA)  (E)	GLCOA_sub	etEXTGLCOA
Inventory Adjustments	InvAdjust_sub	etInvAdjust
Inventory Requests	InvReq_sub	etInvReq
Open To Buy (PUB is Receiving SUB)	OTB_sub	etOTB
Payment Terms (E)	PayTerm_sub	etEXTPayTerm
Return To Vendor (RTV)	RTV_sub	etRTV
Receiving	Receiving_sub	etReceiving
Regular Price Change	RegPrcChg_sub	etRegPrcChgFromRPM
Stock Order Status	SOStatus_sub	etSOStatusAT
Stock Count Schedule	StkCountSch_sub	etStkCountSch
Vendor (E)	Vendor_sub	etEXTVendor
Work Order Status (E)	WOStatus_sub	etWOStatus
Allocations (Stock Orders) (E)	XAlloc_sub	etXAlloc
Clearances (E)	XClearance_sub	etXClearance
Cost Changes (E)	XCostChg_sub	etXCostChg
Differentiators Group (E)	XDiffGrp_sub	etXDiffGrp
Differentiators Detail (E)	XDiffID_sub	etXDiffID
Item (E)	XItem_sub	etXItem
Vendor (E)	Vendor_sub	etEXTVendor
Item Location (E)	XItemLoc_sub	etXItemLoc
Item Reclassification   (E)	XItemRcls_sub	etXItemRcls
Location Trait (E)	XLocTrt_sub	etXLocTrt
Merchandise Hierarchy Reclassification  (E)	XMrchHrRcls_sub	etXMrchHrRcls
Merchandising Hierarchy (E)	XMrchHr_sub	etXMrchHr
Purchase Order (E)	XOrder_sub	etXOrder
Organizational Hierarchy (E)	XOrgHr_sub	etXOrgHr
Price Change Requests (E)	XPriceChg_sub	etXPriceChg
Seed Object (E)	SeedObj_pub	etSeedObj
Store (E)	XStore_sub	etXStore
Transfers (Stock Orders) (E)	XTsf_sub	etXTransfer