Oracle POS - Standards
- Benet, Anton
- Silva, Carlos
Contents
Overview
This page summarises the menu structure and identifier standard that must be followed by Franchisees to make the Oracle configuration compatible with the RBI Digital Platform.
Menu Configuration
Oracle Symphony offers multiple ways of configuring a menu. The following guides detail how a menu must be configured to be RBI-compliant.
PLU, Definition Sequence and Price Sequence are the 3 Oracle attributes which we will use to distinguish across different structures, service modes and modifier quantities.
The logic behind the menu configuration is that the combination of these 3 attributes will always lead to a unique PLU for each menu structure. For example, a single Whopper for delivery will have a unique PLU.
These are the 3 Oracle attributes:
Attribute | Description | Oracle’s Enterprise Management Console (EMC) Image |
|---|---|---|
Oracle PLU | The Oracle PLU (Price Look-Up codes) is the unique record number that identifies each Menu Item Master. |  In this example, the Oracle PLU is 1001001 |
Definition Sequence ( | Definition sequences are defined in each Menu Item Master and they can change the behavior of the item they’re connected. For example, the same Menu Item Master can be displayed differently in the POS touchscreens and receipts using different definition sequences. Each Menu Item Master can have up to 64 menu item definitions. | In this example, the Oracle PLU 1001001 has two definition sequences: 1 and 2. |
Price Sequence ( | Price sequences are defined for each definition sequence. Definition sequences can have multiple prices. |
|
In summary, Menu Item Masters contain the Oracle PLU. Each PLU has one ore more definition sequences, and each definition sequence has one or more price sequences.
So the Menu Item Object Number alone isn't enough. We also need the Definition Sequence and Price Sequence to fully specify the item's price and availability.
You can find the menu configuration guides here: Oracle Config - Menu.
Unique Identifiers
The reason we use a unique PLUs (Product Look Up code) for the menu structure (by combining PLU, Price Sequence and Definition Sequence attributes) is that the RBI Platform needs unique PLUs internally to function as expected – it will determine both price and availability of the menu item. Internally, the RBI Platform will concatenate each attribute, separated by a dash, to create a unique PLU.
For example, for an item with Menu Item Master ID 200137, definition sequence 1 and price sequence 2 (Delivery), the following PLU will be generated: 200137-1-2.
Our recommendation is to use:
For menu items:
Price Sequence to distinguish between service modes, where 1 is Pickup and 2 is Delivery. It is also possible (but not recommended) to use Definition Sequence to distinguish between service modes.
Definition Sequence to be always 1.
For modifiers:
Price Sequence to distinguish between service modes and Add/No modifiers (details here). It is possible (but not recommended) to use different Menu Item Master ID’s than those mentioned in the linked documentation. It is also possible (but not recommended) to use Definition Sequence instead.
Definition Sequence to be always 1.
Take the Whopper:
In Oracle, the Whopper might have an Object Number of
1001001.If it's sold In-Restaurant with a specific price and availability, it might have a Definition Sequence of 1 and a Price Sequence of 1.
So, the correct mapping for the In-Restaurant Whopper in RBI Digital would be:
1001001-1-1.
By understanding these unique identifiers and how they're combined, you can accurately configure your POS system to ensure correct pricing and availability for all your menu items in RBI Digital.
More details can be found in each sub-section of the Oracle POS - Configuration documentation.
The approach above needs to be the same for all structures – i.e. you can’t use PLUs to distinguish service modes for items and definition sequences for combos.
Deviations from the proposed structure are not recommended. The recommended approach will results in a faster rollout and less issues, and new features will be built based on the recommended structure.