SQL ERROR WHEN LOADING DIRECT REPORTS IN FLUID PERSON SELECT PAGE
(Doc ID 2379698.1)
Last updated on NOVEMBER 23, 2019
Applies to:PeopleSoft Enterprise HCM Absence Management - Version 9.2 and later
Information in this document applies to any platform.
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.
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
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