Internet Explorer Script Errors Updating Rules And Behaviors Expression With Custom SQL (Doc ID 2238445.1)

Last updated on AUGUST 29, 2024

Applies to:

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

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