The Word "CALL"/"CALLS" is Not Valid in Custom SQL of a Rule

(Doc ID 2409953.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

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

ERROR
-----------------------



STEPS
-----------------------
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')

 



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

Cause

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 hundreds of Community platforms