eCommunications Industry | Day 2 - Topic 4

Products, Catalogs & Revenue Management

1. Four-Tier Product Administration Architecture

Siebel eCommunications delivers a powerful multi-tier product catalog designed specifically for complex telecom offerings. Before an item can be priced or quoted, administrators establish four governing layers:

Layer / Entity WHY (Business Purpose) WHERE (Siebel Navigation) HOW (Setup Fields & Actions) NEXT (Downstream Impact)
1. Product Lines
(S_PROD_LN)
Groups catalog products into commercial families for sales quota rollups, reporting, and territory assignments. Site Map → Administration - Product → Product Lines Create Product Lines: TRN26-PLN-01 (Enterprise Broadband), TRN26-PLN-02 (Managed Hardware). Assign products in child applet (S_PROD_LN_PROD). Controls catalog search visibility and feeds product line quotas in Administration - Period.
2. Product Classes & Attributes
(S_XA_CLASS, S_XA_ATTR)
Defines technical/commercial attributes dynamically without database schema changes. Site Map → Administration - Product → Product Classes Create Class: TRN26-CLS-01 (Broadband Class). Under Attributes, add: Download Speed, Upload Speed, IP Type, SLA Level. Subclasses and assigned products inherit attributes automatically during CPQ quoting.
3. Product Definition & Release
(S_PROD_INT, S_PROD_REL)
Defines catalog items, structure type (Bundle vs Simple), asset tracking flags, and locks version definitions. Site Map → Administration - Product → Products Create product (e.g. TRAIN26 Business Connect Starter Bundle). Set: Structure = Commercial Bundle, Class = TRN26-CLS-01, Orderable = Y, Track as Asset = Y. Click Release Version. Freezes version in S_PROD_REL. Unreleased items cannot be added to price lists or quotes.
4. Price Lists & Rate Cards
(S_PRI_LST_ITEM)
Defines list pricing, discount rules, and distinguishes One-Time (NRC) vs Monthly Recurring Charges (MRC). Site Map → Administration - Pricing → Price Lists Open Standard Telecom Price List. Add product: List Price = $210.00, Payment Type = Non-recurring, Start Date = 2026-01-01. Provides base pricing for the CPQ engine during automated quote pricing and order conversion.

2. Commercial Bundles & Parent/Child Line Item Decomposition

Enterprise telecom solutions often combine multiple products into a single commercial bundle. In Siebel CRM, bundles automatically decompose into structured parent and child lines across Quotes and Orders:

Bundle Bill of Materials (BOM) Decomposition:
[Line 1.0] TRAIN26 Business Connect Starter Bundle (Parent Package Header - $210.00 Flat)
  ├── [Line 1.1] TRAIN26 Business Broadband 100 (Child Component - $60.00/mo MRC)
  ├── [Line 1.2] TRAIN26 Managed Business Router (Child Hardware - $120.00 NRC)
  └── [Line 1.3] TRAIN26 Broadband Installation (Child Labor Service - $50.00 NRC)

Database Hierarchy Rules Across the Golden Thread:

  • Quote Items (S_QUOTE_ITEM): Child lines reference parent via PAR_SQ_ITEM_ID and root package via ROOT_QUOTE_ITEM_ID.
  • Order Items (S_ORDER_ITEM): Order generation maintains exact parentage via PAR_ORDER_ITEM_ID and ROOT_ORDER_ITEM_ID.
  • Installed Assets (S_ASSET): Provisioned assets reference parent package via PAR_ASSET_ID and ROOT_ASSET_ID.
  • Asset Filtering: Physical hardware and active broadband circuits (Track as Asset = Y) create persistent assets, while transient installation labor (Track as Asset = N) expires upon order completion.

3. Pricing Models & Recurring Revenue Recognition

Revenue Classifications

  • Non-Recurring Charge (NRC): One-time hardware sales ($120 router) and setup labor ($50 installation).
  • Monthly Recurring Revenue (MRR): Ongoing monthly subscription charges ($60/mo or $95/mo broadband).
  • Annual Recurring Revenue (ARR): $\text{MRR} \times 12$ ($95 \times 12 = \$1,140/\text{year}$).
  • Total Contract Value (TCV): $\text{One-Time NRC} + (\text{Contract Duration in Months} \times \text{MRR})$.

Telecom Order-to-Asset Pipeline:

Opportunity → Quote → Auto-Order → Provisioning → Active Asset ($95/mo MRR) → Service Request
The provisioned asset in S_ASSET generates monthly recurring revenue and binds directly to customer service trouble tickets in S_SRV_REQ.