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

Last updated on JUNE 19, 2015

Applies to:

Oracle Argus Safety - Version 8.0 to 8.0 [Release 8.0]
Information in this document applies to any platform.

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

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