After Enabling Revision Specific Relationships, Relationships Tab Behavior Is Inconsistent, Duplicate Relationships Added to the New Revision and Relationship Added In Older Revision Disappers (Doc ID 2899537.1)

Last updated on JANUARY 24, 2024

Applies to:

Symptoms

Actual Behavior

After releasing the Change with the object with relationship objects, Relationships tab behavior is inconsistent, the new revision is showing duplicated relationship objects and the relationship object added to the previous revision is removed.
This will make the same item added twice and create duplicated rows if there was no change in the relationship tab from the earlier revision, and the one added to previous revision gets deleted.

Expected Behavior

After releasing the Change with the object with relationship objects, the relationship objects added to the previous revision is copied to the new revision (will be added only once), and the one added to previous revision remains in the previous version


Steps

The issue can be reproduced at will with the following steps:

1. Log into Java Client as admin user, and go to Admin tab > Settings > Data Settings > Classes
2. Open Parts > User Interface Tabs > Relationships > Attributes:Relationships, and open Revision
3. Change Visible to Yes, and OK
4. Gets below warning:
   "WARNING! If you enable the revision attribute, it cannot be easily disabled later. Once you have enabled the revision attribute, users are allowed to create multiple Revision-Specific relationships on the Relationships tab. If you disable the revision attribute later, you must first resolve all multiple rows (one row for each revision of the same object) to a single ALL to ALL relationship row for all Parts with Revision-Specific relationships.
   Click Yes to proceed."
5. Click Yes
6. Do the same for Documents.Relationships.Revision field
7. Go to Admin tab > System Settings > SmartRules, and set [Copy Relationships To Rev] to "Copy" and Save
8. Log into Web Client, and create a part P01
9. Go to Relationship tab, and add a part P02
   
10. Actions > Create New > Changes, and create a new Change
11. Set Workflow to the Change, and go to Affected item's tab, and set New Rev (Revision) to 1 for P01
12. Release Change.
13. Open the Part P01, and go to Relationships tab. Show released revision 1.
    See there are two rows of P02 added. Revision shows "Last-Introductory" for both of the rows.
    
    Expected Result: See only one row for P02
14. Select Introductory revision. No row shows in Relationship tab.
    
    Expected Result: See one row for P02
    
    

Changes

Enabled Revision-Specific Relationships, and set SmartRules > Copy Relationships To Rev to "Copy"

Cause

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