The Word "CALL"/"CALLS" is Not Valid in Custom SQL of a Rules and Behavior
(Doc ID 2409953.1)
Last updated on MARCH 21, 2019
Applies to:Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.
On : 6.2.1 version, Other
The word "CALL" or "CALLS" is not valid in CUSTOM SQL even if it uses it as a string
Users encountering the below ERROR. Used custom SQL since one of the condition we needed is not available/ visible in the expression (condition dropdown) in MSS
The issue can be reproduced at will with the following steps:
1-Making a Rule in MSS
2-Create an Expression by putting the below custom SQL for rule kick in condition :
select count(*) from psr_user_data pud, serv_Req_si_value srsv, serv_Req_si srs
where pud.document_number = srsv.document_number
and srsv.document_number = srs.document_number
and srs.item_alias = 'Transfer of Calls'
and srs.serv_item_id = srsv.serv_item_id
and (srsv.value_label = 'ABCD' and srsv.valid_value in ('999', '888'))
and pud.document_number = '?'
and (PlanName='ABCD POTS PLAN')
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document