My Oracle Support Banner

Reports Are Not Scheduling For Study Cases (Doc ID 2654596.1)

Last updated on JANUARY 07, 2025

Applies to:

Oracle Life Sciences Argus Safety - Version 8.1.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

Reports were not getting scheduled for Study cases. Even on clicking on the Auto-schedule button manually, the reports were not scheduled.

Steps to reproduce:

Code Lists > Reporting Destination > FDA
Verify that under Agency Information tab the "Allow WHO Drug reporting" checkbox is checked

Business Configurations > Studies > Select the Study
In Study Reporting section, add Country and License Type.
Reporting Destination: FDA (From Above)

a. Create new Study Case
b. Enter appropriate information to allow for Auto Schedule
c. Save the case
d. Go to Regulatory Reports tab and hit "Auto Schedule" button
e. The reports didn't schedule as expected.
f. Go to Utilities > Logs > View Error Log screen. Following error was captured -

"Argus Safety.COM :- Oracle error 1 occurred.ORA-00907: missing right parenthesisSQL: select * from (SELECT DISTINCT 0 susar, lm_license.country_id, cfg_reg_report_rules.reg_rpt_rules_id, cfg_reg_report_rules.agency_id, cfg_reg_report_rules.timeframe timeframe, ...
..
..PL/SQL Call Stack: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG1 __anonymous_block"

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


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