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.
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
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