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:
Oracle Life Sciences 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
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 |
Cause |
Solution |
References |