My Oracle Support Banner

SQL ERROR WHEN LOADING DIRECT REPORTS IN FLUID PERSON SELECT PAGE (Doc ID 2379698.1)

Last updated on MARCH 28, 2018

Applies to:

PeopleSoft Enterprise HCM Absence Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

STATEMENT:
========
SQL Error when using the delegated access
we have upgraded from 9.2.18 Image (PT 8.54.24) to 9.2.22 (8.55.19).

STEPS TO REPLICATE:
==============
The issue can be reproduced at will with the following steps:
- Login as Proxy Manager
- Navigate to Manager Self Service > Time Management > View Time > Absence request History
- Click on drop down from search Options
- Select 'Proxy for XXXXX'
- Two SQL errors appears.

ERROR:
=====
1. A SQL error occurred. Please consult your system log for details
2. A fatal PeopleCode SQL error occurred. Please consult your system log for details.

Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0]Numeric value out of range (SQLSTATE 22003) 0
Statement: SELECT FILL.SUPERVISOR_ID,FILL.SUPERVISOR_ERN,FILL.EMPLID,FILL.EMPL_RCD,FILL.INDR_COUNT,FILL.DR_COUNT FROM PS_HR_DRTOTCNT5_VW FILL WHERE SUPERVISOR_ID = :1 AND SUPERVISOR_ERN = :2 Original Statement: %SelectAll(:3 FILL) where supervisor_id = :1 and supervisor_ern = :2

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.