To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Integration
Discussion List
-
File limitation on Purchase Order attachment using ErpObjectAttachmentService Web Service via OICSummary: File Limitation on Purchase Order attachment using ErpObjectAttachmentService Web Service via OIC Content (required): 10 mb limitation on File Upload Version (i… -
Customer APIs to fetch customer communication informationCustomer APIs/Data model to fetch Customer's Communication Information Hi Experts, In our UC we need to fetch Customer communication information from Fusion/ERP. Any poi…
-
Getting MySQL Error on OIC Caused by java.sql.SQLNonTransientConnectionExceptionSummary: Error Message:- DBReadInteractionSpec Execute Failed Exception Query name: [FetchRecordSelect], Descriptor name: [FetchRecord.Test]. Caused by…
-
Getting MySQL Error All of Sudden (Caused by java.sql.SQLNonTransientConnectionException)Summary: Error message: - Caused by java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed.. Content (required): Hi Team, I'm using M…
-
Estimate End Time/Duration of a Scheduled IntegrationSummary: We have scheduled integrations that would process multiple files in a single instance. Is there a way we can identify the estimated end time/duration of the run…
-
Write file with multiple record typesHi All We are reading data from ATP tables and need to a write the file for target system which has multiple record types. Header, field1, field 2, field 3 Line1, field4… -
Accessing a file from OIC staging directory via a javascript functionSummary: Has anyone experienced accessing a file from OIC staging directory via a javascript function i.e. passing the file reference/ stream reference of the file to th…
-
Pass JSON payload as-is without OIC Mapper to SaaS REST APISummary: Content (required): Is there any way we can form a JSON payload and pass that payload as-is without mapping each element from left to right? Version (include th… -
why is OIC freezing up when invoking a stored procedure in an integration?Summary: In the oracle database adapter endpoint configuration wizard, I first provide a name, next select the schema, next select the package, next select the procedure… -
Convert an App Driven Orchestration to Scheduled OrchestrationSummary: Can we convert an App Driven Integration to a scheduled one without having to rewrite whole integration? Content (required): Version (include the version you ar…
-
Single Sign-On SOAP/REST APIsSummary: Content (required): How can we trigger SOAP/REST APIs using the Single Sign-on credentials of Microsoft Azure in Fusion SaaS? We are referring to this blog of t…
-
Elements are blank when Read File in Segment operation is usedSummary: Elements are blank when Read File in Segment operation is used Content (required): I'm trying to read a structured XML using the Read File in Segment operation …
-
Is there a way to require the rest connect to pull one row at a time from the database ?Summary: Need Rest integration to pull one row at a time from the Apex Database and pass it to another rest API . Content (required): APEx Database to Application api Ve… -
Connecting Primavera Webserices and an Apex database with OIC Can you explain the process ?Summary: I have created Two Connection s and an integration but can seem to get it to wok Content (required): What are the right steps to invoke a soap connection to Pri…
-
do we have any way to monitor SaaS from APM?Summary: can we monitor SaaS transaction(customer fetch) from APM Content (required): APM Version (include the version you are using, if applicable): Code Snippet (add a…
-
How to download the zip document received as response from rest adapterHi, I have a rest adapter to which I send the file name.I am getting the response but how can I download this to OIC ftp location? We send the request as https://sfp.ocs…
-
Benefits Carrier Extracts - Oracle Integration CloudSummary Benefits Carrier Extracts - Oracle Integration CloudContent Hi All, we are planning to use Oracle Integration Cloud to send the carrier extracts data with Benefi… -
How to generate JWT in OIC to connect to third party REST endpointSummary Need to connect to third party authentication service using JWT to get bearer token back for further accesses, can't find any option available in OIC to generate… -
Publish Subscribe Architecture in OICContent Hi, We have below requirements for few of the Integrations in OIC (similar to on premise SOA). Since Oracle no longer offers "Oracle Message messaging service" a…
-
List of Values for schedule parameters in IntegrationSummary List of Values for schedule parameters in IntegrationContent Hi All Can we create list of value based schedule parameters in OIC ? For example we can have an int…
-
Bulk Import for Financial Accounting Hub TransactionSummary APIs/WS Payload for submitting for Financial Accounting HubContent Hi Experts, Can we perform a Bulk Import for "Import Accounting Transaction’ " using web servi… -
Assign variable mapped to a tag thats not generated in REST API response throws errorSummary Assign variable mapped to a tag thats not generated in REST API response throws errorContent I have mapped rest api response to variable "Payroll". The tag(Payro…
-
Salesforce BulkAPI integration with OICSummary Salesforce BulkAPI integration with OICContent Hi All, We are trying to establish integration with Salesforce for BulkAPI process with "Perform Bulk Data Operati… -
Error calling Local Integration from ParentSummary Error calling Local Integration from ParentContent We have an integration where the Parent invokes the child local integration. It gets error from Local integrat…
-
Connection to MySQL DB hosted in AWSSummary Can we connect to MySQL DB without using connectivity agent which is hosted in AWS in public network.Content Hello Everyone, Can we connect to MySQL DB without u…
-
Create worker is not shown in the HCM connector operationsContent Hi guys! I am developing a integration that creates the worker in the oracle HCM using the Rest API create worker (https://docs.oracle.com/en/cloud/saas/human-re… -
Can we install the connectivity agent on windows Machine for OIC ClassicContent Hi, we are in OIC V19 that means its OIC Classic version. we want to connect the Third party system for that i have created the agent group and downloaded the ag…
-
OIC Error message handling to remove line breaks, carriage return etc and replace with spaceSummary OIC Error message handling to remove line breaks, carriage return etc and replace with spaceContent Hi Team, We want to create an error report as a pipe-delimite…
-
ServiceInvoker role to a specific integrationSummary ServiceInvoker roleContent Hi, We have a requirement to provide ServiceInvoker role to a larger group of people. We do have workarounds to avoid that. But, I jus…
-
Can we dump JSON file in ATP table using OICContent I am getting data from JDEdward ERP using rest API in JSON format but JSON is a very weird format and unable to call data in VBCS so I want to dump the JSON file…