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:

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

Changes

Cause

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