My Oracle Support Banner

E-QR/E-PRCS PSQUERY To XLS Missing Decimal Value When Run On Windows Process Scheduler (Doc ID 2874431.1)

Last updated on AUGUST 11, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Generic Windows


On : 8.59 version, Query

When Scheduling a Query to run on a Windows Platform Process Scheduler, the decimal values are removed, for example a value of 24.62 will get changed to 24.00

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

1) Log into PIA

2) Navigate to Reporting Tools > Query > Schedule Query

3) Run the desired query

4) Select the Windows Process Scheduler (PSNT)

5) Observe that the numeric output has the decimal point removed.


This issue is observed when an Upgrade, Migration or an Update/Change of the Operating System is performed that hosts the Process Scheduler. 

Another Cause can be the change of the user running the Process Scheduler Services


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

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