Integrations Issues

2 Integrations Issues

Review Integrations issues in Oracle Integration.

Topics:

Adapter Issues

Review known issues associated with adapters.

Topics:

Private Endpoints and Oracle Fusion Applications Adapters

When a private endpoint is enabled for an Oracle ERP Cloud Adapter, Oracle HCM Cloud Adapter, or Oracle CX Sales and B2B Service Adapter connection, creation of the endpoint during design time may fail for certain SOAP business objects.

Oracle HCM Cloud Adapter ZIP File Issues

Note the following issues when using the Oracle HCM Cloud Adapter ZIP file feature:

A ZIP file that is extracted using the Oracle HCM Cloud Adapter must only contain a single file. If there are multiple files, only the file with the most recent time stamp is extracted.
The supported method for using the Oracle HCM Cloud Adapter ZIP file feature is to first zip your files, and then encrypt them.

Oracle E-Business Suite Adapter Issues

When using the Oracle E-Business Suite Adapter in an integration, you may encounter the following issues:

Trading partner setup form does not accept a password with special characters

The Trading Partner Setup form does not accept a password with special characters. Therefore, the Oracle Integration password should be a combination of text and numbers.
To resolve this issue, apply the following patches to enable Oracle XML Gateway to accept passwords with special characters:
- For Oracle E-Business Suite Release 12.2, apply Patch 27752692:R12.ECX.C.
- For Oracle E-Business Suite Release 12.1.3, apply Patch 28310667:R12.ECX.B.
Service invocation fails for certain PL/SQL APIs with table type input parameters

When invoking certain PL/SQL APIs having table type input parameters, the following exception may occur:
```
java.sql.SQLException: ORA-06531: Reference to uninitialized collection ORA-06512 
```
To resolve the exception, pass an empty element in the request corresponding to the table type in the API. For example, when invoking the PROCESS_BOM API with table type parameters P_BOM_REVISION_TBL, P_BOM_REF_DESIGNATOR_TBL, and P_BOM_SUB_COMPONENT_TBL, pass the empty tags as a workaround:
1. Export the integration with the mappings for the Oracle E-Business Suite request.
2. Locate the corresponding .xsl file to change the mapping entries for P_BOM_REVISION_TBL, P_BOM_REF_DESIGNATOR_TBL, and P_BOM_SUB_COMPONENT_TBL as follows:
```
<P_BOM_REVISION_TBL/>
<P_BOM_REF_DESIGNATOR_TBL/> 
<P_BOM_SUB_COMPONENT_TBL/>
```
3. Import this modified mapping for the request mapping.
4. Activate the integration and the API should be invoked successfully.

REST Adapter Connection to OCI Signature Version 1 Security Policy Fails with POST/PUT Verb

When you configure the REST Adapter connection to use the OCI Signature Version 1 security policy using a POST/PUT verb on the invoke activity, the policy fails.

Integration Issues

Review known issues associated with integrations.

Topics:

OCI Object Storage or OCI Function Error in a Tenancy Migrated from Oracle Identity Cloud Service to an Identity Domain

If you attempt to use the OCI Object storage action or OCI Function action in an integration in which your tenancy is using identity domains, you may receive the following errors:

OCI Object storage action:

oracle.tip.tools.adapters.cloud.api.CloudAdapterException: 
Couldn't authenticate while querying OCI Object Storage. You may need 
to enable identity domains for your instance in Oracle Cloud Infrastructure.

OCI Function action:

Couldn't authenticate while invoking an OCI Function. You may need 
to enable identity domains for your instance in Oracle Cloud Infrastructure.

These errors occur if your Oracle Integration instance tenancy was migrated from Oracle Identity Cloud Service to an identity domain.

This issue doesn’t impact tenancies that were always enabled for an identity domain.

Windows 10 Design-Time Issues

If you attempt to drag a connection into an integration when using the Chrome browser on Windows 10, the connection is not added. If you use Internet Explorer, a forbidden icon is displayed.

If you disable support for the touch screen and restart the browser, this issue goes away.

API Library Issue

Note the following API library issue.

If you attempt to register and save an uploaded library without any functions on the Libraries page, you receive a null pointer exception error. Ensure that your uploaded library includes functions.

Preferences Are Cleared When Browser Cookies Are Deleted

Assume you select user_name > Preferences in the upper right corner of the page, select Show these options at sign in, save your changes, and log out. The next time you log in, the preferences page is displayed. However, if you log out and then delete all cookies in your web browser, the next time you log in, the preferences page is not displayed. This is because preferences are stored in the cookies of the browser. Clearing the cookies resets the preferences.

Wizard for Notification Action Restarts After Clicking Done

After you add a Notification action to an integration and add a lookupValue function to the To field, the Map Lookup Value wizard doesn't function as expected. When you click Done on the last page of the wizard, the wizard should close. Instead, the first page of the Map Lookup Value wizard appears.

As a workaround, after you click Done in the Map Lookup value wizard and the first page of the wizard appears, click Cancel. When you return to the configuration wizard for the Notification action, return to the canvas and wait for an error to appear for the notification. Finally, edit the Notification action and redo the steps to add the lookupValue function to the Notification action. When you click Done, the wizard closes as expected, and your changes are saved.

Runtime Issues

Review known issues associated with runtime.

Topics:

Incorrect Instance Name in Notification Emails

Hourly notification emails sometimes list an incorrect instance ID in the email subject. Additionally, if you click the link in the email, the instance that sent the email message doesn't open.

An Error Sometimes Isn't Sent For One-Way Invokes

When an integration contains a one-way invoke that results in an error, the error is not sent to the application that sent the invoke.