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 18.8.22.0 [Release 18.8]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 to 18.8.22.0 [Release 18.8]
Information in this document applies to any platform.

Symptoms

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)
SumPendingHourCount,sum(rsrchour.pend_ot_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
('TS_Review','TS_ReSubmit','TS_ReviewRM','TS_ReSubmitRM','TS_PMApprov','TS_Rev
iewRM','TS_ReSubmitRM') AND rsrchour.task_ts_flag = 'N' group by
rsrchour.rsrc_id,rsrchour.ts_id,rsrchour.proj_id

Changes

 

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.