Adding an Affiliation Code to an EMPLID Results in Cannot Assign an Empty Rowset Error (14020,1)

(Doc ID 1196893.1)

Last updated on AUGUST 08, 2017

Applies to:

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


When attempting to add an Affiliation Code for an EMPLID, the following error occurs.

Cannot assign an empty rowset (14020,1) SCC_CONSTITUENT_MGR.UTIL.Utilities.OnExecute  Name:ConstructAppClassStringFromEventRegistry  PCPC:1864  Statement:39
Called from:SCC_CONSTITUENT_MGR.CONSTITUENT.ConstituentFactory.OnExecute  Name:GetInstance  Statement:23
Called from:SCC_CONSTITUENT_MGR.ConstituentManager.OnExecute  Name:GetConstituentFromMessage  Statement:51
Called from:SCC_CONSTITUENT_MGR.ConstituentManager.OnExecute  Name:PublishAffiliations  Statement:39

The issue can be reproduced at will with the following steps:
1) Navigate to  Main Menu > Campus Community > Affiliations > Add/Update Affiliations.
2) Click Add a New Value link.
3) Enter EMPLID and Institution.
4) Select an Affiliation Code and enter Start Date.
5) Click Save.


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