Oracle Workshop Agenda

Owned by Silva, Carlos
Last updated: Oct 28, 2024 by Marrara, Jean
3 min read

Agenda for the Oracle workshop happening from Oct 29, 2024 to Oct 30, 2024.

Transactions

Categories: Store availability Pricing & availability menu structure ORDER INJECTION

 

  • Store availability Webhook for store status or Cron Job?

  • Pricing & availability Does Oracle expose pricing & availability changes via a webhook? Currently Khumbu relies on a daily sync to get that information and update P&A in RBI’s platform.

    • If yes:

      • Does the webhook expose the actual DIFF (e.g. items created, updated or deleted with associated PLUs) or only notifies ‘'something changed’'?

      • Does the webhook do any bundling? For example, are the frequent updates within a short time period (e.g. 1 minute) sent as one update or every single change is published separately?

      • Is there versioning for the menu available within the webhook or part of a separate API call? (E.g. Version x.y. becoming version x.y+1 after a change)

  • Pricing & availability P&A sync failure handling: Re-tries and backups

    • Caching and latency

  • Pricing & availability Automated POS PLU sync from Oracle to Sanity (RBI CMS):

    • Possible to have an automated process (e.g. with APIs) without having to export files to upload like done within the Deliverect POS sync capability?

  • Pricing & availability RBI operates with Cloud Pricing and Availability in its most advanced markets. Is Oracle capable of receiving P&A data, rather than exposing?

  • Pricing & availability RBI operates with personalized pricing per channel in its most advanced markets (up to 32 price channels). How many pricing tiers can Oracle support?

  • Pricing & availability RBI operates with Late Night pricing in its most advanced markets, increasing prices during a time interval on specific days. Is Oracle capable of operating with such information (receiving and / or exposing)?

  • menu structure Does Oracle expose the full menu configured in the POS with its corresponding PLUs? https://docs.oracle.com/en/industries/food-beverage/simphony/omsstsg2api/op-api-v2-menus-menuid-get.html

    • If yes, is there menu versioning/history available?

  • menu structure Oracle’s standardized way to configure Modifiers

    • In which Intl markets does this apply to and which markets are left out?

    • What Modifiers structure is utilized by non adherent markets?

  • menu structure Definition of each Menu Structure in Oracle and in Sanity. Including:

    • Step by step tutorial in Oracle

    • Step by step tutorial in Sanity

    • Payload example for OI in Oracle Simphony Gen 2

    • Payload example for Partners API

  • ORDER INJECTION How to inject Table number for Table Service orders?

    • Disclose requirements on receipt, KDS

  • ORDER INJECTION Conditions / requisites to have Oracle build a middleware for Order Injection

  • ORDER INJECTION Delivery Fee injection. PLU? Any other logic? If PLU, mapped where?

  • ORDER INJECTION How does Simphony notify our system of canceled orders? Is there a Webhook?

  • ORDER INJECTION FireOrder webhook. Khumbu does not know if Symphony supports ’suspended’ orders, that is, orders sent with fireOrderInSeconds=null which need to get fired at a later time.

  • ORDER INJECTION Actionable Feedback for Pricing / Commit errors

    • Example of current non-actionable feedback: Incorrect side count for Combo Meal Side #2. Expect 1 but found 0

    • Example of current actionable feedback: 52325 is not a part of combo with id 8763

    • Q: how do we move towards having only actionable feedback?

Loyalty

Categories: OPERATOR EXPERIENCE menu structure t-log

  • OPERATOR EXPERIENCE Can we support adding rewards directly from the POS screen after guests have identified themselves?

    • How can we mitigate fraud risks?

  • menu structure Rewards Points + Currency

  • menu structure Rewards % Discount Products

  • t-log Are you including Loyalty IDs in the T-Log, so our analytics teams can identify the users behind each transaction?

Agenda

  • Coordinator: @Marrara, Jean → Responsible to drive the agenda, ensure we stay on topic and stick to timings.

  • SMEs:

    • Loyalty: @Lopes da Costa, Valentina @Silva, Carlos

    • Menu: @Yildirim, Semih @Benet, Anton

Attendees:

Oracle

Will Jones, Technical Solutions Program Director

Henrik Hessbo, Principal Solution Engineer

RBI

Adolfo Watanabe, Sr. Manager, Data Operations

Anton Benet, Director of Menu

Carlos Silva, Director of Loyalty

Francisco Fernandes, Director, Platform Ecosystem

Jean Marrara, Director, Software Development

Semih Yildirim, Product Manager, Menu

Sergio Garcia, Ops Transformation Manager (Int’l)

Valentina Lopes da Costa, Product Manager Loyalty

 

Time

Oct 28, 2024

 

Time

Oct 28, 2024

 

9:00 - 10:00

Menu P&A - DMTE Current

  • Items (Ala Carte)

  • Modifiers (Condiments)

  • Combos (Combo Meals)

  • Comboslots (Combo Meal Groups)

 

10:15 - 11:30

Oracle payloads for Transaction Services Gen 2

  • Menu - Payload format

    • Items (Ala Carte)

    • Combos (Combo Meal and Combo Meal Groups)

    • Condiments

      • Add, No, Extra

    • Service Modes & Channels

    • Menu Levels & Price Levels

    • Discounts

    • Tender

      • Service vs Payment

    • Service Charges

 

11:30 - 13:30

BREAK

 

13:30 - 15:00

Oracle payloads for Transaction Services Gen 2

  • Offers & Rewards - Payload Format

    • Rewards with an item

    • Rewards/Offers with a combo

    • Rewards/Offers with a cart discount

    • Rewards/Offers with a product discount

  • Pay@Counter

    • With Loyalty

 

15:00 - 15:30

EMEA Lab

 

15:30 - 16:00

Teo will speak about goals for the next 2 days

 

16:00 - 17:30

Loyalty

  • Questions

    • Can we support adding rewards directly from the POS screen after guests have identified themselves? How can we mitigate fraud risks?

    • Are you including Loyalty IDs in the T-Log, so our analytics teams can identify the users behind each transaction?

    • Can Oracle support querying Sanity and caching offers at the POS to help mitigate configuration issues?

Loyalty - DMTE Current

  • Rewards

    • Rewards with an item

    • Rewards with a combo

    • Rewards with a cart discount

    • Rewards with a product discount

  • Offers/Personalized Offers

    • Offers with an item

    • Offers with a combo

    • Offers with a cart discount

    • Offers with a product discount

 

 

Time

Oct 29, 2024

Time

Oct 29, 2024

8:30 - 9:00

Intro

  • Oracle & RBI members introduction.

  • Discuss workshop objectives:

    • Mutual Understanding of the End-to-End RBI/Simphony Solution

    • Understand how to set up the DMTE Project for Success (Standardisation, Country Regionalisation, Best Practices, Collateral etc)

    • Understand what a future RBI with Oracle Simphony partnership might look like (Solution Roadmap/Partners Innovations etc)

    • Greater Understanding on Data Management (Access to Data/ Order Injection / Price and Availability)

9:00 - 10:25

RBI - Menu and Ordering

10:25 - 10:35

BREAK

10:35 - 12:00

RBI - Loyalty

12:00 -13:00

LUNCH BREAK

13:00 - 14:55

Oracle - Configuration Best Practices

  • Menu Item Structure Best Practices (Options and implications)

    • Ala Carte

    • Combos

      • Upgrade/Downgrade Kd, Sm, Md, Lg

        • Dynamic vs size based

      • Pricing strategy

        • Combo level vs Component level

      • Upcharges ($)

        • Define price for different channels

    • Condiments/Modifiers

      • PLU strategy (1 PLU per modifier vs 1 PLU per modifier multiplier)

      • Add, No, Extra, Light, Heavy, Only, Plain

    • Dayparts

      • Breakfast/Lunch/Late Night

    • Channels

      • In Restaurant, Delivery 1p, Delivery 3p, Kiosk, …

    • Modes

      • FC, DT, Curb Side, Kiosk, Delivery

    • Menu Levels

      • Modifiers vs Dayparts vs Size

    • Discounts

      • Trigger & Restriction & Award

    • Pricing strategy

      • Dayparts

      • Channels

      • Tiers

    • Service charges

  • Loyalty/Rewards Configuration Best Practices (Options and implications)

    • Coupons, Offers

      • Combo/Bundle/Item

      • Item discount

      • Cart Discount

      • Rewards

      • Item/Combo

      • Discount on Item

      • Discount on Cart

      • Rewards Points + Currency

      • Rewards % Discount Products

      • Auditing (points exchanged)

    • Discounts

      • Coupons and Offers as Discounts

        • Trigger & Restriction & Award

14:55 - 15:05

BREAK

15:05 - 17:00

Oracle - API Best Practices

  • Data Management and Access/Injection for the Future (API/Extensions/Solutions)

    • STS2 API

      • Menu

        • Automated POS PLU sync

        • Pricing

          • Channel, Order Mode, Daypart

      • Checks

        • Service mode

        • Fees

        • Deposit and sugar tax

        • Pre-ordering

        • Fiscal integrations

        • Order cancelation

        • Order firing

        • Actionable Feedback for Pricing / Commit errors

        • Pay@Counter (with Loyalty) for kiosk orders

      • Notifications/Webhooks

        • Menu changes

        • Check changes

        • Restaurant status changes

17:00 - 18:00

RBI - DSS

  • Review DSS requirements and journey

Oracle

  • Current Implementation

  • Best Practices

 

Time

Oct 30, 2024

Time

Oct 30, 2024

8:30 - 10:30

Discussion – Menu and Ordering

  • Align on best approach

  • Create action items

10:30 - 12:00

Discussion – Loyalty

  • Align on best approach

  • Create action items

12:00 - 13:00

LUNCH BREAK

13:00 - 17:30

Open Forum - Q&A

Â