Team Member Delay in Publishing Timesheet Data to PXRPTUSER Views (Doc ID 2078824.1)

Last updated on JANUARY 30, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.5.0 and later
Information in this document applies to any platform.

Symptoms

On : 15.1.5.0 version, P6 Scheduled Services and Pre-R8.x Job Services

ACTUAL BEHAVIOR
---------------
There is a significant delay in PXRPTUSER Views related to Timesheets (RSRCHOUR and TIMESHEET) getting updated, even when the Global Scheduled Services run and complete successfully. The data will eventually show in the reporting views, usually within 24 hours.

Additionally, the following errors are visible in the Team Member log files:


EXPECTED BEHAVIOR
-----------------------
The Timesheet data should be available in the reporting views immediately after publication.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Open a non started (active) timesheet.
  2. Update it by adding hours
  3. Save the timesheet
  4. Running this query, results are immediately displayed
  5. Wait for publication to run and note the difference in the reporting views vs the live tables.


BUSINESS IMPACT
-----------------------
Due to this issue, users reports are returning inconsistent data.

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