Manifest Object Deletion Is Not Clearing The Intersection Table Between Object Expression And Files on IP16

(Doc ID 2246668.1)

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.

Symptoms

On : IP16 Patchset 7, 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) 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

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