Rows in SR_RELATIONSHIP Created with LAST_MODIFIED_USERID = APP_MSLV Instead of Id from the Actual User (Doc ID 2064548.1)

Last updated on JULY 01, 2022

Applies to:

Symptoms

MetaSolv Solution version 6.2.1.849.17

When associating a child order through the Service Request Hierarchy window, the LAST_MODIFIED_USERID and CREATE_USERID values on the ASAP.SR_RELATIONSHIP table are being set to 'APP_MSLV' instead of the actual MetaSolv Solution application user ID that created the relationship.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Order Management

2. Service Request

3. Query for a "PSR" order

4. Right click on the order in the Service Request Search window and select "Service Request Hierarchy..."

5. Right click on the order in the Service Request Hierarchy window and select "Associate Child Order..."

6. Query for the desired order

7. Select the order and click OK

8. Use the query below to verify the data (? = document_number of the parent order)

BUSINESS IMPACT
-----------------------
Due to this issue, it is impossible to determine the actual MetaSolv Solution application user ID that created the relationship. Affects auditing.

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.