xml
Discussion List
-
assign oic array to varchar2 field in DBSummary: Hello everyone, help with the following case. I have an integration in OIC that internally invokes a Rest service, this service has a response that contains an … -
XSLT to find elements whose total is equal to a target valueSummary: I have an xml in the following format and a target value. a 10 b 15 c 25 I need to find all the elements whose value is equal or less than the target va…
-
Response of OTM DB Servlet API is not coming in valid xml formatI have tested the OTM DB Servlet API to retrieve transmission report data, but the response is not coming back in the correct XML format. As a result, we are facing diff…
-
I am trying to read a xml file which is UTF-8-BOM encoded and Stage Read fails in OICSummary: I am trying to read a xml file which is UTF-8-BOM encoded and Stage Read Activity fails in OIC stating that "SAX Exception raised while trying to SAX Parse Inpu…
-
How to do application/x-www-form-urlencoded request in OIC rest adapterSummary How to do application/x-www-form-urlencoded request in OIC rest adapterContent Hi all, In POSTMAN, I can able to get a response using Body as x-www-form-urlencod… -
Extract fields from XML responseSummary: In OIC i'm receiving a BI Report that has xml data in it (i added a sample response as an attachment). I need to access the individual Columns out of the Row ar…
-
Use round function to rounding to 2 decimal placesSummary: Use round function to rounding to 2 decimal places Content (please ensure you mask any confidential information): Hi experts, I working in data maping but I nee…
-
Use the replace or replace String functions to remove special charactersSummary: Hi everyone, I need to remove special characters from a string for example: "A.*BC(D E+FGH?/IJK L#M%&//#?¡'¡N~OP" I have tried to apply the functions without su…
-
OIC Integration activation failure in Gen3Hi, We have created one OIC integration which involves a REST trigger and one invoke REST connection. That Integration is getting failed in activation with below error: …
-
Escaped characters in xml responseSummary: I have a SOAP request that looks like this: When i execute this request in soapUI the response looks normal, but when i execute this in OIC, the response looks …
-
csv file read failing in OIC when value contains escape characters quote( ") and comma( ,)Summary: csv file read failing in OIC when value contains escape characters quote( ") and comma( ,) Content (please ensure you mask any confidential information): I have… -
Error converting integer field to doubleSummary: Content (please ensure you mask any confidential information): Hi, I have a problem converting an integer type field to a double type field using the conversion…
-
How add multiple predicates in expresionSummary: How add multiple predicates in expresion Content (please ensure you mask any confidential information): Hi experts, I try to combine two predicates, it does not…
-
Filter information using predicates, when two or more nodes have the same keySummary: Filter information using predicates, when two or more nodes have the same key Content (please ensure you mask any confidential information): Hi experts, I'm wor…
-
OIC REST - how to save xml payload to ATP clob column opaquelySummary OIC REST - how to save xml payload to ATP clob column opaquelyContent I am trying to build a simple REST integration that when called from Postman with an xml pa…
-
Implementing Decline reason requirement in OTM as Mandatory?Summary: What is the approach in implementing the decline reason requirement as mandatory when the shipment is declined, and what are the ways to develop the solution? C…
-
Append variableSummary: Append global variable ans use the nodes into the object refered variable Content (please ensure you mask any confidential information): help me pleaseeee all e… -
Unable to Download the XSD Schema in OIC Gen3Hi Everyone, I would like ask if there's a way to download the configured schema in the OIC integration. We were able to do it in Gen2, however, in Gen3, we can only see…Sofia Danielle Sarmiento 142 views 4 comments 0 points Most recent by Monish Munot-Oracle Integration
-
xslt transformation logic to replace the xml element name/tag dynamicallySummary: xslt transformation logic to replace the xml element name/tag dynamically Content (please ensure you mask any confidential information): xslt transformation log…
-
Extracting the result returned from the service responseHello, the response returned from the REST service that I called within the integration I prepared in Oracle Integration Cloud is as follows. Here, I want to take each …
-
Using cXML in OAICSSummary Problem mapping the attributes of the cXML file...Content Hi OAICS Experts, sometime ago I posted the following. I managed to get over the problem of uploading a… -
Getting schema error while reading fixed position file in OICSummary: Getting schema error while reading fixed position file in OIC Content (please ensure you mask any confidential information): Hi Expert, I'm trying to read a fix…
-
how to replace EDI file content in javascriptSummary: We have a requirement where we have to change the envelope content of a EDI X12 3010 version file as it is not matching with the standard definition before proc…
-
Preserve previous value and actual value of for each on data mappingSummary: Content (please ensure you mask any confidential information): Hi experts, I am working on an OIC integration where I must have a for each in the data mapping. …
-
Nested for each in data mapping duplicate informationI try to use nested for each in data mapping to iterate complex nodes, complex nodes look like this: In the data mapping I have created something like this:
-
How to map multiple values of complex nodes using for each loops within data mappingSummary: I am using OIC version 3 Content (please ensure you mask any confidential information): I have an XML input in which I have complex nodes: I need write a CSV fi…
-
How to map a request value by filtering the information by the current value of a for eachSummary: Content (please ensure you mask any confidential information): Hi experts, I have an XML structure, I have created a for each on a certain node where I need to …
-
Make a copy of the files from one directory to another directory within the same SFTP through OICSummary: Make a copy of the files from one directory to another directory within the same SFTP server through oracle integration cloud. Please let me know the process to…Veera venkata satya Ranga Prasad 24 views 2 comments 0 points Most recent by Biman Dey Sarkar-Oracle Integration
-
Issue trying to read XML with multiple namespacesHi, I have an integration that is querying a binary file from Oracle Fusion to get PO Document, however, the response is an XML with multiple namespaces that I can't rea…
-
Is it possible to download csv files from OneDrive on OIC Integration?Summary: OneDrive + OIC Content (please ensure you mask any confidential information): I have a requirement where I must download CSV files from an integration, is this …