My Oracle Support Banner

Personal Details - Adding Ethnic Group Throws Error When Reg Region Is Blank (Doc ID 2292015.1)

Last updated on SEPTEMBER 26, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When attempting to add Ethnic group in Personal Details while Reg Region is blank in the Primary Permission list,
the following error occurs.

SetID not found for name='REG_REGION', value='' with record 'ETHNIC_GRP_TBL', tree ''.
HR_FL.ESS.EthnicGroups.OnExecute Name:GetEthnicGroupPromptSQL PCPC:23743 Statement:405
Called from:HR_FL.ESS.EthnicGroups.OnExecute Name:PageActivate Statement:87
Called from:HR_ETHNIC_GRP_SCF.Activate Statement:1
The PeopleCode built-in function GetSetID has been called with parameters that were
not found in the table set definitions.

Review the table set control tables and the PeopleCode and correct whichever is wrong.

The issue can be reproduced at will with the following steps:
1) Please use an User Profile with setup mentioned in either Option A or Option B.
(A) Either create a new user profile with access to Personal Details including the Ethnic Groups page but don’t assign a Primary Permission List. Alternatively using your existing user profile, assuming it has access to this page, remove the Primary Permission List and save.
(B) A second option is to note down the Primary Permission List of your current user profile. Navigate to Setup HRMS > Foundation Tables > Organization > Org Defaults by Permission Lst, select the Primary Permission List that was in the user profile and remove the Reg Region and save.

2) Click on the Home button then select Employee Self Service from the home pages drop down list.

3) Click on the Personal Details tile.

4) Click on Ethnic Groups from the right hand menu.

5) Click on Add an Ethnic Group

6) Error is thrown


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.