2 Integrations Issues
Review Integrations issues in Oracle Integration.
Topics:
Adapter Issues
Review known issues associated with adapters.
REST Adapter Multipart/Mixed Option 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. 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
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 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
.xsl
file to change the mapping entries forP_BOM_REVISION_TBL
,P_BOM_REF_DESIGNATOR_TBL
, andP_BOM_SUB_COMPONENT_TBL
as 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
- 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
Terraform script-generated service instances don't work. 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
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.