Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note

This page and all pages under it were used to manage the BK DE Oracle Integration project before September 2024. During September we re-organised the project and started managing progress here: BK DE - Oracle Rollout Program

Contents

Table of Contents
stylenone

📌 Context & Assumptions

  • BK DE is in the process of enabling loyalty on .

  • In terms of mobile ordering in the tech platform:

    • Delivery is available for a subset of stores (~150 BK DE Master Franchisee stores).

    • Click & collect, Dine In and , Drive Thru and Table Service are not available.

  • To enable delivery, RBI built an integration into “SIDES” (previously known as “Simply Delivery”).

    • When a guest places a delivery order:

      • RBI sends the delivery order to a SIDES tablet.

      • SIDES tablet is next to a delivery dedicated POS, located in the restaurant’s kitchen.

      • Team member manually keys in the order into the POS.

    • More details on SIDES integration flow here: /wiki/spaces/CA/pages/3402695725.

...

Info

Note that SIDES has attempted to integrate with Toshiba, but BK DE shared the integration is not reliable.

  • Delivery fulfilment fulfillment is done by own drivers. SIDES also takes care of driver management.

    • Team member will assign the order to an own driver. Drivers have a SIDES app which provides delivery instructions.

    • Note that SIDES has built an integration into UberDirect, which will allow 1P delivery orders to be delivered with UberEats drivers. BK DE is currently testing this integration.

📌 Goal

  • All BK DE restaurants currently use Toshiba as the POS and BK DE will replace Toshiba POS with Oracle POS.

    • As part of that replacement, we need to ensure that stores with Oracle POS support Mobile Ordering and Loyalty.

      • The following service modes, POS Integration will be implemented:

        • Delivery

        • Click & Collect

        • Dine In

        • Drive Thru

        • Table Service

⚙️ Tech Requirements

Architecture

...

  1. Oracle POS already has an integration with RBI via the Khumbu middleware using our PartnerAPI.

  2. In Sanity → Vendor Config need to be updated to support the integration:

    1. Create new field Toshiba-Loyalty to support current setup (input offers and rewards) which it’s using as part of the Loyalty Integration with Toshiba, Acrelec and Tillster.

      1. Script to migrate PLUs from the current Partner field to Toshiba-Loyalty including the whole Menu structure (items, combos, modifiers)

    2. Use Partner field to store the Pick Up and Delivery PLUs for Oracle POS.

Integration Oracle Simphony POS

  1. Defined to use the Transaction Services API Generation 2 for:

    1. Order Injection

    2. Price and Product Availability

    3. Heartbeat

Details on Oracle and Khumbu integration Oracle ordering /wiki/spaces/MS/pages/4055763454

  1. Contact Oracle to activate the Transaction Services API Generation 2;

  2. Create Store ID for both Staging and Production environment;

    1. Create new store on Sanity and set POS as Vendor Partner

  3. Mapping of RBI service modes to Oracle Simphony’s (orderTypeRef)

  4. Loyalty package need to be installed by Oracle following the guideline Oracle loyalty /wiki/spaces/MS/pages/4057661622

Configuration on Partner API

  1. Process to create store (Staging, QA and Prod) on Partner API:

    1. /wiki/spaces/IN/pages/3930325043

Content Management

In Sanity, on Vendor Configs, all PLUs need to be set on Partner field.

📋 Project Plan

...

  1. Enable Oracle POS on BK DE’s current setup (Delivery & DE - Loyalty Program):

    1. Service Mode: Delivery which is available for a subset of stores (~150 BK DE Master Franchisee stores).

    2. Loyalty Program: in the process of enabling loyalty on .

  2. Enable Click & Collect for Oracle POS.

  3. Enable rest of service modes for Oracle POS.

    1. Dine In

    2. Drive Thru

    3. Table Service

Info

This incremental approach reduces dependencies and allows for a faster time to pilot, while also minimizing risk.

Project Deliverables

#1 Implement Oracle POS on BK DE current setup: Delivery and Loyalty Program

Order Injection

...

Milestone

...

Outcome

...

Work Required

...

How to test

...

Owner

...

Effort (weeks)

...

Status

...

Create new store in Sanity

...

Store in Sanity created

...

  • Sanity - create a new store in Staging and set Vendor as Partner a postman.

...

  • Store is available in Sanity

...

Fagundes, Silvia

...

1 week

...

Status
colourBlue
titleIN PROGRESS

...

Create a new POS vendor config in Sanity

...

Vendor Config will available Toshiba field and Partner field to store the respectively PLUs

...

  • Sanity - create new field Toshiba-Loyalty to support current setup

    • Jira Legacy
      serverSystem Jira
      serverId255417eb-03fa-3e2f-a6ba-05d325fec50d
      keyILO-1345

  • Sanity - create a script to migrate existing PLUs under Partner field to new Toshiba-Loyalty field (items, combos, modifiers and etc)

...

  • Development work required on Sanity to support POS:

    • Toshiba-Loyalty field is available and PLUs are migrated from Partner field.

    • Partner field is empty.

...

Lopes da Costa, Valentina

Yildirim, Semih

...

Status
titleTBD

...

Status
titleNot started

...

Configure Oracle Integration

...

The Transaction Services Gen 2 API has been setup to enable the app integrate with POS.

...

  • Oracle to provide access to the API:

    • Username

    • OrgCodePassword

    • Client ID

    • Authentication URL

  • Mapping RBI services modes to Symphony

  • Share the inputs with Khumbu

...

  • Run a postman to validate the integration ?

...

Fagundes, Silvia

...

3 weeks

...

Status
titleNot started

...

Onboard Store to Partner API

...

The new store has been configured and is ready for use

...

  • Check the API Key on DynamoDB

  • Mint Partner JWT token- request to create a token

  • Create Partner Integration

  • Assign the new store to the integration entity

...

  • New store is available on BKD App - Store Locator

...

Fagundes, Silvia

Engineer Support

...

1 week

...

Status
titleNot started

...

Integrate fulfilment partner for 1P Delivery

...

Delivery fulfilment partner is integrated with Oracle

...

  • Determine the fulfilment partner:

    • Scenario with SIDES:

      • Khumbu might be develop an integration with SIDES

    • Scenario with Deliverect - future (to discuss with BK DE)

    • Set up integration with fulfilment partner

...

Fagundes, Silvia

...

Status
titleTBD

...

Status
titleNot started

...

Financial Delivery Report

...

Ensure Delivery data is flowing from Snowflake to BK DE reports

...

Identify adjustments on the current report - double check whether the data is sending correctly

...

  • Generate report and validate the data

...

Fagundes, Silvia

...

Status
titleTBD

...

Status
titleNot started

...

Integration Test:

Integration readiness in Staging

...

The Oracle > Khumbu > RBI integration has been thoroughly tested by the tech team in Staging

...

Integration is working for:

  • Order Injection

  • Heartbeat

  • Price & Product Availability

...

  • Inject a Delivery order in the POS and confirm the order has been injected

  • Ensure the store is on-line on the App

  • Menu updated in the Menu Service with correct prices and product availability

...

Fagundes, Silvia Engineer Support

...

1 week

...

Status
titleNot started

...

Content Management Readiness

...

All content needs to be set in Sanity for Oracle

...

  • Input PLUs for items, combos, modifiers and offers

...

  • Test that the configured PLUs, Offers are working in the app and in-store. Display the products and offers on the BKD app coming from Partner field.

...

Fagundes, Silvia

@Lionel David&Martin

...

Status
titleTBD

...

Status
titleNot started

...

Test E2E Integration in Staging

...

BKD App, In store and Kiosks (Tillster, Acrelec and Smoothr) are able to show the Menu and allow users to place orders

...

  • Test every single item, combo, modifier and offers placing an order via BKD App, Kiosk and In Store and validated if the order injection process is working.

  • BKD will provide a spreadsheet to follow the test progress for each item.

...

  • Test Store Availability

  • Test Price & Product Availability

    • BKD App display the Menu items, combos, modifiers and prices.

  • Test Order Injection for Delivery

...

Fagundes, Silvia

Yildirim, Semih

Magdalena Dlugolecka

Oracle

Khumbu

BK DE Team

...

2 weeks

...

Status
titleNot started

...

Rollout to Production

...

Order injection on Oracle is ready in Production, all products, offers are working as expected via Mobile Ordering.

...

  • Oracle configuration

  • Onboarding new production store on Partner API

  • Migrate Sanity document POS items, combos, offers from Staging to Production

  • BK DE Ops to train store personnel & Oracle on how to use the POS

...

  • Test Store Availability

  • Test Price & Product Availability

    • BKD App display the Menu items, combos, modifiers and prices.

  • Test Order Injection for Delivery are working in the app

...

Fagundes, Silvia

Yildirim, Semih

Magdalena Dlugolecka

Oracle

Khumbu

BK DE Team

...

1 week

...

Status
titleNot started

Loyalty

...

Milestone

...

Outcome

...

Work Required

...

How to test

...

Owner

...

Effort (weeks)

...

Status

...

Enable Loyalty on POS

...

Loyalty available on Oracle POS

...

  • Oracle to install loyalty package on POS

...

  • Display and redeem offers and rewards and rewards on the BKD app

...

Fagundes, Silvia

Oracle

...

Status
titleTBD

...

Status
titleNot started

...

Vendors need to change supportingPos

...

Vendors confirmed they changed on their side every place they currently use “supportingPos” : “Partner” has changed to use “supportingPos”: “toshibaLoyalty”

...

  • Communicate to Vendors (Toshiba, Tillster) to share the change. Vendors need hit our Loyalty APIs using supportingPos:“toshibaLoyalty”

...

Fagundes, Silvia

Lopes da Costa, Valentina

...

-

...

Status
colourGreen
titleDONE

...

Non-loyalty stores will need to be working with Oracle as well

...

Status
titleTBD

...

Status
titleNot started

...

Content Management Readiness

...

All content needs to be set in Sanity for Oracle

...

  • Input PLUs for rewards

...

  • Test that the configured PLUs for rewards are working in the app and in-store. Display the rewards on the BKD app coming from Partner field.

...

Fagundes, Silvia

@Lionel David&Martin

...

Status
titleTBD

...

Status
titleNot started

...

Test E2E Integration - Loyalty flow

...

BKD App, In store and Kiosks (Tillster, Acrelec and Smoothr) are able to show the Rewards and allow users to place orders

...

  • Test every single reward and palce an order via BKD App, Kiosk and In Store in order to validated if the order injection process is working.

  • BKD will provide a spreadsheet to follow the test progress for each reward.

...

  • Test Store Availability

  • Test Price & Product Availability

    • BKD App display the rewards

    • Test every single Reward is being checked out with successfully.

  • Test Order Injection for Delivery

  • In-Store Testing (Kiosk and Front Counter)

  • Test scenarios for DE which includes multi-scanning. Customer Journey Scenarios - POS

...

Fagundes, Silvia

Lopes da Costa, Valentina

Yildirim, Semih

Magdalena Dlugolecka

Oracle

Khumbu

BK DE Team

...

Status
titleTBD

...

Status
titleNot started

...

Rollout to Production

...

Order injection on Oracle is ready in Production, all products, offers and rewards are working as expected via Mobile Ordering.

...

  • Oracle to install loyalty package on POS in production

  • Migrate Sanity document POS rewards from Staging to Production

  • BK DE Ops to train store personnel & Oracle on Loyalty how to use the POS

...

  • Test Store Availability

  • Test Price & Product Availability

    • BKD App display the rewards

    • Test every single Reward is being checked out with successfully.

  • Test Order Injection for Delivery

  • In-Store Testing (Kiosk and Front Counter)

  • Test scenarios for DE which includes multi-scanning. Customer Journey Scenarios - POS

...

Fagundes, Silvia

Lopes da Costa, Valentina

Yildirim, Semih

Magdalena Dlugolecka

Oracle

Khumbu

BK DE Team

...

1 week

...

Status
titleNot started

...

    1. For the pilot, focus on enabling loyalty at the front-counter (we will not have kiosk at this stage).

  1. Enable Click & Collect for Oracle POS

...

Order Injection/Loyalty

...

Milestone

...

Outcome

...

Work Required

...

How to test

...

Owner

...

Status

...

  1. .

    1. We need to review the approach for Click & Collect service mode

...

Service Mode available on BKD App

...

  • Enable Click & Collect on

Simphony orderTypeRef

...

Fagundes, Silvia

Engineer Support

...

Status
titleNot started

...

Ops readiness

...

Ops process is set up

...

  • To define the order number which will be displayed on Kitchen screens

  • BK DE Ops to train store personnel

...

BK DE Team

...

Status
titleNot started

...

Click & Collect Report

...

Ensure Click & Collect data is flowing from Snowflake to BK DE reports

...

Identify adjustments on the report - double check whether the data is sending correctly

...

  • Generate report and validate the data

...

Status
titleTBD

...

Status
titleNot started

...

Integration Test:

Integration readiness in Staging

...

The Oracle > Khumbu > RBI integration has been thoroughly tested by the tech team in Staging

...

Integration is working for:

  • Order Injection

  • Heartbeat

  • Price & Product Availability

...

  • Inject a Click & Collect order in the POS and confirm the order has been injected

  • Ensure the store is on-line on the App

  • Menu updated in the Menu Service with correct prices and product availability

...

Fagundes, Silvia Engineer Support

...

Status
titleNot started

...

Content Management Readiness

...

All content needs to be set in Sanity for Oracle

...

  • Input PLUs for items, combos, modifiers and offers

...

  • Test that the configured PLUs, Offers, Rewards are working in the app and in-store. Display the products and offers on the BKD app coming from Partner field.

...

Fagundes, Silvia

@Lionel David&Martin

...

Status
titleNot started

...

Test E2E Integration (Staging):

...

BKD App, In-store and Kiosks (Tillster, Acrelec and Smoothr) are able to show the Menu and allow users to place Click & Collect orders

...

  • Test every single item, combo, modifier and offers placing an order via BKD App, Kiosk and In Store and validated if the order injection process is working.

  • BKD will provide a spreadsheet to follow the test progress for each item.

...

  • Store Availability

  • Price & Product Availability

    • BKD App display the Menu items, combos, modifiers, offers, rewards and prices.

  • Order Injection for Click & Collect

  • In-Store Testing (Kiosk and Front Counter)

  • Test scenarios for DE which includes multi-scanning. Customer Journey Scenarios - POS

...

Fagundes, Silvia

Yildirim, Semih

Magdalena Dlugolecka

Oracle

Khumbu

BK DE Team

...

Status
titleNot started

...

Rollout for Production

...

Order injection on Oracle is ready in Production, all products, offers and rewards are working as expected via Mobile Ordering - Click & Collect service mode available

...

  • Migrate Sanity document POS items, combos, offers, rewards from Staging to Production

  • BK DE Ops to train store personnel & Oracle on how to use the POS

...

  • Test Store Availability

  • Test Price & Product Availability

    • BKD App display the Menu items, combos, modifiers, offers, rewards and prices.

  • Test Order Injection for Click & Collect are working in the app

...

Fagundes, Silvia

...

Status
titleNot started

#3 Enable rest of service modes for Oracle POS (Dine In, Drive Thru and Table Service)

Order Injection/Loyalty

...

Milestone

...

Outcome

...

Work Required

...

How to test

...

Owner

...

Status

...

Mapping Dine In, Drive Thru and Table Service service mode on Oracle Simphony

...

Service Mode available on BKD App

...

  • Enable Dine In, Drive Thru and Table Service on

Simphony orderTypeRef

...

Fagundes, Silvia

Engineer Support

...

Status
titleNot started

...

Ops readiness

...

Ops process is set up

...

  • To define the order number which will be displayed on Kitchen screens

  • BK DE Ops to train store personnel

...

BK DE Team

...

Status
titleNot started

...

Dine In, Drive Thru and Table Service Report

...

Ensure Dine In, Drive Thru and Table Service data is flowing from Snowflake to BK DE reports

...

Identify adjustments on the report - double check whether the data is sending correctly

...

  • Generate report and validate the data

...

Status
titleTBD

...

Status
titleNot started

...

Integration Test:

Integration readiness in Staging

...

The Oracle > Khumbu > RBI integration has been thoroughly tested by the tech team in Staging

...

Integration is working for:

  • Order Injection

  • Heartbeat

  • Price & Product Availability

...

  • Inject a Dine In, Drive Thru and Table Service order in the POS and confirm the order has been injected

  • Ensure the store is on-line on the App

  • Menu updated in the Menu Service with correct prices and product availability

...

Fagundes, Silvia Engineer Support

...

Status
titleNot started

...

Content Management Readiness

...

All content needs to be set in Sanity for Oracle

...

  • Input PLUs for items, combos, modifiers and offers

...

  • Test that the configured PLUs, Offers, Rewards are working in the app and in-store. Display the products and offers on the BKD app coming from Partner field.

...

Fagundes, Silvia

@Lionel David&Martin

...

Status
titleNot started

...

Test E2E Integration in Staging

...

BKD App, In-store and Kiosks (Tillster, Acrelec and Smoothr) are able to show the Menu and allow users to place Click & Collect orders

...

  • Test every single item, combo, modifier and offers placing an order via BKD App, Kiosk and In Store and validated if the order injection process is working.

  • BKD will provide a spreadsheet to follow the test progress for each item.

...

  • Store Availability

  • Price & Product Availability

    • BKD App display the Menu items, combos, modifiers, offers, rewards and prices.

  • Order Injection for Click & Collect

  • In-Store Testing (Kiosk and Front Counter)

  • Test scenarios for DE which includes multi-scanning. Customer Journey Scenarios - POS

...

Fagundes, Silvia

Yildirim, Semih

Magdalena Dlugolecka

Oracle

Khumbu

BK DE Team

...

Status
titleNot started

...

Rollout for Production

...

Order injection on Oracle is ready in Production, all products, offers are working as expected via Mobile Ordering for Dine In, Drive Thru and Table Service service mode.

...

  • Oracle configuration

  • Migrate Sanity document POS items, combos, offers, rewards from Staging to Production

  • BK DE Ops to train store personnel & Oracle on how to use the POS

...

Test Store Availability

...

Test Price & Product Availability

  • BKD App display the Menu items, combos, modifiers and prices.

...

    1. .

  1. Enable Delivery for Oracle POS.

    1. We need to decide the approach for Fulfillment provider.

  2. Enable the remaining service modes for Oracle POS.

    1. Dine In

    2. Drive Thru

    3. Table Service

Info

This incremental approach reduces dependencies and allows for a faster time to pilot, while also minimizing risk.

Project Deliverables

Child pages (Children Display)
depth1
allChildrentrue
style
sortAndReverse
first0

Expand
titleStatus Keys

Status Keys

We use the following status keys across to report progress:

  • Status
    titleNOT STARTED
    work on this item has not started yet

  • Status
    colourBlue
    titleIN PROGRESS
    work on this item has started and is progressing to plan

  • Status
    colourPurple
    titleWAITING
    development done, awaiting deployment or completion of a dependency

  • Status
    colourYellow
    titleAT RISK
    work on this item has started and is at risk of delaying

  • Status
    colourYellow
    titleDELAYED
    work on this item is delayed, however it is not causing a major impact

  • Status
    colourRed
    titleDELAYED
    work on this item is delayed and it is causing an impact on project due dates or other dependencies

  • Status
    colourRed
    titleBLOCKED
    cannot move on this item until a dependency is resolved

  • Status
    colourGreen
    titleCOMPLETED
    item has been completed

🗣️ Stakeholders

Name

Role

Company

Email

1

Stefan Rittelmeyer

Project Manager

Oracle Local Vendor

stefan.rittelmeyer@onlinecorner.eu

2

Ela Bhatnagar

Middleware Integrator

Khumbu

ela.bhatnagar@khumbusystems.com

3

Philipp Hühler

AFL

RBI

phuhler@rbi.com

4

Daniela Corrales

Guest Experience

RBI

dteixeiracorrales@rbi.com

5

Julia

Head of Digital

BK DE

julia.barsch@burgerking.de

6

Melina Rönpagel

Digital Manager

BK DE

melina.roenpagel@burgerking.de

7

Mariann Reitz

CRM/Loyalty Manager

BK DE

mariann.reitz@burgerking.de

8

Lionel

Content Management

David & Martin Agency (BK DE)

lionel.knobloch@davidundmartin.com

9

Anton Benet

Digital Operations

RBI

abenet@rbi.com

10

Silvia Fagundes

CSM Team

RBI

sfagundes@rbi.com

11

Magdalena

Fulfilment Team - Product Manager

RBI

mdlugolecka2@rbi.com

12

Marco

Engineer Manager (Partner API)

RBI

mfernandezpranno@rbi.com

13

Semih

Menu & Restaurant Team - Product Manager

RBI

syildirim@rbi.com

14

Valentina

Loyalty & Offers - Product Manager

RBI

vlopesdacosta@rbi.com

🤹‍♂️ Risks Management

Expand
titleRisk rating guide

LOW

MEDIUM

HIGH

EXTREME

  • Acceptable

  • Ok to proceed

  • As low as reasonably practicable

  • Take mitigation efforts

  • Generally unacceptable

  • Take mitigation efforts

  • Intolerable

  • Seek support

 

 

LIKELIHOOD

SEVERITY

ACCEPTABLE
Little to no effect on event

TOLERABLE
Effects are felt, but not critical to outcome

UNDESIRABLE
Serious impact to the course of action and outcome

INTOLERABLE
Could result in disaster

IMPROBABLE
Risk is unlikely to occur

 

 

 

 

POSSIBLE
Risk will likely occur

 

 

 

 

PROBABLE
Risk will occur

 

 

 

 

...