ORA-00001: Unique Constraint (ASAP.PK_SR_RELATIONSHIP) Error Relating PSR Orders After Order Split

(Doc ID 2197588.1)

Last updated on NOVEMBER 14, 2016

Applies to:

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

Symptoms

An "ORA-00001: unique constraint (ASAP.PK_SR_RELATIONSHIP)" error is thrown when attempting to relate PSR orders where one of the orders was created using the Order Split functionality. Below are the error messages (text and images) displayed in the order they are received.

Error 1

 

Recreation Steps

1. Order Management

2. Service Requests

3. Add New > Product Service Request > OK

4. Create the PSR order and add parent and child service items

5. Close the order

6. Query for the PSR order

7. Right click on the order in the Service Request Search window and select "Order Split..."

8. Select all the service items in the PSR Order Split Selection window and click OK

9. Immediately close the newly created order

10. Query for both of the PSR orders

11. Right click on the original order and select "Service Request Hierarchy..."

12. Right click on the order and select "Associate Child Order..."

13. Query for the order created using Order Split and click OK. This is where the error occurs.



Cause

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