Orphan Records In Products And Product Line Inter Table S_PROD_LN_PROD Table

(Doc ID 2270070.1)

Last updated on MAY 25, 2017

Applies to:

Siebel CRM - Version 16.6 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.6 [IP2016] version, Order Management

ACTUAL BEHAVIOR
---------------
The records are not getting deleted from Inter table(S_PROD_LN_PROD) on Undo Record.

EXPECTED BEHAVIOR
-----------------------
Records in inter table S_PROD_LN_PROD should get deleted automatically when the user does Undo Record.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to application.
2. Navigate to Administration - Product >> Product Line.
3. Create a Product line and associate a product to it.
4. Goto Administration - Product >> Products.
5. Query for previously associated product in the Product Line.
6. Goto Menu and click on CopyRecord.
7. Now again goto Menu and click on UndoRecord.
8. Open DB and query in SIEBEL.S_PROD_LN_PROD inter table. The previously created record via CopyRecord is still present in the intertable even after Undo Record

BUSINESS IMPACT
-----------------------
At Swisscom, Product Line functionality is used heavily in:
1) Eligibility & Compatibility based on Product Lines
2) Custom RSTT based engines also using Product Lines
3) Order processing logic
Because of these Orphan records, we have found some unexpected results in the evaluation.

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