2 Integrations Issues
Review Integrations issues in Oracle Integration.
Topics:
Adapter Issues
Review known issues associated with adapters.
REST Adapter Multipart/Mixed Option Issue
Issue: If you are using the multipart/mixed option with XML Schema or XML Sample as your payload format in the REST Adapter and view the Request/Response pages in the Adapter Endpoint Configuration Wizard in edit or view mode, JSON Sample is shown as selected. Re-upload your sample payload.
Workaround: None. Despite JSON Sample appearing, this doesn't affect runtime and your XML payload is parsed correctly for mapping.
Private Endpoints and Oracle Fusion Applications Adapters
Issue: 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.
Workaround: None.
Oracle HCM Cloud Adapter ZIP File Issues
Note the following issues when using the Oracle HCM Cloud Adapter ZIP file feature:
- 
                              Issue: 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. 
- 
                              Issue: The supported method for using the Oracle HCM Cloud Adapter ZIP file feature is to first zip your files, and then encrypt them. 
Workaround: None.
Oracle E-Business Suite Adapter Issues
When using the Oracle E-Business Suite Adapter in an integration, you may encounter the following issues:
- 
                           Issue: 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. Workaround: 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.
 
- 
                           Issue: 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-06512Workaround: 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_BOMAPI with table type parametersP_BOM_REVISION_TBL,P_BOM_REF_DESIGNATOR_TBL, andP_BOM_SUB_COMPONENT_TBL, pass the empty tags as a workaround:- 
                                 Export the integration with the mappings for the Oracle E-Business Suite request. 
- 
                                 Locate the corresponding .xslfile to change the mapping entries forP_BOM_REVISION_TBL,P_BOM_REF_DESIGNATOR_TBL, andP_BOM_SUB_COMPONENT_TBLas follows:<P_BOM_REVISION_TBL/> <P_BOM_REF_DESIGNATOR_TBL/> <P_BOM_SUB_COMPONENT_TBL/>
- 
                                 Import this modified mapping for the request mapping. 
- 
                                 Activate the integration and the API should be invoked successfully. 
 
- 
                                 
Integration Issues
Review known issues associated with integrations.
Errors in a Tenancy Migrated from Oracle Identity Cloud Service to an Identity Domain
If your Oracle Integration instance tenancy was migrated from Oracle Identity Cloud Service to an identity domain, you can receive errors when using the OCI Object storage and OCI Function actions or using a terraform script-generated service instance. These issues don’t impact tenancies that were always enabled for identity domains.
Using OCI Object Storage or OCI Function Error in a Tenancy Migrated from Oracle Identity Cloud Service to an Identity Domain
Issue: If you attempt to use the OCI Object storage action or OCI Function action in an integration, you can 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.
Using a Terraform Script-Generated Service Instance in a Tenancy Migrated from Oracle Identity Cloud Service to an Identity Domain
Issue: Terraform script-generated service instances don't work.
Workaround: Open a service request (SR) against Oracle Cloud Infrastructure Identity and Access Management (OCI IAM) and request a fix for Jira issue IDCS-152404.
Windows 10 Design-Time Issues
Issue: 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.
Workaround: If you disable support for the touch screen and restart the browser, this issue goes away.
Dynamic Process Calling an Integration Does Not Work after Phased Upgrade
Issue: After phased upgrade of Process from Oracle Integration Generation 2 to Oracle Integration 3, dynamic process calls using the integrations activity will not work. Oracle Integration Generation 2 Process does not show any error and erroneously indicates that the integration call is successful although it is not successful.
Workaround: You can reconfigure these calls to use the Service Task (calling the REST trigger on Oracle Integration 3).