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)

(Doc ID 1599504.1)

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.

Symptoms

 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>&lt;![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

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