SQL Error when Selecting Contract Data Type in HCM 9.2.011: "A SQL Error has Occurred" (Doc ID 1984945.1)

Last updated on MARCH 01, 2015

Applies to:

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

Symptoms


When selecting a Contract Type on the Contract Data page, an error occurs, which is listed below.

Navigation is: Workforce Administration > Job Information > Contract Administration > Update Contracts, Contract Type/Clauses tab.
The same error occurs when entering a Contract Template ID on the Contract Status/Content tab in the same component.

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

STEPS

The issue can be reproduced at will with the following steps:
1. Workforce Administration > Job Information > Contract Administration > Update Contracts, Contract Type/Clauses tab
2. Add Contract Type Value
3. Click Lookup Icon
4. Error Generated



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms