ETL9.2: Receive SQL Error When Loading Time And Labor Dashboard: NULL IS NOT VALID IN THE CONTEXT WHERE IT IS USED (Payable Time pagelet)
Last updated on JUNE 01, 2017
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On: 9.2 version, Technical
Receive SQL Error when loading Time and Labor Dashboard
When loading the Time and Labor Dashboard in our DEMO environment we are getting the message a SQL error has occurred. Our DBA checked the error logs and found the following sql:
DSNT408I SQLCODE = -206, ERROR: NULL IS NOT VALID IN THE CONTEXT WHERE
IT IS USED
SELECT FILL.EMPLID, FILL.EMPL_RCD, FILL.DUR, FILL.TASKGROUP, FILL.
TL_QUANTITY, FILL.EST_GROSS, FILL.LBR_DIST_AMT, FILL.
DILUTED_GROSS, FILL.CURRENCY_CD, FILL.PAYABLE_STATUS, FILL.
PROJECT_ID, FILL.TRC, FILL.TRC_SUM_CATEGORY, FILL.TRC_TYPE,
FROM PS_TL_DSH_PTTRC_VW FILL
Where EMPLID = ?
and EMPL_RCD = ?
and DUR between NULL and NULL
and TRC_TYPE = 'H'
order by EMPLID, EMPL_RCD, DUR
FOR FETCH ONLY
The issue can be reproduced at will with the following steps:
Manager Self Service->Time Management-> Time and Labor Dashboard (Payable Time Pagelet)
The issue has the following business impact:
Due to this issue, users cannot navigate to the dashboard without receiving a SQL error and can not view the date under (Payable Time Dashboard)
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