GRC 8.6.4.8: Error "AACG ERROR" is Displayed While Initiating Conflict Analysis (Doc ID 2030271.1)

Last updated on AUGUST 11, 2015

Applies to:

Oracle Application Access Controls Governor - Version 8.6 and later
Information in this document applies to any platform.

Symptoms

On :  Application Access Controls Governor (AACG) version 8.6.4.8 :
AACG is used to report segregation of duties(SOD) in the business applications. The User Prevention functionality is not working as intended, when trying to submit Conflict Analysis the following error occurs in the EBS environment. Only few of the users are impacted by this issue.


ERROR
-----------------------
'AACG ERROR'.

Trace Error:

OracleInternalDBConnection: Creating a connection
Creating a connection
INFO: OEBSProvisioningDao:respIdString=51144
INFO: OEBSProvisioningDao:respAppIdString=401
INFO: OEBSProvisioningDao:Got no rows!
INFO: Size of the langMap = 0
INFO: UserRoleAssignment:exiting getRole with role=[RoleId=null;RoleKey=null;RoleName=null;StartDate=null;EndDate=null;Names by language={}
INFO: With Lang: role.getNamesByLang() is null
INFO: userAccessEndDates
INFO: mGlobalUser.getName() = ORA0087
INFO: remoCommasName = ORA0087
INFO: userValues = 3274,jha-ppg,com, ,unknown - ORA0087,ORA0087
INFO: PEAUserProvisioningRequestWSClient:query params=authtoken=842c940dze05fz4146z9c06zb6f55610a880&requesttype=USER_PROVISIONING&userkeys=origuserid%2Cemail%2Cfirstname%2Clastname%2Cname&uservalues=3274%2Cjha-ppg%2Ccom%2C+%2Cunknown+-+ORA0087%2CORA0087&userstartdate=06%2F18%2F2015&userenddate=null&accessorigids=51605-101%2C51606-101%2C51596-200%2C51610-200%2C51594-201%2C51608-201%2C51590-222%2C51603-222%2C51600-283%2C51595-401%2C51609-401%2C51602-552%2C51599-555%2C51591-660%2C51598-661%2C51597-13015%2C51611-13015%2C51604-660%2C51144-401&accessnames=null%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull&accesskeys=null%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull&accessstartdates=null%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull&accessenddates=null%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull&accesstypeids=2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2%2C2&accessdatasourceids=61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61%2C61&useraccessstartdates=06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F18%2F2015%2C06%2F23%2F2015&useraccessenddates=null%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull&justifications=+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+%2C+
INFO: PEAWebServiceClient:sendRequest(UserProvisioningRequest)
INFO: openURLConnection(UserProvisioningRequest)
INFO: URL:http://gbpaacgdb:7001/grc/services/GrcService/UserProvisioningRequest
INFO: PEAWebServiceClient:about to POST query params
INFO: PEAWebServiceClient:sendRequest(sun.net.www.protocol.http.HttpURLConnection:http://gbpaacgdb:7001/grc/services/GrcService/UserProvisioningRequest)
INFO: Error stream is null

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. In EBS create a new user and assign responsibility to the user.
2. Click on Save > Action > Activate Responsibility.
3. Remove End Date from the Responsibility.
4. Click on Initiate Conflict Analysis.
5. See the above error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot make use of any features of PEA.

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