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 [21112] to 8.1.1.14 [IP2014] [Release V8]
Siebel Tools - Version 8.1.1 [21112] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11 SIA [23030] version, Client Functionality

ACTUAL BEHAVIOR

On deleting parent manifest information the data of child Object Expression still present in intersection table.

EXPECTED BEHAVIOR

On deleting parent manifest information the data of child Object Expression should get deleted from intersection table.

STEPS

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.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms