Error: “Unable to Load Data” When Attempting to Approve Timesheets in P6 Web (Doc ID 2271746.1)

Last updated on JUNE 27, 2017

Applies to:

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

Symptoms

When selecting "Approve Timesheets" within P6 (web), the following error occurs:

ERROR
"Unable to load data".

Note: 
The P6 managed server log file includes the following oracle error:
ORA-01460: unimplemented or unreasonable conversion requested ADMUSER.TA_GATHER_MULTI_TIMESHEETS

Steps To Reproduce:
1. Log into P6 web
2. Select the Dashboards drop-down menu > Approve Timesheets
3. Error is displayed

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