👤 TRAINEE08

Day 2 Practical Assignment — TRAINEE08

Oracle Siebel eCommunications | Telecom Sales, Marketing Lifecycle & Reporting
⏱️ Total Duration: 3 Hours

💼 Lab 1: Telecom Sales Opportunity & Quote Lifecycle (60 minutes)

Your Assigned Account: TRAIN26-T08 Telecom Customer | Primary Contact: Learner08 Contact01

Part A: Create Commercial Opportunity

  1. In Siebel eCommunications, navigate to Opportunities.
  2. Click New (Ctrl + N).
  3. Enter Opportunity details:
    • Opportunity Name: TRN26-T08 Broadband Upgrade 2026
    • Account: Select TRAIN26-T08 Telecom Customer
    • Lead Quality: High
    • Sales Stage: 02 - Qualifying
    • Probability %: 25
    • Revenue: 1,200 (Estimated annual contract value)
  4. Save the record (Ctrl + S).

Part B: Create & Price the Quote

  1. Under your Opportunity record, switch to the child Quotes tab and click New.
  2. Enter Quote details:
    • Quote Name: TRN26-T08 B2B Fiber Quote
    • Price List: Select Standard Telecom Price List
  3. Drill down on your Quote Name link to open the Quote Detail - Line Items View.
  4. Add Line 1: Click New → Product: TRAIN26 Business Broadband 100 → Qty: 1 (Recurring MRC: $60.00/mo).
  5. Add Line 2: Click New → Product: TRAIN26 Managed Business Router → Qty: 1 (Hardware NRC: $120.00).
  6. Add Line 3: Click New → Product: TRAIN26 Broadband Installation → Qty: 1 (Labor NRC: $50.00).
  7. Inspect the Quote Totals banner: verify Recurring MRC Total = $60.00/mo, Non-Recurring NRC Total = $170.00, Total Net Price = $230.00.

Part C: Convert to Sales Order & Simulated Provisioning

  1. On the Quote header, click Auto Order (or navigate to Sales Orders → New).
  2. Verify generated Order Number and confirm that lines roll up without pricing discrepancies.
  3. Set Order Status to Submitted.
  4. Takeaway: In telecom operations, submission initiates provisioning. Once complete, Broadband and Router create persistent records in S_ASSET, while transient installation labor is excluded.

📢 Lab 2: Siebel Marketing Lifecycle, Segmentation & Responses (60 minutes)

Your Assigned Campaign: TRN26-T08 Broadband Acquisition

Part A: Verify Campaign & Organizational Setup

  1. Navigate to Marketing → Campaigns in Siebel eCommunications or Call Center.
  2. Query for your campaign: Name = TRN26-T08 Broadband Acquisition.
  3. Verify campaign attributes: Status = Active, Currency = USD, Budget = $5,000.

Part B: Segmentation Query & Suppression Validation

  1. Navigate to the Contacts screen.
  2. Execute the Targeting Segmentation Query:
    • Click Query.
    • In Comment enter: *ACQUISITION-ELIGIBLE*.
    • In Last Name enter: *Contact*.
    • Click Go. Notice your 4 eligible candidate contacts.
  3. Execute the Exclusion & Suppression Query:
    • Click Query → In Comment enter: *EXCLUDE-OPTOUT* → Click Go.
    • Inspect Learner08 Contact05.
    • Verify that privacy suppression flags are enabled: Do Not Call = Y, Do Not Email = Y.
    • Key Rule: In automated marketing wave execution, suppression flags prevent non-compliant communications.

Part C: Capture Response & Closed-Loop Opportunity Handoff

  1. Drill down into Learner08 Contact01.
  2. Navigate to the child Responses applet and click New.
  3. Enter Response details:
    • Campaign: Select TRN26-T08 Broadband Acquisition
    • Response Type: Inbound Inquiry
    • Response Method: Web Form
    • Status: Qualified - Lead Generated
  4. Save the response.
  5. Click Create Opportunity (or note the qualified response) to complete closed-loop marketing-to-sales attribution!

📊 Lab 3: Current Query Reporting & Direct Export (45 minutes)

Part A: Inspect BI Publisher Templates & Integration Objects

  1. Navigate to Site Map → Administration - BI Publisher Reports → Reports - Templates.
  2. Query for Template Name aclist (Account List).
  3. Inspect the bound Integration Object: BIP Accounts - Current Query.
  4. Query for cntlist (Contact List) and oplist (Opportunity List).
  5. Key Insight: Current Query reports extract XML based on the active UI query and the Integration Object search specification, regardless of single row selections.

Part B: Execute Operational Export & Audit Extract

  1. Navigate to the Accounts screen.
  2. Execute query: Name = TRAIN26*.
  3. Click the Menu button on the Account List Applet and select Export.
  4. Configure export settings:
    • File Format: Comma Delimited Text File (*.csv)
    • Rows to Export: All Rows in Current Query
    • Columns to Export: Visible Columns
  5. Click Next and download the CSV file.
  6. Open the CSV in your browser or text editor and confirm that all 11 telecom training accounts appear with exact locations and phone numbers.