ETL9.2: Not Able To Create A TRC Mapped To Absence Management.Error: SQL error in Exec. (2,280) TL_ERNCD_TBL.PAY_SYSTEM.SaveEdit PCPC:679 Statement:5 (Doc ID 2275116.1)

Last updated on JUNE 08, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, TL Installation and Setup

Not Able to create a TRC mapped to Absence Management

Getting SQL error when choosing an AM Earnings code and try to save the new TRC.

ERROR
-----------------------
A fatal PeopleCode SQL error occurred. Please consult your system log for details

SQL error in Exec. (2,280) TL_ERNCD_TBL.PAY_SYSTEM.SaveEdit PCPC:679 Statement:5

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Set Up HCM--> Product Related-->Time and Labor --> Time Reporting --> Time Reporting Codes-TRC
choose 'Map To Absence Managment'

Try to save and the SQL error is encountered.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create a TRC mapped to Absence Management

Cause

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