# Day 1 Hands-On Lab Workbook: Core CRM & Architecture

**Course:** Oracle Siebel CRM 2-Day Practical Training  
**Date:** 26 November 2026 | **Time:** 12:30 – 19:00 IST  
**Audience:** TRAINEE01 - TRAINEE09 (Browser-only access)  
**Applications:** 
- Siebel eCommunications: `https://siebeltraining.shreejientserv.in/siebel/app/ecommunications/enu`
- Siebel Call Center: `https://siebeltraining.shreejientserv.in/siebel/app/callcenter/enu`
- Siebel Web Tools: `https://siebeltraining.shreejientserv.in/siebel/app/webtools/enu`

---

## Lab Schedule (Day 1)

| Time (IST) | Module | Hands-On Exercise |
|---|---|---|
| 12:30 – 13:00 | Session 1: Welcome & CRM Overview | Orientation, Browser Setup & Login Verification |
| 13:00 – 14:00 | Session 2: Customer Data Management | **Lab 1:** Account & Contact Exploration, Search & Predefined Queries |
| 14:00 – 14:10 | *Break* | |
| 14:10 – 15:00 | Session 3: Security & Access Control | **Lab 2:** Organizations, Positions, Responsibilities & Visibility |
| 15:00 – 15:45 | Session 4: Siebel Architecture & Tools | **Lab 3:** Web Tools Inspection, Applets, Views & BC Exploration |
| 15:45 – 16:15 | *Meal Break* | |
| 16:15 – 17:15 | Session 5: Application Customization | **Lab 4:** Workspaces, Field Tracing & Parameter Inspection |
| 17:15 – 17:25 | *Break* | |
| 17:25 – 18:15 | Session 6: Workflow Concepts | **Lab 5:** Business Process Automation & Workflow Inspection |
| 18:15 – 19:00 | Session 7: Service Requests & SLAs | **Lab 6:** Trouble Ticket Logging, Severity, Activities & SLA Timers |

---

## Lab 1: Account & Contact Exploration & Query Mastery

### Objective
Learn to locate your dedicated customer account, verify linked contacts, edit records, and create saved predefined queries (PDQs).

### Your Dedicated Training Identity
Every participant operates on their designated ID (`XX` = your 2-digit trainee number, e.g., `01`, `02`, ... `09`):
- **Your Account:** `TRAIN26-TXX Telecom Customer`
- **Location:** `TRAIN26-TXX`
- **Assigned Contacts:** 6 contacts linked to your account (e.g., `TXX-C01` through `TXX-C06`)

### Step-by-Step Instructions

1. **Log in to Siebel eCommunications**:
   - Navigate to `https://siebeltraining.shreejientserv.in/siebel/app/ecommunications/enu`.
   - Log in with your assigned trainee credentials (`TRAINEE01`–`TRAINEE09`).
2. **Locate Your Account**:
   - Click the **Accounts** screen tab.
   - Click the **Query** (magnifying glass) button in the Account List Applet.
   - In the **Name** field, enter: `TRAIN26-T*` (or your specific ID `TRAIN26-TXX*`).
   - Press `Enter` or click **Go**.
   - Verify that your account record is displayed.
3. **Drill Down to Contact Relationships**:
   - Click the blue hyperlink on your account's **Name**.
   - You are navigated to the **Account Detail - Contacts View**.
   - Count the contacts linked to your account. You should observe exactly **6 contacts**.
4. **Inspect Contact Attributes**:
   - Note the **Job Title**, **Work Phone**, and **Email Address** for your contacts.
   - Select contact `01` and update the **Main Phone Number** with `+91 98765 432XX`.
   - Step off the record (click the next row or press `Ctrl + S`) to save. Verify the record commit.
5. **Create a Saved Query (PDQ)**:
   - Navigate back to the **Contacts** screen tab.
   - Click **Query**. In the **Last Name** field, type `TXX*`.
   - Click **Go** to see only your contacts.
   - In the upper right query dropdown, click the drop menu and select **Save Query As**.
   - Enter Query Name: `My Trainee Contacts`. Click **Save**.
   - Switch the view to "All Contacts", then use your saved query dropdown to instantly recall your filtered list.

### Verification Checkpoint
- [ ] Account `TRAIN26-TXX Telecom Customer` successfully retrieved.
- [ ] Exactly 6 linked contacts confirmed.
- [ ] Contact phone updated and saved.
- [ ] Saved Query `My Trainee Contacts` appears in the query dropdown.

---

## Lab 2: Visibility & Access Control

### Objective
Understand how Organizations, Positions, and Responsibilities control what data and application screens a user can access.

### Background Concept
- **Organization:** Single / Multi-org partition (Default: `Default Organization`).
- **Position:** Determines data visibility (My Accounts vs My Team's Accounts vs All Accounts Across Org).
- **Responsibility:** Determines view/screen navigation access (e.g., Siebel Administrator, Sales Representative, Customer Care Agent).

### Step-by-Step Instructions

1. **View Your User Profile**:
   - In the upper right corner, click the **Settings / Cogwheel** icon > **User Profile** (or `File` > `User Profile`).
   - Check your assigned **Current Position** and **Primary Organization**.
2. **Examine View Level Visibility**:
   - Navigate to the **Accounts** screen. Notice the view tabs below the screen bar:
     - `My Accounts` (records where your position is the primary or on the team).
     - `My Team's Accounts` (records owned by your reporting hierarchy).
     - `All Accounts Across Organization` (records visible within your organization).
3. **Compare Record Ownership**:
   - On the Account List, open the Columns Displayed dialog (Menu > Columns Displayed).
   - Add the **Primary Position** and **Organization** columns to your list applet.
   - Observe that all 11 training accounts are associated with `Default Organization`.

### Verification Checkpoint
- [ ] Identified current position and primary organization.
- [ ] Understood difference between `My Accounts` and `All Accounts Across Organization`.

---

## Lab 3: Architecture & Web Tools Exploration

### Objective
Learn the 4-layer Siebel object architecture: Data Layer (Tables/Columns) → Business Layer (Business Components / Business Objects) → Logical UI (Applets / Views) → Web Client Presentation.

### Step-by-Step Instructions

1. **Open Siebel Web Tools**:
   - Open a new browser tab: `https://siebeltraining.shreejientserv.in/siebel/app/webtools/enu`.
   - Log in with your credentials.
2. **Trace an Applet to a Business Component**:
   - In the Object Explorer on the left, expand **Applet**.
   - In the query bar, search for `SIS Account List Applet`.
   - Review the properties:
     - **Business Component:** `Account`
     - **Class:** `CSSFrameList`
     - **Title:** `Accounts`
3. **Trace a Business Component to a Database Table**:
   - In Object Explorer, click **Business Component**.
   - Query for Name: `Account`.
   - Notice property **Table:** `S_PARTY` / `S_ORG_EXT`.
   - Click the expand icon under Business Component and select **Field**.
   - Query for Field: `Name`. Notice **Column:** `NAME`.
   - Query for Field: `Location`. Notice **Column:** `LOC`.
4. **Identify the Business Object**:
   - In Object Explorer, click **Business Object**.
   - Query for `Account`.
   - Under Business Object, click **Business Object Component**.
   - Notice the child BCs: `Account`, `Contact`, `Opportunity`, `Service Request`. This controls master-detail relationships!

### Architecture Reference Map
```
┌────────────────────────────────────────────────────────┐
│ UI Layer: SIS Account List Applet / Account Detail View│
└───────────────────────────▲────────────────────────────┘
                            │
┌───────────────────────────┴────────────────────────────┐
│ Business Layer: Account BC  (Child: Contact, Oppty)    │
│ Business Object: Account                               │
└───────────────────────────▲────────────────────────────┘
                            │
┌───────────────────────────┴────────────────────────────┐
│ Data Layer: S_PARTY, S_ORG_EXT, S_CONTACT, S_OPTY      │
└────────────────────────────────────────────────────────┘
```

### Verification Checkpoint
- [ ] Located `SIS Account List Applet` in Web Tools.
- [ ] Mapped `Account` BC to underlying table `S_ORG_EXT`.
- [ ] Verified fields `Name` -> `NAME` and `Location` -> `LOC`.

---

## Lab 4: Service Requests & SLA Management

### Objective
Log a telecom trouble ticket, assign priority, document resolution activities, and understand SLA tracking.

### Scenario
Customer `TRAIN26-TXX Telecom Customer` reports that their fiber broadband service is experiencing intermittent dropouts after router firmware upgrade.

### Step-by-Step Instructions

1. **Navigate to Service Requests**:
   - In Siebel eCommunications, click the **Service Requests** screen tab.
   - Click **New** (`Ctrl + N`) to create a new Service Request (SR).
2. **Fill Trouble Ticket Details**:
   - **SR Number:** Auto-generated by system (e.g., `1-XXXXXXXX`).
   - **Account:** Click the pick applet, select `TRAIN26-TXX Telecom Customer`.
   - **Contact:** Pick `TXX-C01` contact.
   - **Area:** `Network / Broadband`.
   - **Sub-Area:** `Fiber Connectivity`.
   - **Severity:** `2 - High`.
   - **Priority:** `2 - High`.
   - **Status:** `Open`.
   - **Abstract (Summary):** `Intermittent broadband packet loss - 100Mbps fiber line`.
   - **Description:** `Customer reports connection reset every 15 minutes. Router power cycled; issue persists. Requested line test.`
   - Save the record (`Ctrl + S`).
3. **Add Diagnostic Activity**:
   - In the child applet under the SR, navigate to the **Activities** tab.
   - Click **New**.
   - **Type:** `Technical Diagnosis`.
   - **Status:** `In Progress`.
   - **Description:** `Initiated remote optical line termination (OLT) loopback test.`
   - Save the activity.
4. **Resolve the Ticket**:
   - Update the Activity **Status** to `Done`, with Comments: `OLT signal recalibrated. Ping loss 0%. Stable for 30 minutes.`
   - On the parent SR, change **Status** from `Open` to `Closed`.
   - Set **Sub-Status:** `Resolved by Technical Support`.
   - Save the record.

### Verification Checkpoint
- [ ] Service Request successfully created and linked to your training account and contact.
- [ ] Child activity logged and marked Done.
- [ ] Parent SR transitioned from `Open` to `Closed`.

---

## Day 1 Self-Assessment Quiz

1. **Which Siebel table stores the core Account master record extension?**
   - [ ] A) `S_CONTACT`
   - [ ] B) `S_ORG_EXT`
   - [ ] C) `S_SRV_REQ`
   - [ ] D) `S_USER`
2. **What controls which views and screens a user can see in the application menu?**
   - [ ] A) Primary Organization
   - [ ] B) Position Hierarchy
   - [ ] C) Responsibility
   - [ ] D) Predefined Query (PDQ)
3. **In the Siebel 4-layer architecture, what connects an Applet to the Database Table?**
   - [ ] A) Web Template
   - [ ] B) Business Component (BC)
   - [ ] C) Screen
   - [ ] D) Integration Object

*(Answer Key: 1-B, 2-C, 3-B)*
