Cannot Create Reciprocal Relationship when Related EMPLID is of Unknown Gender (Doc ID 1243994.1)

Last updated on JANUARY 30, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 8.9 to 9.2 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

On :  CS all version, Relationships

When attempting to add a relationship via the page Campus Community > Personal Information > Relationships > Relationship and the gender of the related ID is unknown the following error occurs.

ERROR
-----------------------
Cannot create reciprocal relationship with IDxxxx. Relationship table setup is necessary.  (14000, 122)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Verify that the setup for relationships is correct via the page Setup SACR - Product Related > Campus Community > Define Campus Community > Setup - Relationship Table.
The setup should be as an example: for relationship of Father male 3 rows of reciprical relations - Daughter female, Son male, Other relative unknown.
Same table for Daughter female shows Mother female, Father male, Other Relative unknown.  for Son male same.
For other relative all, other relative all.
2. add a relationship via the page Campus Community > Personal Information > Relationships > Relationship page of Father for someone listed as unknown gender.
3. Get the error on the save.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create the correct reciprocal relationships without first identifying the sex of both people.  Sometimes the sex is not known.

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