My Oracle Support Banner

HR:SQL Error "SQL Error in Exec. During the execution of SQL, an error occured in the Exec subroutine, the preceding message should have described the SQL being executed" When Adding A Current Date Effdt With Future Effective Dated (Doc ID 2888258.1)

Last updated on JANUARY 30, 2024

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When attempting to add a current effective date in a newly created position number that has a maximum effective date of future date, the following error occurs.

The issue can be reproduced at will with the following steps:
1. Login as PS admin user.

2. From the Manager Home Page >> Select Position Management Tile >> Click on Create Position >> Create a new position number with a future date effective date.

3. Enter all the required position details and submit the position.

4. Once created, Add a new effective dated row with the current date (created above) in the same position number to see the error.




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.