Manifest Object Deletion Is Not Clearing The Intersection Table Between Object Expression And Files
Last updated on FEBRUARY 15, 2018
Applies to:Siebel Life Sciences CRM - Version 8.1.1  to 184.108.40.206 [IP2014] [Release V8]
Siebel Tools - Version 8.1.1  and later
Information in this document applies to any platform.
On : 220.127.116.11 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms