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 FEBRUARY 04, 2011

Applies to:

Oracle Clinical - Version: 4.5.1 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

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:


ORA-01722: invalid number ORA-06512: at "RXA_DES.STUDYRELATEDRECORDS", line 606.


  • 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.

Cause

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 hundreds of Community platforms