Application Engine Process HR_REACTVTER Abended with Error - "ORA-00932: Inconsistent Datatypes: Expected DATE got NUMBER" (Doc ID 1606246.1)

Last updated on DECEMBER 01, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
****CHECK FOR CURRENCY:12/1/2016******

Symptoms


On Run Control page for Application Engine Process HR_REACTVTER, if you leave 'As of Date' field blank, the process abends with the following error-

ERROR
-----------------------
SQL error. ORA-00932: inconsistent datatypes: expected DATE got NUMBER

PSAESRV started service request at 15.34.13 2013-09-19

Job Reactivation/Termination Update process started. (1000,882)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623 Error Position: 553 Return: 932 - ORA-00932: inconsistent datatypes: expected DATE got NUMBER
Failed SQL stmt: INSERT INTO PS_TAS_JOB_TAO4 ( PROCESS_INSTANCE ,EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,DUTIES_TYPE ,ASSIGNMENT_ID ,EXPECTED_END_DATE ,AUTO_END_FLG) SELECT 2956 ,JR.EMPLID ,JR.EMPL_RCD ,JR.EFFDT ,JR.EFFSEQ ,JR.DUTIES_TYPE ,JR.ASSIGNMENT_ID ,JOB.EXPECTED_END_DATE ,JOB.AUTO_END_FLG FROM PS_JOB_JR JR , PS_JOB JOB WHERE JOB.COMPANY = '000' AND JOB.EXPECTED_END_DATE IS NOT NULL AND JOB.EXPECTED_END_DATE
Process 2956 ABENDED at Step HR_REACTVTER.PROCESS.Step01 (SQL) -- RC = 932 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 15.34.13 2013-09-19


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Navigation: Main Menu -- Workforce Administration -- Job Information -- Temporary Assignments -- Reactivate/Update Termination

1. Add a New run control
2. Select Company as 000
3. Leave As of Date field blank
4. Click on Run button and select HR_REACTVTER process to run

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