Manifest Object Deletion Is Not Clearing The Intersection Table Between Object Expression And Files on IP16
Last updated on JANUARY 16, 2018
Applies to:Siebel CRM - Version 16.7 [IP2016] to 16.10 [IP2016] [Release V16]
Information in this document applies to any platform.
On : IP16 Patchset 7, 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.
Now delete the Manifest Object (record from 1st applet) or delete the Object Expression (2nd applet).
Run these queries in the database
select * from S_UI_OBJ_EXPR where row_id = <Row Id>
No records are retrieved.
select CREATED, UI_OBJ_EXPR_ID from S_UI_OBJ_EXP_FL WHERE UI_OBJ_EXPR_ID = <Row Id>;
Note that record is retrieved with UI_OBJ_EXPR_ID equals the <Row Id> as noted above
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