My Oracle Support Banner

Timesheet Approval Takes Too Long to Load and Becomes Unresponsive (Doc ID 2709453.1)

Last updated on SEPTEMBER 29, 2021

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8 to [Release 18.8]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 to [Release 18.8]
Information in this document applies to any platform.


The Timesheet Approval page hangs when loading, and the following long running query is seen in the tracer log:

SELECT rsrchour.rsrc_id
ResourceId,rsrchour.ts_id TimeSheetId,sum(rsrchour.pend_hr_cnt)
SumPendingOverTimeHourCount,rsrchour.proj_id ProjectId FROM
rsrchour,timesht,upklist WHERE rsrchour.ts_id=timesht.ts_id and
rsrchour.rsrc_id=timesht.rsrc_id AND rsrchour.rsrc_id = upklist.pk_id AND
rsrchour.ts_id = upklist.pk2_id AND upklist.session_id = xxxxx AND
upklist.context_id = xxxxxx AND timesht.status_code IN
iewRM','TS_ReSubmitRM') AND rsrchour.task_ts_flag = 'N' group by




To view full details, 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 a vibrant support community of peers and Oracle experts.