ETL9.2: ORA-00936: Missing Expression when processing cloned rule in TimeAdmin.
(Doc ID 3057739.1)
Last updated on NOVEMBER 12, 2024
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When attempting to run TimeAdmin,
the following error occurs.
ERROR
-----------------------
.(TL_TA_RULES.WYEXTST2.Step03) (SQL)
INSERT INTO PS_TL_IPT1_TMP4 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, DUR,
SEQ_NBR, PERIOD_INSTANCE, PUNCH_TYPE, PUNCH_DTTM) SELECT I.PROCESS_INSTANCE,
I.EMPLID, I.EMPL_RCD, I.DUR, I.SEQ_NBR, I.PERIOD_INSTANCE, I.PUNCH_TYPE,
I.PUNCH_BEGIN FROM PS_TL_IPT14 I WHERE I.PROCESS_INSTANCE = 319157 AND I.TRC
IN () AND I.PUNCH_TYPE IN ()
/
-- Row(s) affected: 0
-- 08:39:16.847 Process 319157 ABENDED at Step TL_TA_RULES.WYEXTST2.Step03 (Action SQL) -- RC = 936
ROLLBACK
/
-- 08:39:16.860 SQL Error: ORA-00936: missing expression
STEPS
-----------------------
1. Clone the existing rule without changing anything.
2. Replace old rule and add a new rule
3. Run TimeAdmin process which is abending on the rule at Step TL_TA_RULES.Step03 (Action SQL) -- RC = 936
SQL Error: ORA-00936: missing expression
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |