1 Overview

Oracle Payment Interface (OPI) is a payment card-processing interface that integrates with the Oracle Hospitality Point-of-Sale (POS), OPERA, Suite 8 (PMS) and Retail (POS) systems. It defines a standard interface that partner payment service providers can implement to provide credit card processing functionality to Oracle Hospitality OPERA, POS and also Oracle Retail Point of Sale (POS) Systems.

This guide provides information relating to the OPI transaction types for compatibility of Xstore and EFTLink for payment terminal functionality of each Oracle payment partner.

Where the Oracle payment partner does not support an OPI transaction type that is supported by Xstore and EFTLink, it will be left blank to show that there is a gap in that Oracle payment partner's solution. It will be up to the Oracle payment partner or system integrator to suppress that feature in Xstore to ensure that the transaction type is not executed to the point of failure.

Note:

Although Oracle are validating the OPI transaction types, Oracle is not responsible for support, this is the responsibility of the Oracle payment partner solution providers. The customer or system integrator should always approach the Oracle payment partner in the first instance who should be able to understand and analyze EFTLink logs in order to determine whether the issue is with their solution or EFTLink. If a problem is found within EFTLink, then the system integrator should go through the standard Oracle support channel in order to facilitate a resolution.

The following Oracle payment partners are validated:

The table below represents the OPI Retail transaction processing messages which are referenced in the validation table for each Oracle payment partner:

Table 1-1 OPI Retail Transaction Processing Messages

Message Type Transaction Type Function Description Mandatory, Optional, Recommended Comments

Sale/Purchase

01

Sale/Purchase

Mandatory Including Credit Debit, Customer Not Present

Refund

03

Refund

Mandatory  

Manual Authorization

37

Manual Authorization

Optional  

Sales Completion

07

Sales Completion

Optional  

Void

08

Void

Mandatory  

39

Void of Refund

Recommended  

Reversal

04

Reversal

Mandatory  

Trans Inq

20

Transaction Inquiry

Recommended  

Balance Inq

27

Balance Inquiry

Optional  

Settlement

10

End-of-Day/Settlement

Optional  

Gift/SVC

28

Gift/SVC Reload

Optional  

29

Gift/SVC Activate/Issue

Optional  

30

Gift/SVC Redeem

Optional  

31

Gift/SVC Void

Optional  

32

Gift/SVC Cashout (or Close Card)

Optional  

ItemAdvice

43

Line Item Advice

Recommended  

Sale End

45

Sale End (Clear Terminal Screen)

Recommended  

Read Non-PCI Card

50

Request non-PCI card swipe

Recommended  

Check Authorization

51

Check (Cheque) Authorization

Optional  

Void Check Authorization

52

Void Check Authorization

Optional  

Cancel Current Transaction

53

Cancel current transaction

Recommended  

Get Agreement

60

Custom Forms - Get Agreement

Optional  

Get Signature

61

Custom Forms - Get Signature

Optional  

Get Numeric Field

62

Custom Forms - Get Numeric Field

Optional  

Get AlphaNumeric Field

63

Custom Forms - Get AlphaNumeric Field

Optional  

Get Date Field

64

Custom Forms - Get Date Field

Optional  

Get Button Selection

65

Custom Forms - Get Button Selection

Optional  

Get Radio Button Selection

66

Custom Forms - Get Radio Button Selection

Optional  

Display Message

67

Custom Forms - Display Message

Optional  

Display QR Code

68

Custom Forms - Display QR Code

Optional  

Cancel QR Code

69

Custom Forms - Cancel QR Code

Optional  

Card Acquisition

09

Card Acquisition (Pre-read)

Recommended Tax Free Shopping, QuickChip, Loyalty (such as, AppleVAS) and so on
Cell Phone Recharge 54 Cell Phone Recharge Optional Common in LAD
Invoice Payment 55 Invoice Payment Optional Common in LAD