My Oracle Support Banner

RELATION_SALU Record Not Updated When Relationship is Dissolved (Doc ID 2858276.1)

Last updated on MARCH 28, 2022

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.


Joint Communication Management data (RELATION_SALU record) is not updated when a relationship is dissolved and joint communication previously existed. Although the 'Create Joint Communication' box on the Joint Communication Management back is unchecked, and the original data remains in the RELATION_SALU record.

Steps to reproduce the issue:

  1. Navigate to Campus Community > Personal Information > Biographical > Relationships > Relationships
  2. Search for existing ID
  3. Insert a new effective dated row to the Relationships tab;
  4. Select the Relationship value of 'Ex-Spouse';
  5. Click on Joint Communication Management button
  6. Uncheck the Create Joint Communication' box;
  7. Update the Dissolution Reason to "Divorce";
  8. Click OK;
  9. On the Relationships tab of the component, click Save;
  10. Click on the Joint Communication Management button;
  11. Note the Joint Communication data reflects the changes made in Steps 3-9;
  12. Run the following SQL query against the database:
  13. Note the original relationship information is retained, and not updated to reflect the Divorce status.




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.