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