Troubleshoot Oracle E-Business Suite apps

Use the information here to troubleshoot and resolve common Oracle E-Business Suite integration app issues.

The certificate doesn't specify OCSP responder/CRL error

Using a custom security appliance and issuing certificates on the fly can cause issues with Java Web Start.

Try the following solution:

  • Turn off on-the-fly certificate issuing in the app.

The EBS Database is inaccessible

EBS Database host name error

During validation the following error occurred:

  • Oracle EBS SSO Agent validation failure (Validation of EBS Connectivity failed, Database connectivity failed)

Try the following solutions:

  • Ensure that the EBS database allows network connections to and from Access Gateway nodes.
  • Ensure that Access Gateway can resolve the value of the HOST parameter in the DBC file. For example, examine the DBC file, and search for (HOST\=apps.example.com).
    Test it using the Access Gateway Management console. See Management Console command-line reference

EBS invalid user

When signing in to the EBS app, an Access Denied error appears.

Try the following solutions:

  • Confirm the EBS_USER attribute value. The value of this header must be a correct EBS username in upper case, like JSMITH.
  • If the EBS username isn't the same as oag_username or the Okta username, you can create app-specific usernames. Confirm that the generated value is correct and all in upper case.

IE 11 Cookie error

Access Gateway is using the embedded EBS SDK to query EBS for the value associated with the HTTPSOnly flag. Depending on the EBS version or patch level, this feature may already be enabled in EBS instances.

For example, a cookie shows this issue:
EBSDB=97qayrxbV5kP4P8CY1Y1mllBjX; Version=1; Path="/; HTTPOnly"; Domain=.example.com; Discard; Secure Notice that Path is set to "/; HTTPOnly".
Chrome and FireFox and other browsers can handle the double quotes, but Microsoft Internet Explorer can't.

Try the following solution:

  • On the default policy, set an advanced directive of proxy_cookie_path '"' '';.

404 error returned for valid URL

When accessing a protected web resource, a 404 return code is returned for known valid URLs.

Java app servers typically return a 404 error for unauthorized access to a web app.

Try the following solutions:

  • Ensure that Access Gateway is sending all the required header attributes and that the attributes contain valid values. Test with static, known good values.
  • Review the protected app's logs on the app server to identify the underlying error.