Adapters
Discussion List
-
OIC DB Adapter and REST API - LoopingSummary: 1) GetProductInfo is using DB Adapter named 'Product Information' to get all the rows from Oracle database; results are fetched using SQL statement based on the… -
Custom adapters in OIC 3Summary: Hello, Can we create Custom adapters in OIC Gen2 and Gen3? I don't seem to find any documentation around this. Content (required): Version (include the version …
-
Snowflake adapter in Integration 3.Summary: Hi I have read this doc. about snowflake integration 3. Please I am missing something when reading, I would like to know if this adapter can be used to work wit…
-
how to read OAuth scope in OIC trigger REST APISummary: Hi, We have a requirement to access OIC REST API endpoints using OAuth flow by 3rd party clients. The use case is we want to create custom scopes for each clien…
-
[OIC] Connect to Nirvana JMS queue (JMS context “com.pcbsys.nirvana.nSpace.NirvanaContextFactory”)Summary: Hello All, In OIC (Oracle Integration gen. 3), is it possible to connect directly to a Nirvana JMS queue (JMS context “com.pcbsys.nirvana.nSpace.NirvanaContextF…
-
Read text in file with special characters (Finland) and store in db does not work for me.Summary: Hi, I would thank for help with the following. I am importing a text file into db. but special characters are not ok. Example: I have this in the file: and I ha…
-
Read text file and store in db respecting the orderSummary: Hi, please I would like your help with the following: I receive a file with this pattern: line to remove line to remove line to remove **** **** **** line to …
-
OCI integration with OCI QueuesSummary: Hi All, There is an integration which is publishing messages to OCI queue. Integration is working for small payloads. But when we tried with huge payloads integ…
-
DB Adapter reflects new columnSummary DB Adapter DOES Not reflects new columnContent When we add a new column in table, in OIC we have to delete the whole mapper which comes along with the adapter. I…
-
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…
-
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…