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