My Oracle Support Banner

Error: "PrmRowSet.findColumn: No Such Column: WorkDate" Creating Or Updating Resource hours Using P6 (Doc ID 2402828.1)

Last updated on JUNE 06, 2018

Applies to:

Primavera Web Services - Version 17.12.3.0 and later
Information in this document applies to any platform.

Symptoms

When Creating Or Updating Resource hours Using P6 Web Services

ERROR NO SUCH COLUMN: WORKDATE


The operation CreateResourceHours(ResourceHour[]) works as expected and it is creating the record with any hours / work date / status needed.
The operation UpdateResourceHours(ResourceHour[]) throws an error PrmRowSet.findColumn: No such column: WorkDate.

When there is no resourcehour records, Web Servicescannot create the record via createresourcehour method. However when timesheet is manually created via Team Member, updateresourcehour method can update these records.

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

1. Try to run a script with CreateResourceHours(ResourceHour[] rHs)
2. Notice that it is working fine and it is creating the record with any hours / work date / status needed.
3. Use UpdateResourceHours(ResourceHour[])
4. Notice the error PrmRowSet.findColumn: No such column: WorkDate.

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.