When Running HR_TREEBLD, Users Login get Locked to PIA with Company Directory on the Home Page
(Doc ID 2080274.1)
Last updated on FEBRUARY 07, 2019
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')
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document