Internet Explorer Script Errors Updating Rules And Behaviors Expression With Custom SQL
Last updated on NOVEMBER 27, 2017
Applies to:Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.
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
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.
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.
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