My Oracle Support Banner

The Word "CALL"/"CALLS" is Not Valid in Custom SQL of a Rule (Doc ID 2409953.1)

Last updated on FEBRUARY 03, 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  .We  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')


The issue has the following business impact:
Due to this issue, users cannot .


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

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