Oracle integration
Hypersoft offers all relevant Oracle PMS connectivity and has all relevant certificates, as well as Gold Partner status with Oracle to secure your investment in this powerful combination.
Oracle PMS POS Certificates
Select and download certificate:
Oracle PMS versions confirmed as compatible
Oracle announces that one of the following program versions is required for functional activation:
- Opera 5 PMS
- V5.0.03.03 E43
- V5.0.04.01 E24
- V5.0.04.02 E17
- V5.0.04.03 E10
- V5.5.0
- Opera Cloud
- V1.20
- Fidelio Suite8
- V8.9.6.10
Using Best Practice YourAPP with Oracle
Turn your hotel into a digital hotel overnight with Hypersoft and Oracle!
The Hypersoft YourAPP project is the perfect complement for your gastronomic service offer. How about a QR in the room with which you communicate exactly the right offers time-controlled? An app is there, but does not need to be installed! The YourAPP project makes it possible to use the order functions and offers barrier-free also as a website - visually hardly distinguishable.
YourAPP can do so much more, book tables in the restaurant or wellness treatments, point out promotions, offer vouchers, collect points, promote other locations, you can even sell tickets and use an integrated retail shop for your brand products.
Of course, Hypersoft also masters in-house ordering at the table par excellence and you can sell very special products down to the last item, as YourAPP would never offer sold-out goods - a function that, with the option to intervene manually, always allows you to adapt your offer to the available resources in minutes.
Special services: Credit limit
This PMS interface supports a credit for hotel guests. If such a value is received via the interface, it can only be posted at the POS up to the transfer limit. If you are logged in as a manager, the limit can be exceeded. Alternatively, you can generally deactivate the function in the interface by activating Cancel credit limit. The exceedance is then passed to the PMS as expected.
Special services: NOPOST
This PMS interface supports the NOPOST function. This information is transferred from the Oracle PMS to the hypersoft system for certain rooms. If this variable is included in a room query, it cannot be booked in this room. With the checkout function Hotel: Check room numberyou can check the negative status of such a room.
The PMS interface with the selection ORACLE Fidelio Suite 8
The example shows the possible settings and any selection:
Most switches apply to all connections and are documentedon the main page. Here are the special features for Oracle:
| Element / Switch | Function / Description |
|---|---|
| Use sales distribution for merchandise categories | Sales distribution enables you to address two different merchandise categories from a single item. For details see: Sales distribution with PMS integration |
|
VAT Redirect Table 2... |
The VAT setting Table 2 redirect to Oracle SubTotal 14 is for systems in Germany. This is where the Außer Haus MwSt. specially treated. Outside Germany, the switch is supposed to be switched off. |
| Use invoice numbers instead of document numbers | Document numbers also include other documents besides invoices. In most cases, it is desirable to transmit only invoice numbers if only invoices are transferred to the PMS. |
| Cancel credit limit | If you activate the switch, any credit limits of the room guests are not taken into account and can therefore be exceeded.n |
| Consider expenses | It's always possible. |
| Do not display notes | The additional notes (message fields with yellow background) at the stations can be switched off with this. |
| Only transfer room bookings (all) | Frequently, all sales of the POS systems are transferred to the PMS (including those that are not booked in rooms). This enables the PMS to create evaluations. This allows you to restrict the transmission to pure room bookings. |
| Use interface number |
Since Oracle can only process 13 commodity groups at this point, you can switch on Use interface number to extend the possibilities in this regard. This switch then makes it possible to combine several merchandise groups at the POS using the same interface numbers and to transfer these numbers to a merchandise group specified by Oracle. Further documentation: Reconcile merchandise categories |
| Only transfer room bookings to station | If one or more station numbers separated by semicolons are entered in this field, then only the "bookings to room" and no other payments cash payments will be transferred to Oracle from these stations. |
| Consider 2-digit alphanumeric room names |
For a room or guest search in an Oracle PMS, the search term must be at least 3 characters long. For room names such as Z1 (which are authorised in Oracle), the search is not carried out and a message is displayed. To avoid this problem, the 2-digit alphanumeric room names switch can be activated. A search term of less than 3 characters is not desired according to Oracle's specification, as this can lead to the transfer of long lists which place a load on the Oracle server. If the room names are set up correctly on the Oracle PMS side, either with at least 3 characters or as a purely numerical value (which can then also be 1 digit!), this situation does not normally occur. This switch should therefore only be used in special cases that you as the hotel owner have agreed with Oracle. |
Administrators and Installers
- The interface is filled with merchandise category totals. Tips and expenses are transmitted separately. Observe the tax requirements.
- Vouchers are transmitted as expenses. Bonus vouchers and item vouchers are transmitted as sales merchandise groups, since tax is included.
- Oracle Fidelio Suite8 and Oracle Opera are a client / server application. The data exchange takes place via a socket port in XML format.
- No bookings with individual item data are supported by the Oracle PMS interface in order to transmit an invoice in detail.
- Up to 16 categories can be transmitted. Hypersoft has reserved the 16th product group for assigning item bookings that are not assigned to any of the maximum other categories to the 16th product group. The 15th merchandise category is reserved for out-of-pocket expenses (all out-of-pocket expenses are assigned there) and the 14th merchandise category is fixed for out-of-home sales. Even if you do not address these functions in Hypersoft, these categories cannot be used elsewhere.
- Another special feature of the Oracle interface is that only the main groups are used as assignment. Although you can use categories and subgroups for the items as usual in Hypersoft, only the assigned main group of the respective item is used in the interface.
- Since Oracle hotel programs are used worldwide, they are not necessarily adapted to all local regulations. We have pointed out possible solutions for this elsewhere.
- According to Oracle support, a matchcode search with only one character is not possible because it could lead to a memory overflow. We have therefore set the search term for the name search to at least 3 characters. So when searching with mPOS, operators must enter at least 3 characters, otherwise the search result on mPOS will remain empty.
Back to the parent page: Noteworthy aspects of the Hotel PMS integration