ETL9.2:Error When Using Group Approval In Time And Labor. (Doc ID 2111707.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

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

Symptoms

DESCRIPTION
===========
ETL9.2:After PUM 13 on SQL Server Payable Time Cannot be Approved From

Summary Page and below sql error is encountered:
wset.Fill Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]
Executing SQL directly; no cursor.[Microsoft][SQL Server Native Client 10.0][SQL Server]An expression
of non-boolean type specified in a context where a condition is expected, near ','.[Microsoft][S
Statement: SELECT FILL.EMPLID,FILL.EMPL_RCD,(CONVERT(CHAR(10),FILL.DUR,121)),FILL.SEQ_NBR,FILL.OPRID,
FILL.EOAWSTEP_STATUS,FILL.EOAWDEFN_ID,FILL.EOAWTHREAD_STATUS,FILL.TRANSACTIONID,FILL.EOAWORIG_OPRID FROM
 PS_TL_APP_PAY_M_VW FILL WHERE (EMPLID, EMPL_RCD) IN (SELECT EMPLID, EMPL_RCD FROM PS_TL_RUN_CTRL_GRP WHERE
 RUN_CNTL_ID = :1) AND DUR BETWEEN :2 AND :3 ORDER BY EMPLID, EMPL_RCD, TRANSACTIONID, EOAWDEFN_ID Original
Statement: %SelectAll(:4 FILL) WHERE (EMPLID, EMPL_RCD) IN (SELECT EMPLID, EMPL_RCD FROM PS_TL_RUN_CTRL_GRP
WHERE RUN_CNTL_ID = :1) AND DUR BETWEEN %DATEIN(:2) AND %DATEIN(:3) ORDER BY EMPLID, EMPL_RCD, TRANSACTIONID,
EOAWDEFN_ID ErrorReturn-> 125 - Fatal SQL error occurred. (2,125) FUNCLIB_TL_CP.APPROVAL_BTN.FieldFormula
 Name:ApprPayableSummary PCPC:13635 Statement:175 Called from:FUNCLIB_TL_CP.APPROVAL_BTN.FieldFormula
Name:PayableSummaryPostSave Statement:588 Called from:TL_SRCH_APPRV_GRP.GBL.SavePostChange Statement:53

REPLICATION STEPS
=================

1) Awe approvals are used.
2) Employee submits time and TA is run to create payable time.
3) Manager goes to approve time from payable time summary and below error is
encountered and payable time does not get approved time
4) Payable time approved fine from detail page though


Summary Page and below sql error is encountered:
wset.Fill Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]
Executing SQL directly; no cursor.[Microsoft][SQL Server Native Client 10.0][SQL Server]An expression
of non-boolean type specified in a context where a condition is expected, near ','.[Microsoft][S
Statement: SELECT FILL.EMPLID,FILL.EMPL_RCD,(CONVERT(CHAR(10),FILL.DUR,121)),FILL.SEQ_NBR,FILL.OPRID,
FILL.EOAWSTEP_STATUS,FILL.EOAWDEFN_ID,FILL.EOAWTHREAD_STATUS,FILL.TRANSACTIONID,FILL.EOAWORIG_OPRID FROM
 PS_TL_APP_PAY_M_VW FILL WHERE (EMPLID, EMPL_RCD) IN (SELECT EMPLID, EMPL_RCD FROM PS_TL_RUN_CTRL_GRP WHERE
 RUN_CNTL_ID = :1) AND DUR BETWEEN :2 AND :3 ORDER BY EMPLID, EMPL_RCD, TRANSACTIONID, EOAWDEFN_ID Original
Statement: %SelectAll(:4 FILL) WHERE (EMPLID, EMPL_RCD) IN (SELECT EMPLID, EMPL_RCD FROM PS_TL_RUN_CTRL_GRP
WHERE RUN_CNTL_ID = :1) AND DUR BETWEEN %DATEIN(:2) AND %DATEIN(:3) ORDER BY EMPLID, EMPL_RCD, TRANSACTIONID,
EOAWDEFN_ID ErrorReturn-> 125 - Fatal SQL error occurred. (2,125) FUNCLIB_TL_CP.APPROVAL_BTN.FieldFormula
 Name:ApprPayableSummary PCPC:13635 Statement:175 Called from:FUNCLIB_TL_CP.APPROVAL_BTN.FieldFormula
Name:PayableSummaryPostSave Statement:588 Called from:TL_SRCH_APPRV_GRP.GBL.SavePostChange Statement:53

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