EBS Asserter Known Issues

After IAM authentication, instead of getting access to Oracle EBS, the user gets redirected back to EBS with the error message You have insufficient privileges for the current operation. The user is prompted to sign in again.

Generally, when the Oracle EBS application throws this error, it means that the cookie is set with an incorrect domain. To confirm this, check the EBS Asserter debug log, which you can find at <HOME DIR>/ebsasserter.log. For example

Aug 22, 2018 2:26:34 PM oracle.apps.fnd.ext.common.EBiz init
FINE: Ebiz init(): sessionCookieDomain =.oracle.com ; protocol=https:; ssoCookieName= ORASSO_AUTH_HINT

In this example, the EBS Asserter debug log shows that the sessionCookieDomain has an incorrect value, being set to .oracle.com.

The ICX_PARAMETERS.SESSION_COOKIE_DOMAIN must not be set to any value.

1. Update the SESSION_COOKIE_DOMAIN setting in ICX_PARAMETERS

   SQL> select SESSION_COOKIE_DOMAIN from ICX_PARAMETERS;
   
   SESSION_COOKIE_DOMAIN
   ------------------------------
   .oracle.com

2. Set session_cookie_domain to NULL in the ICX_PARAMETERS

   update ICX_PARAMETERS set SESSION_COOKIE_DOMAIN = NULL;
   commit;

3. Restart all services.
4. Retest the issue.

When you're logging out from Oracle EBS, the browser throws an error message Internal Server Error.

This issue happens because there is an old version of AppsLogoutRedirect.java in the Oracle EBS side.

Check the header for AppsLogoutRedirect.java in the Oracle EBS to see the version number, for example

adident Header $JAVA_TOP/oracle/apps/fnd/sso/AppsLogoutRedirect.class
$Header AppsLogoutRedirect.java 120.10.12010000.7 2010/01/19 20:18:52 rsantis ship $

Resolve this by applying the latest Oracle E-Business Suite Release 12 Critical Patch Update Jan 2013, or a more recent version. This Critical Patch Update enables AppsLogoutRedirect.java to leverage the APPS_SSO and APPS_AUTH_AGENT profiles. Check the Knowledge Document (July 2018) (Doc ID 2379675.1) for information on how to apply this patch.

While you're accessing the EBS Asserter application URL, the Oracle EBS application sign-in flow resulted in an internal server error.

The HTTP header trace looks like this

GET https://xxxxxxxxxxxxxxxxxx.oracle.com:7002/ebs/response?code=AQIDBAVcZbun_M5qU4-t9LUCYDjAOgWYiDOrf1Kb5ndbWAEYd05C-uxDfSwP8Ejfn51WT-gTuYj6bLFFYAFHQEqgYy26MTEgRU5DUllQZZIIFFVElPTl9LRVkxNCB7djF9NCAFFFABCDEF= HTTP/1.1

Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request

The session_exp is set to 1537715029. Use EpochConverter to convert the current Unix epoch time to a human readable date and time. Hence, the expiry time in the token is set to Sunday, September 23, 2018 3:03:49 PM GMT. However, the time in the EBS Asserter domain log is Sep 23, 2018 6:53:31,380 PM AST. Note that Greenwich Mean Time is 4 hours ahead of Atlantic Standard Time. Hence the time set is Sep 23, 2018 10:53:31 PM GMT.

The system where the EBS Asserter is deployed isn't in time sync with IAM, and as a result the token passed by IAM is effectively out of the validity period and hence the Token Expired error.

Ensure the date and time on the system where the EBS Asserter is deployed is in time sync with NTP servers, and hence the IAM host.

While you're accessing the EBS Asserter application URL, the Oracle EBS application throws the java.lang.ExceptionInInitializerError error.

The EBS Asserter debug log shows the following Java error

<Feb 26, 2019 2:17:16,884 PM PST> <Error> <HTTP> <BEA-101020> 
<[ServletContext@2100554246[app:ebs module:ebs.war path:null spec-version:3.1]] Servlet failed with an Exception
java.lang.ExceptionInInitializerError
at com.oracle.ebs.sso.ConnectionProvider.getConnection(ConnectionProvider.java:36)
at com.oracle.ebs.sso.RequestWrapperFilter.doFilter(RequestWrapperFilter.java:34)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78

While you're accessing the EBS Asserter application URL, the Oracle EBS application throws the java.lang.RuntimeException error.

The EBS Asserter debug log shows the following Java error

<Feb 26, 2019 2:01:33,454 PM PST> <Error> <HTTP> <BEA-101020> 
<[ServletContext@1207779454[app:ebs module:ebs.war path:null spec-version:3.1]] Servlet failed with an Exception
java.lang.RuntimeException: javax.naming.NameNotFoundException: Unable to resolve 'visionDS1'. Resolved ''; remaining name 'visionDS1'
at com.oracle.ebs.sso.ConnectionProvider.getConnection(ConnectionProvider.java:42)
at com.oracle.ebs.sso.RequestWrapperFilter.doFilter(RequestWrapperFilter.java:34)

To resolve this, set the ebs.ds.name value set to be the same as the datasource name created in WebLogic.

After IAM authentication, instead of getting access to Oracle EBS, the user gets redirected back to EBS with the error message You have insufficient privileges for the current operation. The user is prompted to sign in again.

This can happen because the deep link isn't working.

Check that the whitelist.urls bridge property is configured. If the issue persists, specify the port numbers explicitly in the whitelist.urls configuration. For example, whitelist.urls=http://ebs.oracle.com:80/OA_HTML….

Also, check the JSESSION ID Cookie Name of the E-Business Suite Asserter App in the weblogic.xml file. If there is any other web app in the WebLogic with the same cookie name, it will cause a conflict.

If you find issues during the sign-out process verify the Post Logout Redirect URL parameter value in IAM and the post.logout.url parameter value in the bridge.properties file.

The post.logout.url in the bridge.properties file is an optional parameter and by default you don't need to provide a value. You use this parameter to make the EBS Asserter application redirect the user browser to the specified URL after EBS Asserter finishes the sign-out process.

If enabled, the value of the post.logout.url in the bridge.properties file must match the value of the Post Logout Redirect URL parameter for EBS Asserter application in IAM.

1. Open the EBS Asserter application in IAM and update the Post Logout Redirect URL value.
2. Open the ebs.war file, update the bridge.properties file, regenerate the war file, and redeploy the file to the WebLogic server. Ensure the value of this parameter matches the Post Logout Redirect URL parameter in IAM.

You get an error which included invalid_client and Client authentication failed, such as this

<Error> <oracle.security.jps.idcsbinding.shared.AuthenticationManagerImpl> <BEA-000000> <getting error from server>

oracle.security.jps.idcsbinding.shared.AuthenticationManagerImpl clientCredentials

SEVERE: {"error":"invalid_client","error_description":"Client authentication failed.","ecid":"xxxx-xxxx-xxxx-xxxx-xxxx-xxxx"}

1. Check the Client ID and Client Secret generated in the IAM Confidential Application..
2. Regenerate the wallet file using the correct Client ID and Client Secret.
3. Redeploy the asserter.war file on the Weblogic Servers.

You get an error saying that Oracle EBS core profiles aren't available to edit. To resolve this:

1. In Oracle EBS, go to the Oracle Applications Administration page in Oracle EBS. Click the Core Services tab, and then click the Profiles tab.
2. When the Oracle EBS application contains no value, the edit button is disabled.
3. Click Define Profile and enter profile values.

The Applications user,
          EBSASSERTER is not authorized to access the database

<Error> <Deployer> <wahatast> <AdminServer> <[STANDBY] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c596f25b-e3d0-42e2-81a9-682c623d2d1c-00000162> <1677049594045> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-149265> 
<Failure occurred in the execution of deployment request with ID "24806329095989206" for task "weblogic.deploy.configChangeTask.2" on [partition-name: DOMAIN]. 
Error is: "weblogic.application.ModuleException: weblogic.common.ResourceException: ORA-20001: Oracle error -20001: The Applications user, EBSASSERTER is not authorized to access the database. has been detected in FND_SECURITY_PKG.FND_ENCRYPTED_PWD_X.

This error occurs when the asserter user present in EBS Application hasn't been assigned the correct role. Sign in to the Oracle EBS application and provide the APPS_CONNECT_SCHEMA role to the asserter user.

The EBS Asserter uses the JNDI service within the WebLogic server to create DB connections with the Oracle EBS DB. Over time, the number of connections keeps increasing and the inactive sessions are closed. This leads to the connection pool getting full, and not able to make any new connections with the Oracle EBS DatabaseThis results in a connection error at the EBS Asserter.

<Error> <HTTP> <BEA-101017> <[ServletContext@784524422[app:ebs module:ebs.war path:null spec-version:3.1]] Root cause of ServletException.
weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool PAVCRIDS to allocate to applications, please increase the size of the pool and retry..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:280)
at weblogic.jdbc.pool.Driver.connect(Driver.java:154)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:665)
at weblogic.jdbc.jts.Driver.connect(Driver.java:129)
at weblogic.jdbc.common.internal.WLDataSourceImpl.getConnectionInternal(WLDataSourceImpl.java:655)

A restart of the WebLogic servers acts as a temporary fix to make the asserter available for new connections.

Inactive
        Connection Timeout

Inactive Connection
        Timeout

1. Sign in to the Weblogic Server Admin Console.
2. Go to Data Sources.
3. Search for the Data Source Name you want to change, and click Data Source.
4. Click Configure a Connection Pool.
5. Expand the Advanced tab.
6. Update the Inactive Connection Timeout to the new value.

   For example: Inactive Connection Timeout = 900 (15 minutes).

Test "select count * from select 1 from fnd_nodes;" set up for pool "EbsDS1" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name.

This error due to a name mismatch, where the ebs.ds.name parameter in bridge.properties isn't same as the name of the datasource created in EBSAsserter's WebLogic.

To resolve this, set the ebs.ds.name value set to be the same as the datasource name created in WebLogic.