500301001 Error when Auto Schedule
(Doc ID 1262024.1)
Last updated on APRIL 22, 2021
Applies to:Oracle Argus Safety - Version 6.0 and later
Oracle Argus Safety Japan - Version 6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Aug-2014***
The following error message appears when user clicks the [Auto Schedule] button at Case Form >> Regulatory Reports tab.
This occurs for both 'ARGUS J USER' UserType users with JAPAN agency and 'ARGUS USER' UserType users with UNITED STATES agency.
On Japanese screen for ARGUS J USER type user:
On English screen for ARGUS USER type user:
STEPS TO REPRODUCE:
1) Create an Advanced Condition with an SQL statement.
2) Create an Expedited Report Rule and set the created Advanced Condition to the Expedited Report Rule.
3) Create a Case with a product which matches with the created Expedited Report Rule.
4) Go to Case Form >> Regulatory Reports tab and click the Auto Schedule button.
SAMPLE SQL FOR Advanced Condition
The following SQL statements are only example to show the statement structure that occurs this symptom. The real SQL statements are much more longer and complex than the below. Users create such long and complex SQL statements and set up for Products and Licenses, Advanced Conditions, and Expedited Report Rules with hours works, then encounters this error at Auto Scheduling in Case Form.
Structure example #1:
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