When Running HR_TREEBLD, Users Login get Locked to PIA with Company Directory on the Home Page
Last updated on JULY 24, 2017
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
HCM 9.2 with PT 8.54.03: when the HR_TREEBLD process ran, no one can login to PIA. For current users who logged into PIA, they can't navigate to other pages, the whole system gets locked.
a non-numeric character was found where a numeric was expected
Failed SQL stmt:
SELECT SETID , SETCNTRLVALUE , TREE_NAME , EFFDT FROM PSTREEDEFN
WHERE SETID = ' ' AND SETCNTRLVALUE = ' ' AND
TREE_NAME = 'COMPANY_DIRECTORY'
AND EFFDT < TO_DATE(TO_DATE('2015-06-12','YYYY-MM-DD'),'YYYY-MM-DD')
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