My Oracle Support Banner

Update Contracts Page Returns Error ORA-00904 When Saved Without a Value In Field PROBATION_DT (Doc ID 2682144.1)

Last updated on AUGUST 28, 2023

Applies to:

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


When a new row is saved on Page CONTRACT3 CNT_PROBATION.PROBATN_REASON, without a value in Field PROBATION_DT, a popup message returns an error, and
the row is not saved.

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

User clicks OK, then sees

"an error has occurred which requires that this page be cancelled. (15,4)
A previous error message has been displayed showing an error from which the
component processor can not recover.  You must cancel the current page and reselect it."

If the user also supplies a PROBATION_DT before saving, the error does not occur, and the row is saved.

The issue can be reproduced at will with the following steps:
1. Login as PSFT Admin.
2. Navigate to Workforce Administration > Job Information > Contract Administration > Update Contracts
   Find an existing value = K% > open an existing contract for USERID
3. Click on Signature Date/Probation Info Tab > Probation Information pagelet.  Click the + sign to add a new row.
4. Skip the Probation Date field, and go to the Reason field.  Select a value from the drop down.  Without entering a Date,click Save.


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.