ETL9.2:TL_TIMEADMIN abends with error ORA-00911: invalid character Failed SQL stmt: UPDATE PS_TL_IPT14 SET TL_RULE_ID = %RuleTemplate(), TRC = %RuleTemplate()

(Doc ID 1626917.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

On : 9.2 version, Time Administration

TL_TIMEADMIN Going into No Success in 9.2 Demo Environment


ERROR
-----------------------
ORA-00911: invalid character Failed SQL stmt: UPDATE PS_TL_IPT14 SET TL_RULE_ID = %RuleTemplate(), TRC = %RuleTemplate()

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Create a new rule with sql object TMPL000_SU01
actions: TMPLT_13_A01, TMPLT_13_A02

2. Attach this rule to a rule program
3. Attach the rule program to a workgroup
4. Run TA for an employee in that workgroup
5. The process abends with above error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process rules created using delivered objects.

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