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)
(Doc ID 2272940.1)
Last updated on NOVEMBER 13, 2019
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
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:
ERROR
-----------------------
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,
FILL.FACTOR_MULT, FILL.TL_CHT_GROUP_DESCR
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
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Manager Self Service->Time Management-> Time and Labor Dashboard (Payable Time Pagelet)
BUSINESS IMPACT
-----------------------
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)
Cause
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
Symptoms |
Cause |
Solution |