My Oracle Support Banner

Record from Intersection Table is not Deleted (Doc ID 2631626.1)

Last updated on JANUARY 24, 2020

Applies to:

Siebel Call Center - Version 19.10 and later
Information in this document applies to any platform.


The record from the intersection table is not removed.

A custom intersection table CX_ASSET_REL is created based on S_ASSET. Both parent and child table is S_ASSET(because there are internal and external asset types).

The intersection table has two columns INT_ASSET_ID AND EXT_ASSET_ID.

S_ASSET table has 2 primary columns X_PR_ROUTER_ID and X_PR_TERMINAL_ID

2 BC's Asset Mgmt- Asset and Sxxxxx Internal Asset has the Primary fields, MVL and MVF defied, and MVG applets and association applets are created to relate the two types.

The association works. But when trying to remove the association , no error is encountered, but the record from the intersection table is not removed.

In the log file, there is a delete sql statement with ROW_ID = NULL which is not expected:

The ROW_ID in the delete sql statement should not be NULL.

The issue can be reproduced at will with the following steps:
1. Go to the applet that has the MVG field
2. Open the MVG applet an delete the mvg records
3. The record from intersection table is not deleted, and there is a delete sql statement with ROW_ID = NULL in the log




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.