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.
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;
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