ETL9.1:Process AUDIT_TLRPTTIME Abends with Error "ORA-00936: Missing Expression "
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.
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.
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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms