500301001 Error when Auto Schedule (Doc ID 1262024.1)

Last updated on APRIL 02, 2016

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***

Symptoms

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.


ERROR MESSAGE:
==============
On Japanese screen for ARGUS J USER type user:
-------------------------------------------------------------------
エラー番号: 500301001 詳細: Advanced condition "<ac-name>" error for <country> domestic for report E2B SQL: There was an error scheduling report for Advanced Condition ID - <ac-id>
-------------------------------------------------------------------

On English screen for ARGUS USER type user:
-------------------------------------------------------------------
Error No: 500301001 Description: Advanced condition "<ac-name>" error for <country> domestic for report E2B SQL: There was an error scheduling report for Advanced Condition ID - <ac-id>
-------------------------------------------------------------------


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:
---------------------
select DISTINCT AAA.CASE_ID from ( select CASE_ID, CASE_NUM from CASE_MASTER ) AAA where AAA.CASE_ID > <case_id>

Structure example #2:
---------------------
select DISTINCT AAA.CASE_ID from ( select * from CASE_EVENT_ASSESS BBB where BBB.LICENSE_ID > <lic_id> ) AAA

 

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