My Oracle Support Banner

Assignment Skills Uniqueness Check Affecting Appointment Booking And The Siebel/ORS Flow (Doc ID 2487755.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Real-Time Scheduler - Version 2.3.0.2.0 and later
Siebel CRM Integration to Oracle Realtime Scheduler - Version 8.0.0.10 SIA [20436] and later
Information in this document applies to any platform.

Symptoms

On : 2.3.0.2.0 version, Siebel Integration

ACTUAL BEHAVIOR
---------------
Assignment Skills Uniqueness check affecting the Siebel <> ORS flow

We found a scenario in the appointment booking module where ORS, while finding skills internally, queries using LIKE mechanism and '%’ sign at the end of the assignment skill. Post this it has a uniqueness check (whether the output received is a single value or multiple values) and some assignment skills which the business has fails those checks since some of the assignment skills has common starting words with extra letters at the end. This is out of the box functionality in ORS and was found from the weblogic logs.

Query:
select CAP_TYPE_CD,EXT_CAP_TYPE_CD,M1_SKILL_SET, CAPABILITY_CLS_FLG FROM M1_CAP_TYPE WHERE CAPABILITY_CLS_FLG = 'M1SK' AND EXT_CAP_TYPE_CD LIKE '<Assignment_Skill>%';

This is affecting the below inbound webservices:
 
M1-MaintainActivityByHost
M1-RouteAppointmentRequestToScheduler

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.