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)
[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 viaPAR_SQ_ITEM_IDand root package viaROOT_QUOTE_ITEM_ID. - Order Items (
S_ORDER_ITEM): Order generation maintains exact parentage viaPAR_ORDER_ITEM_IDandROOT_ORDER_ITEM_ID. - Installed Assets (
S_ASSET): Provisioned assets reference parent package viaPAR_ASSET_IDandROOT_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
The provisioned asset in
S_ASSET generates monthly recurring revenue and binds directly to customer service trouble tickets in S_SRV_REQ.