Time Period labels on the Timesheet period browse portlet displaying only Hyphen

Products

• Clarity PPM On Premise

Issue/Introduction

After migrating the Clarity database to Oracle 19c or in a scenario where clarity was upgrade from 15.9.1 to 16.0.1, the Investment Timesheet Summary portlet is not displaying the complete time period lookup values.
The filter result only displays the hyphens, instead of the full time period.

When reviewing the lookup 'Portlet Timesheet Period Browse', the same results occur.

Expected:

Actual:

Environment

16.0.1

Resolution

1. Make sure the original NSQL for the lookup(Portlet Timesheet Period Browse) is:

SELECT @SELECT:TP.PRID:PRID@,
       @SELECT:TP.PRUID:UNIQUE_CODE@,
       @SELECT:TP.PRSTART:PRSTART@,
       @SELECT:TP.PRFINISH-1:PRFINISH@,
       @SELECT:SUBSTR(TP.PRSTART,1,INSTR(TP.PRSTART,' ')-1) || ' - ' || SUBSTR((TP.PRFINISH-1),1,INSTR((TP.PRFINISH-1),' ')-1):TIMEPERIOD@
FROM   PRTIMEPERIOD TP
WHERE  TP.PRISOPEN = 1
AND   (@WHERE:PARAM:USER_DEF:DATE:START_DATE@ IS NULL OR TP.PRSTART >= @WHERE:PARAM:USER_DEF:DATE:START_DATE@)
AND   (@WHERE:PARAM:USER_DEF:DATE:END_DATE@ IS NULL OR TP.PRFINISH <= @WHERE:PARAM:USER_DEF:DATE:END_DATE@)
AND    @FILTER@

2. Check if the NLS_DATE_FORMAT is in: YYYY-MM-DD HH24:MI:SS as per the documentation. If not, please have the DBA change the instance parameter.