My Oracle Support Banner

Two Records Created in S_ACT_EMP After Undoing Activity Owner Changes (Doc ID 2835336.1)

Last updated on MARCH 27, 2022

Applies to:

Siebel CRM - Version 20.12 and later
Information in this document applies to any platform.

Symptoms

Two records being created in S_ACT_EMP after undoing activity owner changes as outlined in Doc ID 2661551.1
The issue was fixed in 20.9, but seeing a possible regression in 20.12 version.

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

Setup the 21.11 environment as follows:

(A) To allow non-owner modify activity, perform these steps:
1. Log into Siebel Tools
2. Navigate to Business component: "Action"
3. Then query for Field: "Non-Owner Read Only Flag"
4. The existing calculated value will show as:
IIf([Display]=LookupValue("ACTIVITY_DISPLAY_CODE","Calendar and Activity") AND [Primary Owned By]<>LoginName(),"Y","N")
5. Change this to simply: N
6. Compile the changes or Deliver the Workspace for IP17+
7. Restart the services
Additional information is available in "Activity Is Getting Readonly For Non Owner Users (Doc ID 2207902.1)"

(B) On Action Business Component, set Business Component user property "Delete Prior Owner On Reassignment" to Y

Steps to reproduce the issue:
------------------------------
1. Login to Siebel Application
2. Navigate to Activities
3. Create a New Activity and save it
4. Owner will be (say) SADMIN
5. Run the select statement on SQL Developer
--> select ROW_ID, ACTIVITY_ID, EMP_ID from SIEBEL.S_ACT_EMP;
6. One record with Owner as SADMIN is returned
7. Click on the Owner Pick Applet in the Siebel application
8. Select a new Owner and click ok
9. Run the select statement on SQL Developer
--> select ROW_ID, ACTIVITY_ID, EMP_ID from SIEBEL.S_ACT_EMP;
10. One record will still be returned at this point with new Owner
11. Click on the Owner Pick applet in the application
12. Select a new Owner and click ok
13. Now undo the record.
14. Run the select statement on SQL Developer
--> select ROW_ID, ACTIVITY_ID, EMP_ID from SIEBEL.S_ACT_EMP;
15. Two records are now returned from the SQL.

 

 

Changes

Applying Siebel patch update 20.12 or later, on top of 20.9

Cause

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
Symptoms
Changes
Cause
Solution
References


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