My Oracle Support Banner

EPY: Payroll Error 000103 - Earnings Code Specified is Not Found in the Earnings Program (Doc ID 607779.1)

Last updated on APRIL 11, 2024

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

  
ISSUE #1:  Customer was receiving Paycalc error message 000103 - "Earnings code specified is not found in the earnings program" - with message data pointing to an overtime earnings code.

They were a running a calc for an an off-cycle for an exempt employee.  The paysheet only had regular and vacation earnings, and some deductions.  The overtime earnings code that was erring out was not entered on the paysheet.

ISSUE #2:  Customer encountering error in pay calculation process - Error message 000103 - "Earnings code specified is not found in the earnings program" when entering prior period earnings on the paysheet.

Reviewing the COBOL trace information, the preceding SQL statement prior to the error is
SELECT 'X' FROM PS_ERN_PROGRAM_DEF WHERE ERN_PROGRAM=:1 AND EFFDT=:2 AND ERNCD=:3

Bind # 3 is a blank rather than an earnings code value.

Cause

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
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.