EEX 9.1/9.2: FS_PEACCRL Process Abends At Step EX_PE_ACCRL.ExpSel.Step02 (SQL) With Invalid Syntax Error (Doc ID 2143348.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

FS_PEACCRL process fails at step EX_PE_ACCRL.ExpSel.Step02 (SQL) with Invalid Syntax error 

Steps:
The issue can be reproduced at will with the following steps:
1. Setup Period End Accrual Options for 5-6 SetID with multiple conditions in for each one.
2. Make sure the record EX_ACRL_FLDS_VW is returning more than 40 rows for a SetID.
3. Now run the Period End Accruals for the Business Unit for which same SetID is mapped for record group FS_67 in table set control.

Error:
FS_PEACCR Process fails at the step EX_PE_ACCRL.ExpSel.Step02 (SQL) due to the table EX_ACRL_FLDS_VW.

Here is the error details:
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1620 Error Position: 21 Return: 80 12 - Invalid syntax in SQL statement Failed SQL stmt:UPDATE PS_EX_SHEET_HDR SET PROCESS_FLAG = 'Y', PROCESS_INSTANCE = 5560191 WHERE PROC ESS_FLAG = 'N' AND POST_STATUS_EX = 'N' AND SHEET_STATUS IN ('SUB','PAR','HDU','HDA','SUB','PAR','H DU','HDA','SUB','PAR','HDU','HDA','SUB','PAR','HDU','HDA','SUB','PAR','HDU','HDA','SUB','PAR','HDU', 'HDA','SUB','PAR','HDU','HDA','SUB','PAR','HDU','HDA','SUB','PAR','HDU','HDA','SUB','PAR','HDU AND E XISTS ( SELECT 'X' FROM PS_PE_ACCRL_RQST X , PS_PE_BUDTL_TMP5 X1 , PS_EX_EE_ORG_DTL X2 , PS_BUS_UNIT _TBL_EX X3 WHERE X.OPRID = %OperatorId AND X.RUN_CNTL_ID = 'PROV_T&E' AND X1.PROCESS_INSTANCE = 5560 191 AND PS_EX_SHEET_HDR.EMPLID = X2.EMPLID AND X2.DFLT_EE_PROF_FLG = 'Y' AND X1.BUSINESS_UNIT = 'CRI

Changes

 

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