Adapters
Discussion List
-
Can OIC consume BLOB or CLOBSummary DB Adapter is invoking a PL/Sql Procedure which is returning CLOB/BLOB as out parameter, Can we consume the same in OIC.Content DB Adapter is invoking a PL/Sql P… -
best approach to insert into multiple tables from OICSummary: Looking for the best way to proceed to bring in data with many collections of data within it Content (required): Hi. I am extremely new to OIC and just stumbled…
-
OIC 3. ATP adapter, stuck calling db. procedure.Summary: Hi, please, has anyone seen this in OIC3? I cannot select procedure in ATP connection. I have done a basic integration from scratch. Is this a bug? or is any tr…
-
OIC gen 3 performance (really good) for our test.Summary: Please, can someone explain the meaning of "OIC gen 3 now is native to OCI" that I have read somewhere in the documentatión. We are evaluating OIC3 for performa…
-
Instance id in OIC gen 3.Summary: Hi Oracle teams, I am evaluating OIC3 for a real project. I have just noticed the instance id is not a number, is a string: In the customer I am working several…
-
Does Oracle CX Sales adapter have the capability to GET several records?Summary: We created an integration using the Oracle CX Sales adapter with the following Business Object and operation below. However, we are only getting 25 records on t…
-
Microsoft SQL server adapter - select from a table- valued function with input parametersSummary: Microsoft SQL server adapter - select from a table- valued function with input parameters Content (required): I have some table - valued functions in SQL server… -
Erp cloud connection for callback.Summary: Hi, please can someone clarify the following. In one instance I have access I see this connection: It seems prepared for trigger/invoke and callback integration…
-
BIP report without data fails in Stage ReadContent Hi Team, Good day! I have been able to successfully write data records to target endpoint using OIC for BIP reports. However, when the report is executed and it … -
Error While Configuring Eloqua Connection using Eloqua Adapter as Trigger in OIC Integration?Summary: Hello I am trying To create a connection between Eloqua and OIC using an Eloqua Adapter But while configuring Eloqua as a Trigger It Gives an Error that CASDK-0…
-
How can we filter the HCM worker api by the LastUpdateDateHow can we filter the HCM worker api by the LastUpdateDate? Have tried the below:- 1)q=(LastUpdateDate BETWEEN '2017-09-15T00:00:00.000%2b00:00' AND '2022-09-15T00:00:00…
-
OIC nested array item readSummary: What would be the best approach to read a nested array item that was returned from a REST API? I used for-each action to narrow down to each Nested array under … -
Trigger Callback Integration after Custom ESS Job CompleteSummary: Is it possible to trigger a Callback Integration after a Custom ESS Job finishes your execution? Content (required): Hi, For this scenario, we have one custom E…
-
Integrate Oracle CPQ with Oracle CommerceSummary: Integrate Oracle CPQ with Commerce enable a number of features that your shoppers can use, including allowing a shopper to configure products, request quotes, o…
-
Gmail AdapterHi, I am having a problem accessing some elements in the response of the gmail adapter for example the parts element is originally an array but when I try to access it i… -
What is the maximum file size can receive from Callback via ERP AdapterSummary: What is the maximum file size can receive from Callback via ERP Adapter Content (required): Version (include the version you are using, if applicable): Code Sni…
-
OIC - REST Invoke - Read JSON response for 400 Status CodeSummary: Hi there We have REST Invoke operation and it is sometimes giving 400 status with JSON response. How can read the JSON data in case of a 400 status code? Conten… -
Schedule Service and WSSExternal in ERP Cloud AdapterSummary: Hi Everyone - we are building OIC where we need to call some business objects along with BIP and Schedule Service WSDL. Currently I am not able to find BIP and …
-
OIC - Encrypted fixed position file is getting truncatedSummary: There is an existing OIC integration which reads encrypted file and do some processesing and finally upload the HDL file for element entries. There are no error… -
How to delete files older than x days on OIC file serverSummary: Bulk delete files older than x days Content (required): Is there any script or a way to mass delete files older than x number of days? We need to cleanup our fo…
-
Oracle Integration 3 to integrate object storageSummary: Hi Experts I'm using Oracle Integration 3, I want to build integrations to upload and get the objects / files from object storage. Can someone please help me wi…
-
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…
-
How to download xml report output of process Import Payables InvoicesSummary: How to download xml report output of process Import Payables Invoices Content (required): Hi experts, I am working on an integration for import payables invoice…
-
Access data recieved from a SQL stored procedure as rowSetSummary: Access value of a specific column in a specific row within a RowSet. Content (required): I have a SQL Stored Procedure which returns a table together with anoth…
-
You don't have permission to access this resource on the server. I am getting this response from OICSummary: I am getting "You don't have permission to access this resource on the server." when invoking an OIC api with attaching zip file of size 972 MBs. The api is wor…
-
Invoking SOAP BIP service with OAuthSummary: How to invoke SOAP report Bi service without basic authentication Content (required): We are using report SOAP service for calling BI reports using runReport ac…
-
Oracle ICS: FTP Adapter Connection via SFTP Hangs Up (Connection Timeout) when TestingSummary After providing the SFTP details (host, credentials, etc) and trying to TEST the connection, it hangs up (seems connection timeout), it doesn't give any response… -
Error when Create Agent GroupSummary: try to install agent , got error :Agent Installation Failed !!! Error occurred while checking version response. Agent Installation Failed. Content (required): V…
-
Generate Private Key from OCI for OCI Signature Version 1 Security PolicySummary: Hello Community, Can anyone provide me with a good documentation that shows how I can create the Private Key from OCI for OCI Signature Version 1. I didn't find…
-
Getting CLOUD-0005: Unable to establish connection Error while configuring ATP DB AdapterSummary: Getting CLOUD-0005: Unable to establish connection Error while configuring ATP DB Adapter Content (required): Hi Expert, I'm getting CLOUD-0005: Unable to estab…