Unable to link patients positions by range in a study (which contains alpha patient codes defined as alphanumerical), it fails with ORA-01722: invalid number ORA-06512 (Doc ID 1287178.1)

Last updated on JANUARY 28, 2025

Applies to:

Symptoms

When trying to link patients positions by range in a study where there are several alpha patient codes defined as alphanumerical e.g.

• Menu path
• Design
• Patient Positions
• Alpha Patient Codes), it fails with the error:

• Menu path
• Design
• Patients Positions
• Study Site Relations
• Pick a study
• Click on Sites
• Click on Patient Ranges.

After deleting the alpha patient codes mentioned above, the error message was not shown anymore and the window Link Patient Positions by Range in study study_code to Site site_code was correctly displayed.

Changes

Cause

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