CTPR Report Generation is Failing when Study Drug is Included in the Selected Groupings under Groupings tab (Doc ID 2022552.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

Clinical Trial Periodic Reports Generation is failing when Study Drug is included in the Selected Groupings under Groupings tab of the CTPR report

Steps to Repeat:
1. Configure a CTPR Report
2. Add Study ID, Study Drug, Patient Subject # and Study Center ID in the line listing tab
3. Add Case Report Type, Study Drug, Product Name and Initial /Follow-up fields to the Selected Groupings under groupings tab.
4. Save the Configuration
5. Run the report as Draft
6. Go to Background Periodic Reports Status screen and observe that report fails with an error
7. The following error is written in the error log:

Argus Safety.COM :- Oracle error 8197 occurred.SQL execution error, ORA-20004: ORA-00907: missing right parenthesisORA-06512: at "DLP_APP.GSS_PERIODIC", line 6346ORA-06512: at line 1SQL: BEGIN GSS_PERIODIC.P_MAIN_LINE_LISTING(:PI_REG_REPORT_ID, :PI_USER_ID, :PI_ISPSUR, :PI_LICENSE_CONFIG, :PI_REPORT_FORM_ID, :PI_PRIMARY_EVENT, :PI_RE_ENCODE, :PI_PREF_TERM, :PI_PRINT_TERM_ONLY, :PI_DIAGNOSIS_CTPR, :PI_DIAGNOSIS_SYSTEM, :PI_CM_SOURCE_DATE, :PI_GP_LISTED_SWITCH, :PI_GP_SERIOUS_SWITCH,:PI_FROM_DATE,:PI_TO_DATE,:PI_USE_SAFETY_DATE,:PI_BLINDED, :PO_MAIN_LINE_LISTING, :PO_GROUP_LISTING); END;

Cause

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