My Oracle Support Banner

SQL Error and PeopleCode Error (18081,1018) When Submitting Intermittent FMLA Leave (Doc ID 2538814.1)

Last updated on NOVEMBER 26, 2021

Applies to:

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


Users are encountering the following SQL and PeopleCode errors when trying to submit an FMLA intermittent leave:

A SQL error occurred. Please consult your system log for details.

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

Caught exception: GP_ABS_SS_DAT is not a valid header record name; expected a record of name GP_ABS_EA_AWE. (18081,1018) EOAW_CORE.ApprovalManager.OnExecute Name:ApprovalManager PCPC:1188 Statement:17
Called from:HMAF_AWE.WRAPPERS.ApprovalManager.OnExecute Name:ApprovalManager Statement:3
Called from:HMAF_AWE.ApprovalsFactory.OnExecute Name:getApprovalManager Statement:7
Called from:GP_ABS_MGRSS_REQ.GBL.SavePostChange Statement:103 (0,0)

The issue can be reproduced at will with the following steps:
1. Navigation: Manager Self Service > Time Management > Report Time > Absence Request
2. Select employee, enter Intermittent FMLA absence and submit request as "Employee"
3. Click Yes to Confirm submission, and note the above errors are returned as you click OK through the pop up messages




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.