Defining a new Activity in RDC with the parameter %REVIEW_TYPE% does not return the correct value
(Doc ID 2426362.1)
Last updated on DECEMBER 06, 2019
Applies to:
Oracle Clinical Remote Data Capture Option - Version 5.1.0 to 5.2.0 [Release 5.1 to 5.2.0]Information in this document applies to any platform.
Symptoms
When defining a new Activity in RDC with the parameter %REVIEW_TYPE% using the function:
rdc_zf_stateless_queries.getReviewType(:prod_test_mode, :studyid, :siteid, :maxrows, :role)
The function returns the parameter vRevType, as either a P or T, and not the set default custom review type defined in OC, the Installation Codelist
"CUSTOM REVIEW TYPES". See the insert statements used below.
--------
Insert into RXC.RDC_ACTIVITIES
(ACTIVITY_ID, CREATION_TS, CREATED_BY, USER_ROLE, TEXT,
ACTIVITY_SCOPE, ACTIVITY_TYPE, ACTIVITY_EXEC, TITLE)
Values
(20001, sysdate, 'RXC', 'CRA', 'Set %REVIEW_TYPE% requirement for CRFs',
'RDC_ZF_CRF', 'P', 'RDC_ZF_surround_activity.LoadCRFs(''MARK'')', 'Mark
new CRFs for review');
COMMIT;
Insert into RXC.RDC_ACTIVITY_TAGS
(ACTIVITY_TAG, CREATION_TS, CREATED_BY, FUNCTION_TYPE, FUNCTION_NAME)
Values
('REVIEW_TYPE', sysdate, 'RXC', 'S',
'rdc_zf_stateless_queries.getReviewType(:prod_test_mode, :studyid, :siteid,
:maxrows, :role)');
COMMIT;
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 |