My Oracle Support Banner

Receiving A SQL Error When Trying To Add An Organizational Instance: "ORA-01722: invalid number" (Doc ID 2999646.1)

Last updated on JANUARY 29, 2024

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


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.




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.