Defining a new Activity in RDC with the parameter %REVIEW_TYPE% does not return the correct value (Doc ID 2426362.1)

Last updated on MARCH 08, 2021

Applies to:

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

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