ETL9.1:Process AUDIT_TLRPTTIME Abends with Error "ORA-00936: Missing Expression "

(Doc ID 1336548.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, TL Installation and Setup
Using Archive Manager when the process runs an ORA-00936 error is encountered when deleting data from tl_audit_tlrpttime.

the following error occurs.

ERROR
-----------------------
Processing AUDIT_TLRPTTIME (142,89)

SQL error. Function: SQLExec
Error Position: 157
Return: 936 - ORA-00936: missing expression
Statement: delete from ps_audit_tlrpttime where exists (select 'x' from ps_audit_tlrpt_hst where ps_audit_tlrpt_hst.psarch_id = 'audt_tlr' and psarch_batchnum = 67 and
Original Statement: DELETE FROM PS_AUDIT_TLRPTTIME WHERE EXISTS (SELECT 'X' FROM PS_AUDIT_TLRPT_HST WHERE PS_AUDIT_TLRPT_HST.PSARCH_ID = 'AUDT_TLR' AND PSARCH_BATCHNUM = 67 AND

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Archive Audit_TLRPTTIME data for a month or two into history table AUDIT_TLRPT_HST using Data Archive Manager
2. The process abends with above error

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