HR_TREEBLD Error - ORA-00907: Missing Right Parenthesis (Doc ID 1911031.1)

Last updated on DECEMBER 28, 2015

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


STEPS TO REPLICATE
Setup HRMS >> Common Definition >> Org Chart >> Job Tree Builder.

ERROR MESSAGE
File: E:\pt85211b-retail\peopletools\src\pssys\tdmupd.cppSQL error. Stmt #: 3098 Error Position: 384 Return: 907 - ORA-00907: missing right parenthesis
Failed SQL stmt:UPDATE PSTREEDEFN SET VERSION = :1, VALID_TREE = 'N' WHERE SETID = :2 AND SETCNTRLVALUE = :3 AND EFFDT >= TO_DATE(:4,'YYYY-MM-DD') AND TREE_STRCT_ID IN (SELECT TREE_STRCT_ID FROM PSTREESTRCT WHERE DTL_TREE_NAME = :5 AND DTL_TREE_LEVEL_NUM IN(2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,448484??=??????=?=??))


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