Go to primary content
Oracle® Retail POS Suite Implementation Guide, Volume 1 – Implementation Solutions
Release 14.1
E54475-02
Index
Next
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Related Documents
Customer Support
Review Patch Documentation
Improved Process for Oracle Retail Documentation Corrections
Oracle Retail Documentation on the Oracle Technology Network
Conventions
1
Introduction
2
Oracle Retail POS Suite Technical Architecture
Back Office and Central Office Tier Organization
Client Tier
Middle Tier
Model
View
Controller
Data Tier
Dependencies in Application and Commerce Services
Example of Operation
Point-of-Service Architecture
Design Patterns
MVC Pattern
Factory Pattern
Command Pattern
Singleton Pattern
Returns Management Architecture
General Technologies and Frameworks
Architectural Styles and Patterns
Conceptual Modules
Enabling Technologies
JEE
Struts
Axis
Web-Based User Interface
Physical Module View
User Interface Layer
Consumer Adapter Layer
Service Layer
Data Layer
Messaging
3
Store Database
Point-of-Service Store Database
ARTS Compliance
Understanding Data Managers and Technicians
How Data Transactions Work
Creating or Updating Database Tables
Example of Saving Data: Storing Till Information
Research Table Requirements and Standards
Saving Data from Site Code
Locate Data Operation
Modify Data Operation
Test Code
Verify Data
Central Office and Back Office Store Database
Related Documentation
Database/System Interface
ARTS Compliance
Bean-Managed Persistence in the Database
DAO-Managed Persistence in the Database for Back Office
4
Backend System Administration and Configuration
Parameters
Parameters in Back Office and Central Office
Parameters in Point-of-Service
Parameter Hierarchy
Parameter Group
Parameter Properties
Running Back Office or Central Office
Running Returns Management
Establishing a Store Hierarchy in Central Office or Returns Management
Importing Data in Returns Management
Point-of-Service Devices
Set Up the Device
Test the Device
Create a Session and ActionGroup
Simulate the Device
Scheduling Post Processors in Back Office
Scheduling Post Processors in Returns Management
Data Management in Central Office
Help Files in Point-of-Service
Modifying Help Files in Central Office, Back Office and Returns Management
Modifying Help Files in Point-of-Service
Reason Codes in Point-of-Service
Configuring Transaction ID Lengths
Understanding Transaction IDs
Changing Transaction ID Format
Configuring the Purchase Date Field for Returns and Voids
Configuring RMI Timeout Intervals in Point-of-Service
Setting the RMI Timeout Interval for the JVM Under Linux
Modifying the TCP Connection Timeout on Linux
Setting the RMI Timeout Interval for All Manager and Technician Calls
Setting Application Timeout Values on Linux
Setting the RMI Timeout Interval for a Specific Technician
System Settings in Point-of-Service
Configuring Logging in Point-of-Service
Returns Management Environment Entries in ejb-jar.xml
Return Ticket Formatting Entries
Auditing Entries
Defining Security with Roles
Secured Features
Security Implementation—Warnings and Advice
Configuring Security in Returns Management
5
Audit Logging
Configuring the Audit Log
Internationalize Static Text/Date/Time/Currency
Daily Operations Audit Log Events
Enter Business Date
Start of Day
End of Day
Register Open
Register Close
Point-of-Service Transaction Events
Transaction Tendered with Credit Card
Transaction Tendered with Debit Card
Employee Audit Log Events
Modify Employee Information
Modify Temporary Employee Information
Add Employee
Add Temporary Employee
Login, Logout, Lockout Audit Log Events
User Login
User Lock Out
User Logout
Password Audit Log Events
Change Password
Reset Employee Password
Reset Temporary Employee Password
Role Audit Log Events
Edit Role
Add Role
Till Audit Log Events
Till Open
Till Suspend
Till Resume
Till Close
Count Float at Reconcile
Till Reconcile
Parameter Log Events
Modify Application Parameter
6
Intra Store Data Distribution Infrastructure
Spring Configuration
Application Configuration
Integration Considerations
DataSet Compressed File Structure
DataSet Compressed File Example
Manifest File Structure
Manifest File Example
DataSet Flat File Structure
DataSet Flat File Example
Extensibility
Adding New Table To Existing DataSet
Adding More Tables To Existing DataSet Types
Adding a Table to an Existing Data Set Using the Stores Build Scripts
Adding a New DataSet
Adding a New DataSet Using the Stores Build Scripts
Configuring Schedule for DataSet Producer and Consumer
Configure DataSet Producer
Configure DataSet Consumer
Adding New DataSet Type
Adding a New DataSet Type Using the Stores Build Scripts
Changing Point-of-Service Client Database Vendor
7
Centralized Customer
8
Changing and Configuring Currencies
Alternate Currencies
Changing Currency
Configuring a New Base Currency
Currency SQL Configuration
Currency Table CO_CNY
Currency Denomination Table CO_CNY_DNM and I8 Table CO_CNY_DNM_I8
Exchange Rate Table CO_RT_EXC
Store Safe Tender Table LE_TND_STR_SF
Parameter Configuration
Resource Bundle Configuration
9
Returns Management
Overview
Concept of a Return in Returns Management
Context Model
Oracle Retail Returns Management Actors
Tax Responsibility in Oracle Retail Returns Management
Functional Overview
Conceptual Service Flow
Conceptual Data Flow
Functional Assumptions
Functional Overviews
Return Tickets Functional Overview
Exception Files Functional Overview
Messages and Responses Functional Overview
Policies and Rules Functional Overview
Analytic Engine Functional Overview
Integration Methods and Communication
Methods of Contact
Returns Management Messages
Sample XML for Return Transaction Scenarios
Point-of-Return to Returns Management—Initial Return Request
Returns Management to Point-of-Return—Initial Return Response: Need Positive ID
Point-of-Return to Returns Management—Second Return Request
Returns Management to Point-of-Return—Second Return Authorization Response
Point-of-Return to Returns Management—Return Result from Second Response
Point-of-Return to Returns Management—Void Return
Offline Return Result
Implementation Decisions
Asynchronous Versus Synchronous Communication
XML Versus JavaBean Messages
Web Service Versus Enterprise JavaBeans and Remote Method Invocation Call
Elements
Return Request
Return Response
Return Result
Web Service Interface
Relationship of Returns Management Data to ARTS Transaction Data
Returns Authorization
Exception Flow
Error Handling
Logging
Exceptions File
Exception File and Count Calculation
Definition of Return, for Calculation
Exceptions
Customer Exceptions
Cashier Exceptions
Customer Data Import
10
Authorized Payment Foundation
Authorized Payment Foundation Overview
APF Goals
Point-of-Service Client Flow Overview
Implementing a New Authorization Service
APF Request/Response Modifications
Database Modifications
Point-of-Service Client Tour Modifications
COMMEXT Connectors/Formatters Implementation
COMMEXT Configuration Modifications
APF Request Types
APF Authorize Payment (Transfer) Request Classes
APF Reversal Request Classes
APF Instant Credit Request Classes
APF Call Referral Request Classes
APF Signature Capture Request
APF Customer Interaction Request
APF Status Request
APF Get Card Token Request
APF Response Types
Calling PaymentManger from Point-of-Service Tours (Services)
CPOIPaymentUtility
PinComm Technician
Example Topology
PinComm Connectors
PinCommConnector
PinComm CardAuthConnector
PinComm OnePassCardAuthConnector
PinComm AuthorizeCallReferralWithoutTokenConnector
PinComm StatusInquiryConnector
PinComm PinCommCPOIConnector
PinComm CardTokenInquiryConnector
PinComm ReentryAuthConnector
PinComm Formatters
PinComm CardAuthFormatters
PinComm Check Formatters
PinComm Configuration
PXP Solutions ANYpay POS
JAXBFormatter
ServebaseFormatter
ChainedConnector
ServebaseConnector
SocketConnector
SocketThread
Configuration
Message Formats
Response Codes
AJB Technician
AJB Topology
AJB COMMEXT Connectors
AJB COMMEXT Formatters
AJB Codes
AJB Utilities
Mapping of AJB Action Codes to Point-of-Service Authorization Responses
Action Codes
Mapping Tables
References
Training Mode
11
Point-of-Service
Bill Pay
Automated E-Mail Messages
Register Cash Notification
Configuration
application.xml
application.properties
dialogText_en.properties
posText_en.properties
Scan Sheet
Scan Sheet Data Configuration
Application.properties
Inserting and Configuring a Category
Inserting an Image
Item Images
Images for Mobile Point-of-Service
Serial Numbers
Configuration
Enabling or Disabling Serialization Functionality
Enabling or Disabling IMEI Functionality
Currency Rounding
Configuration for Currency Rounding
Cross-Border Returns
Configuration for Cross-Border Returns
Dual Display
Configuration for the Dual Display
application.properties Configuration File
Parameters
Dashboard
Configuration for the Dashboard
Fiscal Printer Support
Notifications
Central Office
Point-of-Service Installation
Configuration
Integration with Oracle Retail Store Inventory Management
Integration using a Web Service
Item Disposition
Error Handling
Logging
Integration using Batch Files
Integration Middleware for SIM Batch Files
System Flow Description
Integration Architecture
Integration with External Systems using SOAP Web Services
Configuration Option to Resolve the WSDL Location
12
Receipt Builder
Receipt Builder XML Blueprint Files
Example XML Blueprint File
Receipt Builder XSD
Configuration
Conduit Configuration
Manager Configuration
Spring Configuration
Receipt Messages
Updating the Legal Statement of Liability on a Receipt
Item Level Receipt Messages
Rebate Receipt
13
Back Office
Deploying Reports
A
Appendix: Examples of Currency Rounding
Swedish Rounding
Round Up
Round Down
B
Appendix: Reconfiguring a JAXWSConnector
Glossary
Index