Cannot Create Reciprocal Relationship when Related EMPLID is of Unknown Gender
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.
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.
Cannot create reciprocal relationship with IDxxxx. Relationship table setup is necessary. (14000, 122)
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.
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.
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