Manifest Object Deletion Is Not Clearing The Intersection Table Between Object Expression And Files (Doc ID 1959964.1)

Last updated on JUNE 07, 2017

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.

Now delete the Manifest Object (record from 1st applet).

Run these queries in the database

select * from S_UI_OBJ_EXPR where row_id =

No records are retrieved.

select CREATED, UI_OBJ_EXPR_ID from S_UI_OBJ_EXP_FL WHERE UI_OBJ_EXPR_ID = ;

Note that record is retrieved with UI_OBJ_EXPR_ID equals the Row Id as noted above

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get data cleared from intersection table.

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