Assignment Skills Uniqueness Check Affecting Appointment Booking And The Siebel/ORS Flow
(Doc ID 2487755.1)
Last updated on SEPTEMBER 28, 2022
Applies to:Oracle Real-Time Scheduler - Version 18.104.22.168.0 and later
Siebel CRM Integration to Oracle Realtime Scheduler - Version 22.214.171.124 SIA  and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, Siebel Integration
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.
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!