ORA-00936 error in SP_RULES when assigning Provisioning Plan

(Doc ID 1982598.1)

Last updated on FEBRUARY 22, 2017

Applies to:

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


MetaSolv Solution version 6.2.1

The MetaSolv Solution application throws an Oracle ORA-00936 error in sp_rules when attempting to assign a Provisioning Plan using GUI. This error was observed after upgrading from a test environment from 6.0.15 to 6.2.1.

Text of error in GUI

10. Click Save and Close

11. Click Create in the Task Behaviors section

12. Configure the system to insert a task

     What do you want the task behavior to do? Insert Task
     What Task Type do you want to associate with the behavior? {Choose a Task}
     When do you want the action to occur? Task Generation
     By Work Queue: {Choose a Work Queue ID}

13. Click Next

14. Click Finish

15. Assign the Provisioning Plan to a PSR order and the "ORA-00936: missing expression" error is thrown.

Business Impact

Unable to assign the Provisioning Plan to an order


This problem affects customers upgrading from 6.0.X to 6.2 and already using Rules and Behaviors functionality.  The problem also affects customers running with 6.2 and are just getting started with implementing Rules and Behaviors functionality. 



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