My Oracle Support Banner

Internet Explorer Script Errors Updating Rules And Behaviors Expression With Custom SQL (Doc ID 2238445.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.

Symptoms

Internet Explorer script errors are received in Rules and Behaviors when attempting to update the Expression with custom SQL.  The first two are received after clicking Edit on the Rule Summary page to update the Expression.  The Expression page appears and the final script error is received after making changes to the Custom SQL then clicking Save and Close.  However the updates are not saved after selecting "Yes" to the last script error.

Script Error 1



Recreation Steps

Edit the Expression of a Rules and Behavior event to use custom SQL.

1. Application Setup

2. Work Management Setup

3. Rules and Behaviors

4. Create or Edit a Rule with an Expression that uses Custom SQL

5. Ensure the Custom SQL has a carriage return when entered in the Custom SQL field like below. The carriage return is the catalyst.

    Problem occurs
    -----------------------------
    SELECT COUNT(1) FROM SERV_REQ_SI
    WHERE DOCUMENT_NUMBER = ?

    Problem does NOT occur
    -----------------------------
    SELECT COUNT(1) FROM SERV_REQ_SI WHERE DOCUMENT_NUMBER = ?

6. Click Save and Close

7. Immediately Edit the Expression and the first two script errors are thrown

8. Click Save and Close and the last script error is thrown and any changes will not be saved.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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