Receiving A SQL Error When Trying To Add An Organizational Instance: "ORA-01722: invalid number"
(Doc ID 2999646.1)
Last updated on APRIL 18, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
The following error message is triggered when trying to add new organizational relationship for employee type POI:
Error Message:
Error Position: 61
Return: 1722 - ORA-01722: invalid number
Statement: select 'x' from ps_hcr_job_stg where emplid=:1 and empl_rcd=:2
Original Statement: select 'x' from ps_hcr_job_stg where emplid=:1 and empl_rcd=:2
Steps to reproduce the issue:
1. Go to Dashboard - Workforce Administrator > Manage Human Resources tile > Organizational Relationship
2. Search for an employee with POI type.
3. Select Hire, and press Add Organizational Relationship.
Notice the above error message is displayed.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |