Initial Log-In Entry In Oracle Clinical Failing ( The Database Was Cloned) (Doc ID 1296097.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version: 4.5.3 and later   [Release: 4.5.3 and later ]
This problem can occur on any platform.

Symptoms

While attempting to enter data with the INITIAL LOG-IN AND FIRST-PASS ENTRY form, and  after clicking PgDn, then entering more data, and attempting to save then exit, the form indicates that there are pending changes.

ERROR MESSAGES:
FRM-40508: ORACLE error: unable to INSERT record.

You find the following statement in a database trace:

INSERT INTO RECEIVED_DCMS (LOG_IN_TS,DCM_LAYOUT_SN,BLANK_FLAG,RECEIVED_DCM_STATUS_CODE,QUALIFYING_VALUE,LAB,CLIN_PLAN_EVE_NAME,SUBEVENT_NUMBER,VISIT_NUMBER,RECEIVED_DCM_ID,RECEIVED_DCM_ENTRY_TS,RECEIVED_DCI_ID,ACCESSIBLE_TS,SN,END_TS,CLINICAL_STUDY_ID,LAST_STATUS_CHANGE_TS,DCM_ID,DCM_SUBSET_SN,CLIN_PLAN_EVE_ID,ACTUAL_EVENT_ID,DATA_COMMENT_TEXT,LAB_ID,LAB_RANGE_SUBSET_NUM,INVESTIGATOR_ID,INVESTIGATOR,SITE_ID,SITE,PATIENT_POSITION_ID,PATIENT,DATA_LOCK_FLAG,DATA_LOCK_TS,ENTERED_BY,MODIFIED_BY,MODIFICATION_TS,DCM_DATE,DCM_TIME,LAB_ASSIGNMENT_TYPE_CODE,LAB_MODIFICATION_TS,COMMENT_TEXT,DOCUMENT_NUMBER,LAST_DATA_CHANGE_TS,PASS_ONE_TS,PASS_ONE_BY,PASS_TWO_TS,PASS_TWO_BY,LAST_RESPONSE_MODIFICATION_TS,DCI_ID)  
VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48)  
END OF STMT
ERROR #92:err=1 tim=96222062

If

Select received_dcm_seq.nextval From dual <  Select max(received_dcm_id) From RECEIVED_DCMS;

then you have this problem.

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