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

Last updated on SEPTEMBER 28, 2022

Applies to:

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

Changes

Cause