My Oracle Support Banner

Case Bookin Error In Argus Safety Production (Doc ID 2413196.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.0.1 to 8.0.1 [Release 8.0]
Microsoft Windows x64 (64-bit)

Symptoms

Users see the error "Please contact system administrator" while book-in a new case.

Following error is observed in Argus Utilities -> Error log ->

Argus Safety.COM :- Oracle error -1 occurred.ORA-30554: function-based index ARGUS_APP.FBI_CSPI_RAND_NUM is disabledORA-06512: at "ARGUS_APP.GSS_CASE", line 6397ORA-06512: at line 1SQL: BEGIN GSS_CASE.P_CASE_PAT_INFO_IU(:PI_CASE_ID, :PI_PAT_ID, :PI_PAT_SUBJ_NUM, :PI_PAT_INITIALS, :PI_PAT_FIRSTNAME, :PI_PAT_MI, :PI_PAT_LASTNAME, :PI_PAT_ADDRESS, :PI_PAT_CITY, :PI_PAT_STATE, :PI_PAT_POSTAL_CODE, :PI_PAT_COUNTRY_ID, :PI_PAT_DOB, :PI_PAT_DOB_RES, :PI_PAT_AGE, :PI_AGE_UNIT_ID, :PI_AGE_GROUP_ID, :PI_GENDER_ID, :PI_PAT_WEIGHT_LBS, :PI_PAT_WEIGHT_KG, :PI_PAT_HEIGHT_IN, :PI_PAT_HEIGHT_CM, :PI_ETHNICITY_ID, :PI_OCCUPATION_ID, :PI_PAT_STAT_PREG, :PI_NOTES, :PI_PAT_DOB_PARTIAL, :PI_RAND_NUM, :PI_CONFIDENTIAL, :PI_NUMBER_OF_PATIENTS, :PI_UD_TEXT_1, :PI_UD_TEXT_2, :PI_UD_TEXT_3, :PI_UD_TEXT_4, :PI_UD_TEXT_5, :PI_UD_TEXT_6, :PI_UD_TEXT_7, :PI_UD_TEXT_8, :PI_UD_TEXT_9, :PI_UD_DATE_1, :PI_UD_DATE_2, :PI_UD_DATE_3, :PI_UD_DATE_4, :PI_UD_DATE_5, :PI_UD_DATE_6, :PI_UD_DATE_7, :PI_UD_DATE_8, :PI_UD_DATE_9, :PI_UD_NUMBER_1, :PI_UD_NUMBER_2, :PI_UD_NUMBER_3, :PI_UD_NUMBER_4, :PI_UD_NUMBER_5, :PI_UD_NUMBER_6, :PI_UD_NUMBER_7, :PI_UD_NUMBER_8, :PI_UD_NUMBER_9, :PI_UD_TEXT_10, :PI_UD_TEXT_11, :PI_UD_TEXT_12, :PI_UD_DATE_10, :PI_UD_DATE_11, :PI_UD_DATE_12, :PI_UD_NUMBER_10, :PI_UD_NUMBER_11, :PI_UD_NUMBER_12, :PI_CHILD_ONLY, :PI_PAT_PHONE, :PI_PAT_BMI, :PI_PAT_BODY_AREA, :PI_AGE_UNIT_ID_AT_VACC, :PI_PAT_AGE_AT_VACC, :PI_NOTES_J, :PI_PAT_ADDRESS_J, :PI_PAT_CITY_J, :PI_PAT_FIRSTNAME_J, :PI_PAT_LASTNAME_J, :PI_PAT_MI_J, :PI_PAT_STATE_J, :PI_UD_TEXT_1_J, :PI_UD_TEXT_2_J, :PI_UD_TEXT_3_J, :PI_UD_TEXT_4_J, :PI_UD_TEXT_5_J, :PI_UD_TEXT_6_J, :PI_UD_TEXT_7_J, :PI_UD_TEXT_8_J, :PI_UD_TEXT_9_J, :PI_UD_TEXT_10_J, :PI_UD_TEXT_11_J, :PI_UD_TEXT_12_J, :PI_CONCOM_THERAPY); END;

 

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


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