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:

Symptoms

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.

Changes

Cause

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