My Oracle Support Banner

ORA-00907 Error in SP_RULES When Assigning Provisioning Plan (Doc ID 1982599.1)

Last updated on MARCH 08, 2019

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-00907 error in sp_rules" when attempting to assign a Provisioning Plan using GUI.

Text of error in GUI


The issue can be reproduced at will using the steps below in the GUI:

1. Application Setup

2. Order Management Setup

3. Product Catalog

4. Right click on Product Catalog package icon and select Add Item

5. Configure a simple Non Premise Product having an Item Alias name that includes single quotes

Example: Oracle 'Non Premise Product'

6. Application Setup

7. Work Management Setup

8. Rules and Behaviors

9. Add New

10. Enter Rule Name and Rule Type = PSR Product Service Request

11. Click Save and Close

12. Click Edit in the Expression section

13. Click Add Condition

14. Enter the following data

     Condition: PRODUCT
     Operator: =
     Value: Oracle 'Non Premise Product'

*** NOTE: Do NOT enter parenthesis values in the fields surrounding the expression ***

15. Click Save and Close

16. Click Create in the Task Behaviors section

17. 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}

18. Click Next

19. Click Finish

20. Create a PSR order and add the newly created Product Catalog item; Oracle 'Non Premise Product'

21. Assign a Provisioning Plan to the order and the "ORA-00907: missing right parenthesis" error is thrown.

Business Impact

Unable to assign the Provisioning Plan to an order




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

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