My Oracle Support Banner

ETL 9.2 Error When Saving Workgroup or Maintain Time Reporter Data Changes - "A Fatal PeopleCode SQL Error Occurred..." (Doc ID 2895534.1)

Last updated on NOVEMBER 04, 2022

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Maintain Time Reporter Data and Workgroup  page giving  "A fatal PeopleCode SQL error occurred..."  error when inserting a row.
"A fatal PeopleCode SQL error occurred. Please consult your system log for details."


Steps to replicate:
1. Login as Manager
2. Navigate to  Time and Labor > Enroll Time Reporters > Maintain Time Reporter Data.
3. Select EE
4. Try to add new Effective Date row and save
5. Error can be seen


1. Login as Manager. Navigate to Setup HCM ->Product Specific -> Time and Labor-> Rules and Workgroups->Workgroups
2. Select group.
3. Insert effective dated row.
4. Change page values as needed.
5. Save.


 This error was being caused by a new App Package - SCH_RSLV_RTI_APP_PKG - trying to SQL from the PS_PTSF_INDEX table.


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.