My Oracle Support Banner

ERR: Pay Calendar build error (2,214): "SetID not found for name='COMPANY', val (Doc ID 607730.1)

Last updated on NOVEMBER 26, 2021

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 7.5 and later
Information in this document applies to any platform.

Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 43553


Data was converted into the PeopleSoft HRMS database using Import Manager.  Subsequently there was a problem when attempting to create Pay Calendar entries.
Prior to setting up Pay Calendars, a pre-requisite is to define the Balance ID(s) associated with each SetID for which data will be exported or imported.  This was duly done without any problems -- the customer inserted rows into the PS_BALANCE_ID_TBL, PS_BALANCE_ID_DEF and PS_BALANCE_ID_QTR tables.
However, when the user attempted to create a Pay Calendar for the PayGroup, the following error message was generated:
     "SetID not found for name='COMPANY', value='XXX' with record 'BALANCE_ID', tree ' '. (2,214)"

The PS_SET_CNTRL_REC table contained no rows for Company XXX.
There is PeopleCode that adds Company & SetID.  The Import Manager did not execute the PeopleCode, so these values were not inserted.



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.