ETL9.2: Time And Labor Rule Recompile Error After PUM Upgrade (Doc ID 2172707.1)

Last updated on OCTOBER 26, 2016

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

Customer is upgrading from PUM8 to PUM18.

At the completion of Change Assistant, a manual step exists for a full "Time
and Labor Rules Recompile".  When performing this recompile, receiving an INSTR error.

Customer is on Microsoft SQL Database.

Error is as follows:
File: e:\pt85504c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:
1723 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 11 for SQL
Server][SQL Server]An expression of non-boolean type specified in a context
where a condition is expected, near ','.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]'INSTR' is not a
recognized built-in function na
Failed SQL stmt: UPDATE PSAESTMTDEFN SET AE_REUSE_STMT = 'N' WHERE
(AE_APPLID,AE_SECTION,SQLID) IN ( SELECT AE.AE_APPLID , AE.AE_SECTION
,AE.SQLID FROM PSAESTMTDEFN AE , PSSQLTEXTDEFN S WHERE S.SQLID = AE.SQLID AND
S.EFFDT = ( SELECT MAX(EFFDT) FROM PSSQLTEXTDEFN WHERE SQLID = S.SQLID AND
SQLTYPE = S.SQLTYPE AND MARKET = S.MARKET AND DBTYPE = S.DBTYPE AND EFFDT <=
{ fn CURDATE() } ) AND ( INSTR(UPPER(SUBSTR( S.SQLTEXT, 1,
INSTR(UPPER(S.SQLTEXT),'FROM' ))),'%INSERTSELECT') > 0 OR INSTR(UPPER(SUBSTR(
S.SQLTEXT, 1, INSTR(UPPER(S.SQLTEXT),'FROM' ))),'INSERT INTO') > 0 ) AND
INSTR(UPPER(SUBSTR( S.SQLTEXT, 1, INSTR(UPPER(S.SQLTEXT),'FROM' ))),'BIND' )
> 0 AND S.SQLID LIKE 'TL_TA_RULES%' AND AE.AE_REUSE_STMT = 'Y' ) AND 1 = 2

Process 225688 ABENDED at Step TL_RCMP_RULE.REUSESTM.Step01 (SQL) -- RC =
8601 (108,524)

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

 

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