Manifest Object Deletion Is Not Clearing The Intersection Table Between Object Expression And Files
(Doc ID 1959964.1)
Last updated on FEBRUARY 15, 2018
Applies to:Siebel Life Sciences CRM - Version 8.1.1  to 220.127.116.11 [IP2014] [Release V8]
Siebel Tools - Version 8.1.1  and later
Information in this document applies to any platform.
On : 18.104.22.168 SIA  version, Client Functionality
On deleting parent manifest information the data of child Object Expression still present in intersection table.
On deleting parent manifest information the data of child Object Expression should get deleted from intersection table.
The issue can be reproduced at will with the following steps:
Navigate to Manifest Administration . Create a Manifest Object (1st applet) , Create a child Object Expression (2nd applet), Add a file (3rd applet). Note Down the Row Id from the 2nd applet. For example, 1-5RVH.
Now delete the Manifest Object (record from 1st applet).
Run these queries in the database
select * from S_UI_OBJ_EXPR where row_id = '<row id noted above>'
No records are retrieved which is correct.
select CREATED, UI_OBJ_EXPR_ID from S_UI_OBJ_EXP_FL WHERE UI_OBJ_EXPR_ID = '<row id noted above>';
Note that one record is retrieved with UI_OBJ_EXPR_ID equals to the Row Id as noted above, this is incorrect because no record should be retrieved.
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