Access Synchronization Fails (Doc ID 2057273.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Application Access Controls Governor - Version 8.6.5 to 8.6.5 [Release 8]
Information in this document applies to any platform.

Symptoms

On : 8.6.5.6050 version, Application Access Controls Governor 

When attempting to run any report or even Access Synchronization.

Role Assignment Report
Intra-Role Violations by Control Report
Access Violations By User Report

ERROR
-----------------------
 ERROR [AGScheduler_Worker-1] AbstractJob:288 SCHDR Error starting job
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar [SELECT GRC_INC_CTRL_V1440005786021.PERSPECTIVE_ITEM_IDS,
GRC_INC_CTRL_V1440005786021.TYPE, GRC_INC_CTRL_V1440005786021.ID,
GRC_INC_CTRL_V1440005786021.STATE_CODE,
GRC_INC_CTRL_V1440005786021.GRCC_CONTROL_ID,
GRC_INC_CTRL_V1440005786021.STATUS FROM GRC_INC_CTRL_V1440005786021 WHERE (
 ( GRC_INC_CTRL_V1440005786021.priority BETWEEN 5 AND
GRC_INC_CTRL_V1440005786021.type = 173) AND (
GRC_INC_CTRL_V1440005786021.PERSPECTIVE_ITEM_IDS IS NULL ) ) ]; nested
exception is java.sql.SQLSyntaxErrorException: ORA-00907: missing right
parenthesis

Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right
parenthesis

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Access Synchronization
2. From Report Management run some of the reports.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run reports.

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