Merchandising Foundation
Container Store Merchandising Demonstrations
Eddie Williams
Sales Consultant
Oracle Retail
July, 2022
The following is intended to outline our general product direction.
It is intended for information purposes only, and may not be
incorporated into any contract. It is not a commitment to deliver
any material, code, or functionality, and should not be relied
upon in making purchasing decisions. The development, release,
timing, and pricing of any features or functionality described for
Oracle’s products may change and remains at the sole discretion
of Oracle Corporation.
Safe Harbor Statement
July 2022Copyright © 2022, Oracle and/or its affiliates, Confidential2
3 Copyright © 2022, Oracle and/or its affiliates | Confidential July 2022
Merchandising Agenda Day 1
9:00-9:30 Introductions and Overview
9:30-11:00 Hierarchies, Locations and Vendors
11:00-12:30 Lunch Break
12:30-1:30 Products
1:30-4:15 Procurement
4:15-4:30 Q&A / Wrap Up for Day 1
Master Data: Merchandise Hierarchy, Locations
4 Copyright © 2022, Oracle and/or its affiliates | Confidential July 2022
Core Concepts & Foundation
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential5
Basic design to provide a
modern, agile platform for
retail operations
CORE CONCEPTS
Enabling efficiency and
productivity with a
modern user
experience
USER EXPERIENCE
A deeper look at capability
provided for items
ITEMS & ATTRIBUTES PROCESS &
INTEGRATION
Documented
processes &
integration facilitate
better projects
How core entities &
hierarchies work together
to provide flexibility &
accuracy
FOUNDATION DATA
REPORTING & ANALYSIS
Operational Insights
and Analytical Insights
delivered.
Merchandising Operations Management Exception based retailing / New ways of working
6 Copyright © 2022, Oracle and/or its affiliates | Confidential July 2022
Launch Page Role-based enterprise-wide launch page. Consolidated
notifications & favorites
Dashboards Relevant information &
exceptions by role
In-Context Launch “Launch” into a solution’s
screen passing in parameters
Contextual BI Dynamically refresh when
certain actions are performed
Notifications Real time notification
framework
Sales Audit – Accounts Payable….Junior Buyer – Buyer – Inventory Analyst ….
Reporting Tools
Operational Insights - Merchandising
• Business Intelligence Publisher
• Pixel perfect operational insights
• Customer dashboards
• Printed reports
• Export to files
Other Tools – Retail Home
• Oracle Analytics
• Retail Insights historical and analytical
• Retail Home
• Data Visualisation
• Rich tools for analysis
• Ad-hoc Analysis
• Narration
7 Copyright © 2022, Oracle and/or its affiliates
Operational Reporting Elements
• Notifications
• Dashboards
• In-context BI Pane
• Custom reporting
• ‘Printed’ Reports
8 Copyright © 2022, Oracle and/or its affiliates
Operational Reporting Elements
• Notifications
• Dashboards
• In-context BI Pane
• Custom reporting
• ‘Printed’ Reports
9 Copyright © 2022, Oracle and/or its affiliates
Data Upload/Download
1. Download Data to Spreadsheet
Select Template Type and Template
Downloads all existing data into *.ods file
2. Update data in Spreadsheet
Allows for Creating, Update and Delete actions
3. Upload Data from Spreadsheet
Validates the source file against the template and uploads the same into RMS
4. Data Loading Status
Review Status and Errors
Vew Issues displays all issues associated with a template upload
Manage Admin Data Flow Mass Load/Change Data Entities
‘View Issues’ button provides quick access to issues with the selected data upload
Copyright © 2022, Oracle and/or its affiliates | Confidential
Master Data Merchandise Hierarchy, Locations
Scenario Number Scenario Description
H1 Setting up of the Main master data like Merchandise hierarchy, locations and vendors
H2 Location Setup
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential11
Define Data Security – via Templates / Identity Management
12 Copyright © 2022, Oracle and/or its affiliates | Confidential July 2022
User Role mapping to Permissions
13 Copyright © 2022, Oracle and/or its affiliates | Confidential July 2022
Designed for Modern Customer Centric Omni-Channel Retailing
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential14
Bricks & Mortar Digital
Franchise Wholesale
Hierarchy Structure For Organization & Merchandise
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential15
Attributes
Group / Company
Subclass
Class
Department
Division
Group
Items
Merchandise Hierarchy
Physical Warehouse (Omni-Channel)
Virtual 1
Virtual 3
Virtual 2
Warehouses
Traits
Organizational Hierarchy
Selling Location
L5 (District)
L4 (Region)
L2 (Banner)
L3 (Area)
Grouping Tools
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential16
Let’s take a look – Organizational Hierarchy
Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted17
Oracle Retail Analytics & Planning
Affinity
Analysis
Profiling
Analytics
Customer
Decision
Trees
Demand
Transference
Innovation
Workbench
Attribute
Extraction &
Binning
Advanced
Clustering
Customer
Segmentation
Merchandise
Financial
Planning
Assortment
Planning
Assortment &
Space
Optimization
Promotion &
Markdown
Optimization
Offer
Optimization
Replenishment &
Inventory
Optimization
Retail Insights & Data Visualizations
Demand
Forecasting
Forecasting Engine
• Clustering / Grading • Like Store / Like Item
Hierarchy Structure For Organization & Merchandise
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential18
Attributes
Group / Company
Subclass
Class
Department
Division
Group
Items
Merchandise Hierarchy
Physical Warehouse (Omni-Channel)
Virtual 1
Virtual 3
Virtual 2
Warehouses
Traits
Organizational Hierarchy
Selling Location
L5 (District)
L4 (Region)
L2 (Banner)
L3 (Area)
Grouping Tools
Product Hierarchy defaults
Product (6+3)
Company
Division
Group
Department
Item
U s e
r D
e fi
n e
d A
tt ri
b u
te s
A n
d I
te m
D e
fa u
lt s
Collection
Feature
Compatibility
….
Data Control
VAT
UDA Default
Mandatory Data
Accounting
Flex Fields
Alt Hierarchy
Features
Legacy mapping
UDAs
Item Lists Subclass
Class
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential20
Let’s take a look – Merchandise Hierarchy
Copyright © 2022, Oracle and/or its affiliates21
Reclassification of an Item from one Department\Class\Subclass) into another
• Overnight process reclassifies the Items
• Reclassify the level 1 items, child items will follow
• All items in an Item Group must have same Hierarchy
Mass reclassification based on:
• An Item List – e.g. certain types of items
• All items in a certain Department
• All items in a certain Class
• All items in a certain Subclass
Item Management - Reclassification
Department
Class
Subclass A
Subclass B
Subclass C
Subclass D
Validation: Not on another Reclassification. Not on partially received PO. Not moving Consignment to Non-consignment. Not on a Future Unit & value Stock Count. Mandatory UDA’s and attributes present. Forecastable items, associated forecast domain required.
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential22
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential23
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential24
Alternate Hierarchies
Copyright © 2022, Oracle and/or its affiliates
UDAs and CFAs Attribution Item Master AttributesMerchandise Hierarchy
Forecasting, Replenishment, BI …
Copyright © 2022, Oracle and/or its affiliates
Copyright © 2022, Oracle and/or its affiliates
Master Data Merchandise Hierarchy, Locations
Scenario Number Scenario Description
✓ H1 Setting up of the Main master data like Merchandise hierarchy, locations and vendors
✓ H2 Location Setup
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential28
Vendors
29 Copyright © 2022, Oracle and/or its affiliates | Confidential July 2022
Suppliers originate in
Financials; once approved
sent to Merchandising to
order product
Item, Orders & Deals are created.
Deals auto-applied to orders and
are sent to the supplier for
fulfillment
Merchandise is received at the
warehouse, store or even
customer. Inventory & Stock
Ledger are updated to reflect
receipt and staged for the GL
Matched/resolved
invoices are paid in AP;
totals/liabilities & inv
movement posted to GL
All transactions at selling
location are automatically
audited, liabilities and totals
are staged for the GL
Invoices are received and
automatically matched (or
resolved) against the PO and
receipt details
Overview Of End-to-End Merchandising Flow
PROCESS &
CLEANSE SALES
RECEIVE &
ALLOCATE STOCK
MATCH & RESOLVE
INVOICES
SUPPLIER
MANAGEMENT
MANAGE ITEMS &
PURCHASE ORDERS
EXECUTE
PRICING
TRACK & VALUE
INVENTORY
POST, PAYMENT &
GENERAL LEDGER
Define or induct regular pricing,
promotional mechanics and
markdowns. Link to vendor
funding. Pass Price to
downstream solution, Web or in
store
All transactions at SKU/location
are captured in real-time with
Inventory & Stock Ledger
updated to reflect movement
and staged for the GL
Copyright © 2022, Oracle and/or its affiliates | Confidential
Master Data Vendors
Scenario Number Scenario Description
H3 New Vendor Setup
H4 Setting up Merchandising System New Vendor
H5 Vendor Maintenance - Vendor Mergers and Acquisitions
H6 Vendor Maintenance – Payment Terms
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential31
Oracle Retail / Financials Integration
Copyright © 2022, Oracle and/or its affiliates | Confidential
Revenue Recognition
Inventory Valuation
Intercompany
Foundation Data Retail Merchandising
General
Ledger
G/L Chart of Accounts
Currency Exchange Rates
Payment & Freight Terms
Suppliers, Supplier Sites, Partners, Addresses
Retail Stock Ledger Stock Valuation Posting to G/L
Retail Merchandising Intercompany Transfer Postings
Retail Sales Audit Daily Sales Cash and Deposits
Wholesale Retail Merchandising Wholesale Orders Accounts
Receivable & Payable
Invoice to Pay
Aged Receipts Never Invoiced
Manually Paid Invoices
Matched and Pre-pay Invoices
Debit/Credit Memos & Credit Notes
Accounts Payable
Rebates
Retail Invoice Match
Typical Integration Pattern for Suppliers, Foundation
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential33
Merchandising
GL Chart of Accounts
Currency Exchange Rates
Suppliers, Partners, Addresses
Financials
The General Ledger of Accounts is mapped between Financials and Merchandising
Normally the company’s defined exchange rates and other currencies are also interfaced from financials
This ensures accuracy and alignment of transactions to ledgers
Supplier and other partner records including relevant addresses and other relevant parameters are interfaced from financials
Supply Chain Hub End to End Process
Copyright © 2022, Oracle and/or its affiliates | Confidential
Sales and Inventory
Costs
ASNInvoicing
OrderingItems Proposals
RTVs
Supplier On- boarding
Deals Supplier
Scoreboard
Customer Orders
Copyright © 2022, Oracle and/or its affiliates | Confidential35 27/01/2022
Supply Chain Hub Supplier Scoreboard
Monitor relationship and performance of Your suppliers
- Automatic supplier performance calculation on major KPIs
- Maintain and complete manual scorecards for non-automatic KPIs
- Quickly act in case of supplier issues
Improve Visibility of Supplier Performance
Supply Chain Hub Supplier On-boarding
Copyright © 2022, Oracle and/or its affiliates | Confidential36 27/01/2022
Onboard suppliers - Suppliers enter their own
data - Update of supplier
information - Self-service model
Improve efficiency of supplier maintenance
Supplier Structure
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential37
Supplier
Merchandising Supplier
Deals
Rebates
Payment terms
Address
Expenses
Schedules
Supplier Actions
EDI Capabilities
General Merchandise Supplier
Supplier Defaults
Replenishment
Bracket Costing
Inv Match
Traits
Supplier Site 1
General Merchandise - US
Supplier Site 1
General Merchandise - China
Number
Address
Payment terms
Financial Supplier Data
Let’s take a look – Vendor Setup
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential38
Financials
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential39
• Receipts are tracked by PO/location for matching, payment and inventory costing purposes.
• Automated stock ledger roll-ups at loc/subclass level - receipts are tracked as a financial transaction and rolled into SL.
• Can be sent at transaction level if required.
• Integration of vendor ID (or manual entry)
• Payments managed by finance – ‘primary pay site’ indicates the default payment site for financial processing.
• Matched invoices and approved debits/credit notes are sent to Financials for payment / processing.
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential40
Oracle Retail / Financials Integration
Copyright © 2022, Oracle and/or its affiliates | Confidential
Revenue Recognition
Inventory Valuation
Intercompany
Foundation Data Retail Merchandising
General
Ledger
G/L Chart of Accounts
Currency Exchange Rates
Payment & Freight Terms
Suppliers, Supplier Sites, Partners, Addresses
Retail Stock Ledger Stock Valuation Posting to G/L
Retail Merchandising Intercompany Transfer Postings
Retail Sales Audit Daily Sales Cash and Deposits
Wholesale Retail Merchandising Wholesale Orders Accounts
Receivable & Payable
Invoice to Pay
Aged Receipts Never Invoiced
Manually Paid Invoices
Matched and Pre-pay Invoices
Debit/Credit Memos & Credit Notes
Accounts Payable
Rebates
Retail Invoice Match
Vendor Merger/Acquisition
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential42
• New vendor added to existing item, made primary vendor.
• Mass change vendor via download /upload process.
• Vendor can be made inactive preventing further ordering (typically inactivated in Financials ->integration).
• New PO’s created against new supplier
• Existing future PO’s re-created via download /upload process, or
• Open PO's processed as legacy supplier - invoice match accepts invoices created against new supplier and matches via Supplier Group.
• Future Cost Change will be per legacy vendor, or mass change vendor via download /upload process.
• Deals - update deal to bill another vendor.
• Vendor returns should be initiated with new vendor.
Payment Terms – create manually or via integration from Finance
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential43
Payment Terms Due Dates and Discount Dates
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential44
• Fixed Date: A specific day, month, and year that an installment is due for payment.
• Days: A number of days added to the invoice terms date.
• Day of Month: A type of payment term with the following attributes:
• Day of Month: A specific day of the month when an installment is due for payment. E.g. 15 = fifteenth day of the month. Enter 31 = last day of the month.
• Cutoff Day: The day of the month after which the installment due and discount dates advance to a future month. If you don't specify a cutoff day, the current accounting month is used to determine due and discount dates.
• Months Ahead: The number that's used to determine the month the installment is due. If you enter 0 and the terms date is the same as, or later than, the cutoff day, the installment is due the following month.
• Invoice Matching – ‘best terms’ comparison of order vs invoice.
Master Data Vendors
Scenario Number Scenario Description
✓ H3 New Vendor Setup
✓ H4 Setting up Merchandising System New Vendor
✓ H5 Vendor Maintenance - Vendor Mergers and Acquisitions
✓ H6 Vendor Maintenance – Payment Terms
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential45
Products
46 Copyright © 2022, Oracle and/or its affiliates | Confidential July 2022
Agility and Flexibility Enabled via Relationship Between Major Entities
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential47
ITEMS SUPPLIERS
PHYSICAL / DIGITAL LOCATIONS
▪ Preferred Source ▪ Ordering Rules ▪ Parameters ▪ Inventory Valuation Method ▪ Investment Buy Eligibility
Products to Assort & Sell, Promote,
Clear
▪ Cost Prices ▪ Landed Costs ▪ Delivery Lead Times ▪ Packs ▪ Item Status
Channels & Locations where Products are
Stocked/Sold
Procurement Sources for Products
Products
Scenario Number Scenario Description
P1 Products
P2 Product – Multiple Selling scenario of a SKU (sold as a component, part of the kit or pre-packed)
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential48
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential49
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential50
Core Concepts & Foundation
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential51
Basic design to provide a
modern, agile platform for
retail operations
CORE CONCEPTS
Enabling efficiency and
productivity with a
modern user
experience
USER EXPERIENCE
A deeper look at capability
provided for items
ITEMS & ATTRIBUTES PROCESS &
INTEGRATION
Documented
processes &
integration facilitate
better projects
How core entities &
hierarchies work together
to provide flexibility &
accuracy
FOUNDATION DATA
REPORTING & ANALYSIS
Operational Insights
and Analytical Insights
delivered.
Supporting The Complex Item Model For Retail
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential52
User Defined Attributes • Brand • Material • Battery Type • Compatibility • Theme • Ornamentation • BPA Free • Collection
Substitute Item • Plan • Sales • Forecast • Replenishment • Inventory
Images / Documents • Many file types • Includes .doc, .xls • Specification Packages
Management Inventory Flow • Season • Flows • By Differentiator
Global Sourcing • Multiple Suppliers • Improve Negotiation • Single Style Management • Costing by Supplier/ • Location, Country
Location Profitability • Internal Expenses • External Expenses (Freight) • Weighted Average Cost
Packs • Single SKU • Multi style • Multi color • Multi size
SKU and Style Management • Style (Item) • Style/Color (SKU) • Style/Color/Size (UPC) • Etc.
3 Level Item Structure Using Differentiators
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential53
Each Item Can Have: • Multiple Vendors • Multiple Countries of Origin • Multiple UPC’s • Costing at the granular level • Track sales & inventory at desired level
One-level item
Wine Bottle Topper (assorted)
UPC
Three-level item
UPC 1 UPC 2
Pro FingerGrip Magnetic Glove
Black/ L
Black / XL
Red / L
Red / XL
SKU SKU SKU SKU
Style
Two-level item
Umbra Skinny Can
White Navy Blue
Cham- pagne
Char- coal
UPC UPC UPC UPC
Style
Item Description Qty
256735 Elfa~ Wood Screws Pkg/10 2-1/2" 1
10000916 16" x 2' Elfa~ Ventilated Shelf White 4
10000918 16" x 4' Elfa~ Ventilated Shelf White 1
10014683 16" Elfa~ Left Bracket Cover White 5
10014684 16" Elfa~ Right Bracket Cover White 5
10027328 Elfa~ Closet Rod End Caps Silver Pkg/2 3
10034918 Elfa~ Closet Rod Holder White 3" x 2" x 1-3/8" h 6
10051790 Elfa~ 2' Spacer 2' x 3/4" 1
10071993 16" Elfa~ Ventilated/Decor Shelf Bracket White 10
10074465 2' Elfa~ CLOSET ROD Nickel 4
10080736 Box for 4' Closet White 1
10084200 49" Top Track White- NEW 1
10084206 39" Hang Standard White 39" x 1" x 1" h 3
10084209 45" Extension Hang Standard White 45" x 1" x 1" h 3
10084216 Elfa~ Hang Standard Height Extender White 3
10084221 Top Track Cover White- NEW 2
10085450 Elfa~ New Drywall & Plaster Anchors White Pkg/5 2
10087119 Insert for Closet Kit 1
10087120 Spacer for Closet Kit 1
Packs and Kits
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential54
10080563
Elfa Classic~
4' Closet Kit White 4' x 16" x 5'
• Simple Packs • multiple of same item
• Complex Packs • different items pre-packed
or kitted
There are several different types of attributes that can be defined for an item • Most can be made mandatory or optional by the merchandise hierarchy
• Many are configurable lists of values
• Many are changeable during an item’s lifetime
Item Master Attributes • Specialized core attributes designed for a specific purpose; some can vary by
supplier or by location
• Examples: UoM, Brand Name, Season/Phase, Image, VAT, Tariff Code, Dimensions, …
User Defined Attributes (UDAs) • Configurable attributes for users to control (super user)
• Examples: Material, Type, Compatability, Format, Collection etc
Custom Flex Attributes (CFAs) • Configurable attributes (system admin control)
Item Attribution
Copyright © 2022 | Confidential | Oracle and/or its affiliates 55
Let’s take a look – Products
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential56
Item Range and Item/Location Status
Copyright © 2022, Oracle and/or its affiliates57
A product’s range is the set of locations / customer locations at which the product is intended to be sold
Item/location relationships are defined to:
• Capture a product’s range, DC’s through which the product may pass (Item source)
• Item/location status, which can constrain an item’s activity at a location
• Restrict association to locations not able to eligible for certain restricted products
• Hold a number of traits / attributes that are item/location specific
• Range can be defined externally and integrated (e.g. from Assortment Planning)
• Like store, mass change and scheduled item maintenance
Delete
Active Inactive Discontinued Delete Range
Item Management Status & Operations
Copyright © 2022, Oracle and/or its affiliates58
L o
c a
ti o
n
T y
p e
It e
m S
ta tu
s
O rd
e r
T o
A ll
o c
a te
F
ro m
(* )
A ll
o c
a te
T o
(*
)
T ra
n s fe
r F
ro m
T ra
n s fe
rs T
o
R e
p le
n is
h m
e n
t F
ro m
S a
le s
P ri
c in
g
Store
Active ✓ * * ✓ ✓ ✓ ✓
Inactive ✓ ✓ ✓
Discontinued * ✓ ✓ ✓ ✓
Deleted ✓ ✓
Warehouse
Active ✓ * * ✓ ✓ ✓ ✓
Inactive ✓ ✓
Discontinued * ✓ ✓ ✓
Deleted ✓
(*) Behaviour can be configured
Item Management Item Master Data Lifecycle
Status Description
Worksheet The item setup is incomplete. You can edit, submit, or delete the item create event.
Submitted
The item has been validated but is not yet available for operational use and may be returned to ‘Worksheet’ status
Approved
Item has met all requirements and system checks and became a live item (can be ordered, sold and have inventory). Once approved the item can not be returned to ‘Worksheet’ status.
Delete Pending
The item is marked for deletion and, if it is not in use in any RMS functional area, it will be removed by a batch program.
Deleted The item event will be deleted.
59
Approve
(with errors) Submit
(with errors)
batch
Config- ured Rules
Copyright © 2022, Oracle and/or its affiliates
Other Concepts
• Item Lists
• Dynamic, Static
• Use in transactions or mass change
• E.g. Collection can be created as an Item List and assigned on mass to seasons, selling windows etc.
• Seasons and Phases
• Use in allocation, replenishment, reporting etc
• Reclassification
• Structured movement / mass change
• Retail Insights – as-was / as-is tracking
Copyright © 2022, Oracle and/or its affiliates60
Department
Class
Subclass A
Subclass B
Subclass C
Subclass D
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential61
• Merchandising UX
• Create manually
• Template
• Like Item (copy)
• Within PO dialog directly (typical for fashion)
• Induction
• Create/download spreadsheet
• Pack and Pack Items sheet
• Integration
• From external system
Items / Pack Creation
Create Pack via Induction
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential62
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential63
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential64
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential65
• Pack sales and component sales are tracked - full visibility.
• This data is made available for Business Intelligence reporting/analysis and for planning/forecasting solutions.
For example - Pre-pack or kit
• Sales of pack are tracked
• Sales of components and inventory are tracked
• Inventoried Pack
• Inventory of pack tracked in WMS
• Component inventory tracked in SIM, or option to track at pack level in SIM.
Sales Tracking – Components and Packs
7/28/2022Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted66
7/28/2022Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted67
• All items within an inventoried complex pack must be inventoried.
• Use an inventoried ‘Non-Merchandise’ Item.
• Posted to transaction data with a specific transaction code.
• These transactions can be sent to Financials/GL and/or reported on.
Inventoried Pack with Service SKU
7/28/2022Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted68
7/28/2022Copyright © 2022, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted69
Products
Scenario Number Scenario Description
✓ P1 Products
✓ P2 Product – Multiple Selling scenario of a SKU (sold as a component, part of the kit or pre-packed)
✓ PRI11 Procurement process - Elfa prepacks and kits
July 2022Copyright © 2022, Oracle and/or its affiliates | Confidential70
71 Copyright © 2022, Oracle and/or its affiliates | Confidential July 2022