# Day 2 Hands-on Lab Workbook: Telecom Order-to-Asset, Marketing & Reporting

**Audience:** Trainees (TRAINEE01 - TRAINEE09)  
**Environment:** Siebel Call Center / eCommunications (`https://siebelvm.shreejientserv.in/siebel/callcenter_enu`)  
**Portal:** `https://siebeltraining.shreejientserv.in/`

---

## Lab 1: Telecom Opportunity-to-Asset Business Flow

### Objective
Guide a customer through the complete B2B telecom commercial cycle: qualify an opportunity for high-speed fiber broadband, configure a sales quote with recurring and non-recurring products, submit the order, and observe asset provisioning.

### Step-by-Step Instructions

#### Part A: Create Telecom Opportunity
1. Navigate to **Opportunities** &rarr; **Opportunity List**.
2. Click **New** in the Opportunities applet.
3. Complete the fields:
   - **Opportunity Name:** `TRAIN26-TXX B2B Broadband Upgrade` (replace `XX` with your trainee number, e.g., `01`).
   - **Account:** Select `TRAIN26-TXX Telecom Customer`.
   - **Primary Contact:** Select `LearnerXX Contact01`.
   - **Sales Stage:** `01 - Prospecting` &rarr; change to `02 - Qualifying`.
   - **Status:** `Open`.
   - **Currency:** `USD`.
4. Step off or click **Save** (Ctrl+S).

#### Part B: Generate Sales Quote (CPQ)
1. With your opportunity selected, navigate to the **Quotes** view tab (or click **Auto-Quote**).
2. If creating manually, click **New** in the Quotes applet:
   - **Quote Name:** `TRAIN26-TXX B2B Broadband Quote`.
   - **Price List:** `Standard Telecom Price List`.
   - Save the record.
3. Drill down on the blue link of your Quote Name into the **Quote Detail - Line Items View**.

#### Part C: Add Catalog Products to Quote
1. In the **Line Items** applet, click **New** (or **Add Items**).
2. Add Item 1:
   - **Product:** Select `TRAIN26 Business Broadband 100` (or `Broadband 200`).
   - **Qty:** `1`.
   - **Action:** `Add`. Notice the Monthly Recurring Charge (MRC) populated ($60.00 / $95.00).
3. Add Item 2:
   - Click **New**.
   - **Product:** Select `TRAIN26 Managed Business Router`.
   - **Qty:** `1`.
   - **Action:** `Add` ($120.00).
4. Add Item 3:
   - Click **New**.
   - **Product:** Select `TRAIN26 Broadband Installation`.
   - **Qty:** `1`.
   - **Action:** `Add` ($50.00 one-time labor charge).
5. Review the Quote Total in the Totals banner:
   - Recurring MRC Total = **$60.00**
   - Non-Recurring NRC Total = **$170.00**
   - Total Net Price = **$230.00**

#### Part D: Convert to Order & Observe Asset Provisioning
1. On the Quote header, click the **Auto Order** button (or navigate to Sales Orders > New).
2. The system converts your Quote lines into a formal **Sales Order**.
3. Note your generated **Order Number** (e.g., `TRN26-O-XXX`).
4. Update **Order Status** to `Submitted`.
5. *Order Management Fulfillment Flow:* In telecom production environments, submitting the order dispatches an orchestration event via `SIS OM Submit Order Process`. Once provisioning completes, the order transitions to `Complete`. The PMT engine automatically generates active records in `S_ASSET` for products where `Track as Asset = Y` (Broadband Circuit & Router), while installation labor is not converted into an asset.

### Verification Checkpoint
- [ ] Opportunity created with stage `02 - Qualifying`.
- [ ] Quote configured with 3 line items (Broadband, Router, Installation).
- [ ] Sales Order generated and set to `Submitted`.

---

## Lab 2: Enterprise Marketing Lifecycle, Segmentation & The Golden Thread

### Objective
Walk through the entire 7-step Siebel Marketing lifecycle: inspect the governing Marketing Plan and Program, locate your tactical Campaign, examine your Target List and assigned Campaign Contacts, validate privacy suppression rules, log customer responses, and follow the Golden Thread through to Converted Opportunity, Sales Quote, Sales Order, Installed Asset with Monthly Recurring Revenue ($95/mo), and Customer Service Requests.

### The 7-Step Lifecycle & Downstream Golden Thread
```
[Marketing Plan] -> [Marketing Program] -> [Campaign] -> [Target List] -> [Campaign Contacts]
                                                                               |
                                                                               v
[Customer Service Request] <- [Installed Asset ($95/mo MRR)] <- [Sales Order] <- [Quote] <- [Opportunity] <- [Customer Response]
```

### Step-by-Step Instructions

#### Part A: Navigate the Governance Hierarchy (Plan -> Program -> Campaign)
1. **Marketing Plan (Layer 1):** Navigate to **Marketing Plans** screen. Query for `Name = TRN26*`.
   - Open `TRN26 Telecom Growth Plan FY2026`.
   - Observe the governing budget ($500,000 USD), corporate scope, and annual date boundaries.
2. **Marketing Program (Layer 1):** Drill down to the **Programs** sub-tab.
   - Open `TRN26 National B2B Broadband Acquisition Program`.
   - Observe how the program partitions the plan budget ($250,000 USD) specifically for broadband acquisition.
3. **Operational Campaign (Layer 2):** Navigate to **Campaigns** screen.
   - Query for your campaign: `Name = TRN26-TXX Broadband Acquisition` (replace `XX` with your trainee ID, e.g. `01`).
   - Observe that your campaign is linked directly to parent Program `TRN26-PRG-01` and Plan `TRN26-PLN-01`.

#### Part B: Inspect Target List & Campaign Contacts
1. **Target List (Layer 2):** Navigate to **List Management** &rarr; **Lists**.
   - Query for `TRN26-TXX Broadband Target List`.
   - Drill into **List Members** to verify your 6 assigned contacts (`LearnerXX Contact01` through `Contact06`).
2. **Campaign Contacts Roster (Layer 3):** Return to **Campaigns** &rarr; **Contacts / Prospects** sub-tab.
   - Verify that your 6 contacts are populated in the campaign roster.
   - Observe their current execution statuses:
     - `Contact01`: `Call Completed` / `Interested` (the high-value lead).
     - `Contact02`: `Call Completed` / `Requested call back`.
     - `Contact05` / `Contact06`: `Do Not Contact Again` (privacy suppression).

#### Part C: Validate Privacy Suppression
1. Navigate to the **Contacts** screen.
2. Query for `LearnerXX Contact06`.
3. Inspect the privacy flags:
   - **Do Not Call:** `Y`
   - **Do Not Email:** `Y`
   - *Key Takeaway:* In automated wave dispatch, the Marketing Server evaluates these suppression flags to ensure regulatory privacy compliance.

#### Part D: Inspect Customer Responses (Layer 4)
1. Navigate to **Responses** (or Campaigns &gt; Responses).
2. Query for `Campaign = TRN26-TXX Broadband Acquisition`.
3. Inspect your logged responses:
   - **Response A:** Inbound call from `Contact01` stating *Interested in Business Broadband 200 Plan Upgrade*.
   - **Response B:** Inbound call from `Contact02` stating *Callback requested regarding router compatibility*.

#### Part E: The Golden Thread (Opportunity -> Quote -> Order -> Asset -> Service)
1. **Converted Opportunity:** Navigate to **Opportunities**.
   - Query for `Name = TRAIN26-TXX*`.
   - Open `TRAIN26-TXX Broadband Expansion`.
   - Observe that the **Lead Campaign** points to your campaign, and **Response ID** points to the positive response.
2. **Sales Quote:** Drill down to **Quotes** tab.
   - Notice Quote `TRN26-Q-XXX` configured with Broadband 200 ($95.00/mo), Managed Router ($120.00), and Installation ($50.00).
3. **Sales Order:** Navigate to **Sales Orders** and query for your account.
   - Open Order `TRN26-O-XXX` (Status: `Complete`).
4. **Active Installed Assets (Recurring Revenue):** Navigate to **Assets** &rarr; **Installed Assets**.
   - Query for `Account = TRAIN26-TXX*`.
   - Inspect the active assets:
     - **Circuit Asset:** `TRAIN26-AST-BB200-TXX` (Circuit ID `CIRCUIT-200M-TXX`, generating **$95.00 Monthly Recurring Revenue**).
     - **Router Asset:** `TRAIN26-AST-RTR-TXX` (Serial `RTR-SN-XXXXXX-TXX`).
5. **Customer Service Request:** Navigate to **Service Requests**.
   - Query for your account.
   - Open Service Request `TRN26-SR-XXX` (e.g. *Fiber Port Speed Profile Verification*).
   - Observe that the Service Request is directly tied to the active **Circuit Asset** for end-to-end customer support!

### Verification Checkpoint
- [ ] Traced hierarchy from Plan `TRN26-PLN-01` down to Campaign `TRN26-TXX`.
- [ ] Verified 6 contacts in Target List and Campaign Contacts roster.
- [ ] Confirmed privacy suppression flags on opt-out contact `Contact06`.
- [ ] Inspected positive Response and Converted Opportunity.
- [ ] Verified active Installed Assets generating monthly recurring revenue.
- [ ] Verified post-sales Service Request linked to the installed asset.

---

## Lab 3: Periods, Quotas & Forecast Pipeline Review

### Objective
Understand how temporal master data drives revenue forecasting and quota tracking in Siebel CRM.

### Step-by-Step Instructions
1. Navigate to **Administration - Period** &rarr; **Periods**.
2. Query for `Name = TRAIN26*`.
3. Inspect the period hierarchy:
   - Annual period `TRAIN26 2026` (Year).
   - Quarterly periods `TRAIN26 2026 Q1` through `Q4` (linked to Year via `PR_PAR_PERIOD_ID`).
   - Monthly periods `TRAIN26 2026-01` through `2026-12` (linked to Quarters).
4. Navigate to **Forecasts** &rarr; **Forecast Series**.
5. Observe how forecast snapshots aggregate open opportunities against the active calendar period hierarchy.

---

## Lab 4: Current Query Reporting & Operational Data Export

### Objective
Inspect Siebel Current Query reporting templates (`aclist`, `cntlist`, `oplist`), distinguish template inspection from runtime report generation, understand Integration Object search specifications, and execute native operational CSV exports.

### Step-by-Step Instructions

#### Part A: Inspect BI Publisher Templates & Integration Objects
1. Navigate to **Site Map** &rarr; **Administration - BI Publisher Reports** &rarr; **Reports - Templates**.
2. Query for the verified Current Query templates:
   - `Template Name = aclist` &rarr; Associated Integration Object: `Account (XMLP)`.
   - `Template Name = cntlist` &rarr; Associated Integration Object: `Contact (XMLP)`.
   - `Template Name = oplist` &rarr; Associated Integration Object: `Opportunity List (XMLP)`.
3. Drill down into `aclist` to inspect its layout structure and fields.
4. Drill down to the **View Association** sub-tab:
   - Note the specific views where this report is registered (e.g., `Account List View`).
   - Note how the menu bar **Reports** icon automatically discovers templates registered for the current view.

#### Part B: Execute Native Data Export (Operational Alternative)
1. Navigate to **Accounts** &rarr; **Accounts List**.
2. Query for `Name = TRAIN26*`.
3. Highlight all 11 accounts.
4. Click application **Menu** &rarr; **Export**.
5. Select:
   - **File format:** `Comma Delimited Text File (*.csv)`.
   - **Rows to export:** `All Rows in Query`.
   - **Columns to export:** `Visible Columns`.
6. Click **Next** and save the file. Open in Excel/Notepad to confirm that the exact 11 training accounts are exported cleanly.

### Verification Checkpoint
- [ ] Located `aclist`, `cntlist`, and `oplist` templates and identified their Integration Objects.
- [ ] Confirmed view associations for the Account List report.
- [ ] Executed native `Menu > Export` and generated a verified CSV export of the training accounts.
