Troubleshoot the Oracle E-Business Suite Adapter While Using it as an Invoke (Target) in an Integration

The following table describes troubleshooting information while using the Oracle E-Business Suite Adapter as an invoke (target) connection in an integration:

Issue Resolution
When the Metadata Provider API in Oracle E-Business Suite only has the "isActive" method deployed, but the rest of all methods in the API are not deployed, then the following error may occur:

Empty set of values appear in the drop down during the Product Family selection.

To resolve the issue, ensure to deploy all the methods in the Metadata Provider API with GET verb and with service alias "provider".

For information on deploying the Metadata Provider service, see step 3, as described in Setup Tasks for Enabling the Oracle E-Business Suite Adapter.

When any of the Metadata Provider API methods (such as getInterfaces, getMethods, getProducts) except the "isActive" method are deployed but do not have grants created, the following error may occur:

The application has encountered an unexpected error. Please check the application connection details and credentials, and retry your request.

To resolve the issue, in addition to deploying all the methods in the Metadata Provider API with GET verb, ensure that you grant the required user privileges to the Metadata Provider service, as described in step 4, Setup Tasks for Enabling the Oracle E-Business Suite Adapter.

When you attempt to edit an integration endpoint with Oracle E-Business Suite connection that has been successfully executed, the API used in the integration is not selected and an error occurs.

The cause of this issue could be due to product name change of the API used in the integration. To resolve the issue, you must reselect the product name of that API in the Web Services page of the Configure Oracle E-Business Suite Adapter Endpoint Wizard.
If you select an interface that is not deployed as a REST service in the Web Services page of the Configure Oracle E-Business Suite Adapter Endpoint Wizard, the following error occurs:

Service is not deployed as REST in Oracle E-Business Suite. To use this service, deploy it from Integration Repository of Oracle E-Business Suite. Contact Oracle E-Business Suite Integration Administrator.

(See Undeployed REST Service Error Message)

This error occurs because none of the methods within the selected interface is deployed as a REST service operation. To resolve this issue, ensure that you deploy the selected interface as a REST service first before using it in an integration. For information on deploying an interface as a REST service, see step 3 as described in Setup Tasks for Enabling the Oracle E-Business Suite Adapter.
If you select a method or operation that is not deployed as a REST service operation in the Operations page of the Configure Oracle E-Business Suite Adapter Endpoint Wizard, then “Not Deployed” is shown as the Service Status field, along with the following error:

Service operation is not deployed in Oracle E-Business Suite. To use this service, deploy it from Integration Repository of Oracle E-Business Suite. Contact Oracle E-Business Suite Integration Administrator.

(See Method with “Not Deployed” Status Error Message)

Ensure that you deploy the selected method as a REST service operation first by using the following steps:

  1. Log in to Oracle E-Business Suite as a user who has the Integration Administrator privileges.

  2. Navigate to the Integrated SOA Gateway responsibility and then select Integration Repository from the navigation menu.

  3. Search for the desired API. It can be an interface type of PL/SQL, Java, concurrent program, or open interface table or view.

    Note:

    To locate a Java API, ensure that you select the following fields after clicking Show More Search Options in the Search page:
    • Category: Interface Subtype

    • Category Value: "Java Bean Services" or "Application Module Services"

  4. Ensure that you select the desired method or operation that you want to use in an integration before deploying it as a REST service operation.

    See: Deploying REST Web Services, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide.

  5. Log in to Oracle Integration.

  6. Navigate to an Oracle E-Business Suite connection that you want to use in your integration.

  7. From the Actions menu, click Refresh Metadata.

The deployed interface should be available for use in Oracle Integration.

When attempting to select the Read operation for a Java method in the Operations page of the Configure Oracle E-Business Suite Adapter Endpoint Wizard, you cannot find it displayed for selection. The Read operation performs the GET HTTP verb for a Java method. When it is not available for selection in the Operations page of the Configure Oracle E-Business Suite Adapter Endpoint Wizard, this indicates that the Java method does not have GET selected during the REST service deployment in Oracle E-Business Suite.

To use this operation for a Java method in an integration, perform the following tasks:

  1. Ensure the GET check box for the Java method that you want to use is selected before service deployment. Otherwise, you can only use the default "Create" operation that performs the HTTP “POST” action for that Java method in an integration.

    See: Deploying REST Web Services, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide.

  2. Select the Read operation for that Java method in the Operations page of the Configure Oracle E-Business Suite Adapter Endpoint Wizard when adding the Oracle E-Business Suite Adapter as an invoke connection.

    See: Invoke Oracle E-Business Suite Java APIs from Oracle Integration.

Undeployed REST Service Error Message

If none of the methods within the selected interface is deployed as a REST service operation, then an error message is shown indicating that the associated REST service is not available. You must deploy the selected interface as a REST service in Oracle E-Business Suite first.
Description of webservice_error.gif follows
Description of the illustration webservice_error.gif

Method with “Not Deployed” Status Error Message

If a selected method is not deployed as a REST service operation, then “Not Deployed” is shown as the Service Status field value, along with an error indicating that you need to deploy the selected method first before using it in an integration.


Description of notdeployed_method.gif follows
Description of the illustration notdeployed_method.gif