Oracle POS (360 Commerce) integration with EBS
A solution for Transit Agencies
October 24, 2011 (2:10 PM)
Presented By
Srinivas Chundu
[email protected]
Pavan Vallabhaneni
[email protected]
Agenda
Challenges
Oracle Point of Sale (POS)
Infrastructure
Technical Architecture
Integration with EBS
Reporting & Dashboards
Reconciliation
Challenges
Implementation Challenges
Mix of applications
Multiple platforms
High transaction volumes
Quick response times
Oracle Point of Sale (POS)
POS Architecture
Client
Server
Centralized vs. Distributed
POS Capabilities
Multi-Tiered Architecture
Highly Available
Centralized Transaction Retrieval
Adaptability & Scalability
Customizability
Hardware
Multiple Vendors
JPOS drivers
POS Client Architecture
Others
360 Platform Container
(Execution platform and application environment)360 Application Commerce Services
User Interface Con figuration Integra tion Application Services Foundation
Services Domain Objects
Tour Engine Custom JMS HTTP Java
Database Enterprise Apps
Application and
system XML
scripts configure
the layers of the
application.
Integration
framework.
POS Client Architecture
Others
360 Platform Container
(Execution platform and application environment)360 Application Commerce Services
User Interface Con figuration Integra tion Application Services Foundation
Services Domain Objects
Tour Engine Custom JMS HTTP Java
Database Enterprise Apps
Client presentation and
device interaction.
Application-specific
business processes.
POS Client Architecture
Others
360 Platform Container
(Execution platform and application environment)360 Application Commerce Services
User Interface Con figuration Integra tion Application Services Foundation
Services Domain Objects
Tour Engine Custom JMS HTTP Java
Database Enterprise Apps
Tour engine is the
controller for POS
POS Client Architecture
Others
360 Platform Container
(Execution platform and application environment)360 Application Commerce Services
User Interface Con figuration Integra tion Application Services Foundation
Services Domain Objects
Tour Engine Custom JMS HTTP Java
Database Enterprise Apps
Application-independent
technical services
POS Client Architecture
Others
360 Platform Container
(Execution platform and application environment)360 Application Commerce Services
User Interface Con figuration Integra tion Application Services Foundation
Services Domain Objects
Tour Engine Custom JMS HTTP Java
Database Enterprise Apps
Specific business
objects that contain
application data.
Server Architecture
Store Environment
Corporate Data Center
POS Terminal (20 per store ) Java POS ORPOS Client (1 per terminal) Local DB Me s s ag ing
ORPOS Server Store DB J2EE Container ORBO Messaging Server File Transfer Server Messaging File Transfer Middleware Secure Key Management Server Encryption Key Manager ORCO Server J2EE Container ORCO ORRM Server J2EE Container ORRM Database Server ORRM DB ORCO DB Payment Switch
Store Servers
POS Capabilities
Multi-Tiered Architecture
Highly Available
Centralized Transaction Retrieval
Adaptability & Scalability
Hardware
Supported Hardware
Component HP Stack IBM Stack
Register HP POS
rp5700RT047AV-POS
SurePOS 700 (741)
Cash drawer HP cash drawer #EY024AA IBM cash drawer
Pole Display None IBM pole display
Keyboard HP USB POS #EY025AA IBM keyboard
Scanner HP USB #EY022AA Symbol Scanner LS2208
PIN Pad Ingenico eNTouch 6580
Verifone MX860
Ingenico eNTouch 6580 Verifone MX860
Credit Card Reader HP USB MSR #EY026AA Ingenico eNTouch 6580
Verifone MX860
Receipt Printer HP USB Thermal Receipt
Printer #EY023AA
IBM printer 4610 IBM printer 4610-2CR
•JavaPOS is the industry standard for Java compatibility for retail-oriented devices.
•Common devices used with point-of-sale are listed above
•Any JavaPOS-compliant peripheral devices should work with Oracle Retail Point-of-Service,
however, some may require software modifications to work properly
Infrastructure
DSL Network Connectivity for POS Terminals
Internet
Downtown Store Network Outlying Store Network
Corporate Data Ceneter
Station 1 Station 2 DSL DSL VPN $ Bank Station ... DS L Pos 1 Pos 2 Pos ... VPN Router Corporate Network
T1 Line with the Backup T1 Store Servers for outlying Stations Payment Switch POS Data Credit Card Data
VPN
VPN
Downtown Store Servers
Infrastructure…
Central Office Store Hub
Back Office / Store Server Payment Switch CORP STORE Transactions Transactions Parameters Empl, Item, Price Credit Authorization Bank
Integrating with Oracle EBS
Items & Pricing
Employee & Access
Daily Sales & Deposits Customers & Accounts
Order
Management
Oracle
Receivables
Inventory
Human Resources
Returns & Exchanges
Items
Employee
POS Agents
Sales, Returns
&
Exchanges
Integration….
Order Management API
Sales Order per POS Agent by shift
Deposits as Prepayments AR Receipts AR Invoices Inventory Removal Min-Max Planning
Prepayments
Matching
Cash Management Auto ReconImport Bank
Statements
PO Internal OrderingInventory
Interface
Sales Order
Creation
Auto Invoice
Sales Order
Reporting & Dashboard
Order Management Oracle Receivables Inventory Human Resources
