My Oracle Support Banner

Error When Running Create Workplace Gender Equality Report (HR_WGEA_AUS) On MSS Database (Doc ID 2035990.1)

Last updated on FEBRUARY 03, 2019

Applies to:

PeopleSoft Enterprise HCM Global Payroll Australia - Version 9.2 and later
Information in this document applies to any platform.


When running the Workplace Gender Equality Report (WGEA) on MSS database, it runs into error:

Process 3907676 resumed after step HR_WGEA_AUS.MAIN.Step01 (108,538)

File: e:\pt85312b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Implicit conversion from data type datetime to smallint is not allowed. Use the CONVERT function to run this query.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prep
Failed SQL stmt: UPDATE PS_HRAU_WGWK_TAO4 SET days = ( (end_dt - begin_dt) + 1) WHERE process_instance = 3907676

Process 3907676 ABENDED at Step HR_WGEA_AUS.PrcsGP.Step12 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.