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
-
How to manage session ID while invoking cpq webservice through OICSSummary genrate session ID dynamicallyContent Hi All, Im trying to trigger data table soap webservice from OICS, have hard coded , -
ERP Cloud Business Event subscription error in OICSummary ERP Cloud Business Event subscription error in OICContent We have configured ERP Cloud connection for Business Events subscription per this document - https://do…
-
OIC - Best practices for Migration between environmentsSummary Migration of Integrations in Oracle Integration CloudContent Hi, While migrating Integrations from test instance to Prod , what protocols should be followed. Is …
-
How to store file into database in blob type fieldContent Hi Team, I have a database table where there is one field of type blob in which I wanted to store images, pdf files. Wanted to read the files from FTP. Is this p… -
Unzip file option SFTP OICSummary Unable to unzip optionContent Hi Gurus, We have 2 SFTP connections and we are not seeing the unzip option in one SFTP versus other. Only Difference is Security P…
-
Facing Java Null Pointer Exception While Replacing The SFTP Connection and Saving the Integration FSummary Facing Java Null Pointer Exception While Replacing The SFTP Connection and Saving the Integration FlowContent Hi All, Facing Java Null Pointer Exception While Re… -
How do I escape special characters when using Concat as a node value?Content I want to use the monitoring API detailed here: https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/op-ic-api-integration-v1-monitoring-instances-ge…
-
Get metadata about integration/s already running?Summary How can I find out if the current integration is already running with the same tracking information?Content Is there a way within an integration to gain informat…
-
Not able to getresponse from the child integration in mapper for next step in parent integrationSummary GETRESPONSE from child integration call is empty. Doesnt show response elements in mapper for next stepContent Hey Experts, I have an issue with calling child in…
-
Parent - child data in oicContent Hi Experts, I have two CSVs as attached and both the CSV has a common attribute id. I want to create a REST API that will read both the files, combine the result…
-
Parent - child data in oicContent Hi Experts, I have two CSVs as attached and both the CSV has a common attribute id. I want to create a REST API that will read both the files, combine the result…
-
Report of Integration Run Times...Performance monitoringContent We have an integration that could be called thousands of times a day. Performance hasn't been an issue, but I am expecting people to ask for a report of average …
-
REST Query ParametersSummary REST Query ParametersContent Hi Experts, Below REST endpoint returns array of records with startdate and enddate as two of the many elements. startdate and endda…
-
Unstructured csv to xsdSummary Unstructured csv to xsdContent Requirement is to Process unstructured csv, sample csv structure 1. c1,c2,c3,c4,c5 2. c1,c2 3. c1,c2,c3 record one and two are rep…
-
Expose table in DBCS as a REST EndpointSummary Expose table in DBCS as a REST EndpointContent Hi Team, What are the steps to expose a table in DBCS as a REST endpoint and how to invoke it to insert the data. …
-
BICC to OCI Storage ConnectivitySummary Connectivity from BICC to OCIContent We have connections from BICC (Oracle Business Intelligence Cloud Connector Console) to OCI (Bucket Storage) and OIC will ac…
-
Microsoft SQL server Adapter returns scientific number from tableSummary Microsoft SQL server Adapter returns scientific number format 1.101984E7 instaed of 110198407Content We have configured MSSQL adapter to read data from a table.R…
-
OIC IBM DB2 Adapter & AS400Summary DB2 AdapterContent Hello All, I understand OIC has a prebuilt IBM DB2 adapter which allows to perform CRUD operations for DB2. However another Document Doc ID 24…
-
Can we call OIC / ICS Wrapper Service from ESS directly?Summary Current structure : ESS > BIP Report > OIC/ICS Wrapper service. I want : ESS > OIC Wrapper Service. Is it possible?Content Greetings Everyone, Existing :- * BI S… -
ESS jobcall from OICS getting erroredSummary failing to call ess job from OICSContent HI All, Im trying to submit one ess job request from OICS, below are the error and payload. can someone help me. Error: …
-
Using OIC to Make JDBC calls to AS400Summary JDBC Calls using OICContent Hello Everyone, We have a requirement where we need to intergrate AS400 DB to OIC. AS400 supports JDBC calls. Is there a way we can u…
-
FBDI File Export to FTPSummary FBDI File Export to FTPContent Hi, We want to start our first integration with File Based Orchestration. For this purpose we first want to schedule a file upload… -
Restricting OAuth2 client credentials to a specific integration?Summary Is there a way to limit OAuth2 client credendials to authenticate to a specific OIC integration?Content We have successfuly used the documentation https://www.at…
-
Rollback Support for OIC Integration?Summary Rollback Support for OIC Integration?Content Hi Team, We have built a synchronous OIC integration, which performs the below operations in a sequential order: 1. … -
Oracle Integration Cloud learningContent Hi All, I have a dedicated YouTube Channel where I regularly upload Oracle Integration Cloud-related videos that help everyone to learn OIC step by step. Here is…
-
Issue with Error Handling case in Batch Actions of Rest Service in Contract Billing EventsSummary Error Handling based on batch wise in Rest Service of billing eventsContent Hi All Facing issue in catching error message in SOA for batch actions in Billing eve…
-
Create new AP invoice with status "Validated"Summary newly imported ap invoices has status "never validated"Content I'm using ebs adapter in oic , to import AP invoices into EBS . and the invoices are imported with…
-
ERP Cloud AdapterContent Hi guys, In the ERP Cloud Adapter, how can I make a Purchase Requisition? Is there any Role I need to release this API or is there really no API in the Adapter? … -
Need to decrypt file which has been encrypted and signedSummary I have an integration where i need to decrypt an encrypted file which is also signed by the clientContent I Need to decrypt file which has been encrypted and sig… -
Retrying faults at the scope levelSummary Retrying faults at the scope levelContent Hi Team, The blogs https://www.ateam-oracle.com/oic-error-handling-guide says Note that when an instance is resubmitted…