My Oracle Support Banner

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 FEBRUARY 21, 2019

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$sbxxx@:f136afa9282bc53xxxxxxxxxxxxxb47a753d039184c5e] 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

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
References


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