When Running HR_TREEBLD, Users Login get Locked to PIA with Company Directory on the Home Page (Doc ID 2080274.1)

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.

Symptoms

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.


Error Message:

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')

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