1. Field Service Integration to Oracle Real-Time Scheduler Implementation Guide
  2. Mapping an Activity Status From Oracle Real-Time Scheduler to Siebel CRM

Mapping an Activity Status From Oracle Real-Time Scheduler to Siebel CRM

This Oracle Real-Time Scheduler integration uses the ORS_to_Siebel_ActivityStatusMapping DVM while it synchronizes an activity status for an activity from Oracle Real-Time Scheduler to Siebel CRM. This integration maps an activity status from Oracle Real-Time Scheduler to Siebel CRM in the following situations:

  • If the call center agent clicks Refresh Activity to get the latest appointment details

  • If the activity status is updated to Despatched or Inactive in Oracle Real-Time Scheduler

Columns You Use to Map an Activity Status

To map a stop status, you use the following columns:

  • Column 1: ORS

  • Column 2: Siebel

Requirements for Mapping an Activity Status

If you use the ORS_to_Siebel_ActivityStatusMapping DVM, then you must make sure your mapping meets the following requirements:

  • The data in the ORS column must be unique. Multiple Oracle Real-Time Scheduler statuses can map to the same status in Siebel CRM. However, there must not be more than one entry in the map that contains the same status value in the ORS column.

  • The requirements to map a stop status are the same as the requirements to map an activity status.

DVM Entries That Map an Activity Status

ORS Column Siebel Column

M1SH

Schedule

M1DS

Dispatched

M1CA

Cancelled

M1DC

Declined

M1EN

Enroute

M1CO

Done

M1ON

In Progress