Unable to add an unplanned page for CRF X when an unplanned page already exists for CRF Y with subevent number = 99 (in the same visit)
Last updated on NOVEMBER 26, 2013
Applies to:Oracle Clinical Remote Data Capture Option - Version 4.6.0 and later
Information in this document applies to any platform.
Unable to add an unplanned page ( via [Add Visit Page] ) for CRF X when an unplanned page already exists for CRF Y with subevent number = 99 (in the same visit) ie
The following error will also appear in the log.xml file :
<MSG_TEXT><![CDATA[[ops$sbains@:f136afa9282bc53198fd4cb2fb6c9b0b331598f50864ecfb47a753d039184c5e] Error in CRF Selection!
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select subevent_number from table(rdc_zf_surround.getVisitSubeventNumbers(:dci_id, :cli_plan_eveId, :patient_position_id, :clinical_study_id,:add_page_type))
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at "RXC.RDC_DAAPI_CASEBOOK", line 57
ORA-06512: at "RXC.RDC_ZF_SURROUND", line 8
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms