xml
Discussion List
-
How to read Special Character in OICContent Hi Experts, I have limited knowledge on OIC and need a small help.We have built a BI report(eText Template) which when run from Fusion BIP generates a file in wh… -
how to read the unstructured file in OICSummary: Hello Team, I am trying to find out a way to read the .txt file for which structure is not defined. The sample file looks like below, please help me how we can …
-
OIC File Read with XSD errors outSummary: Trying to read a file with Header,data and trailer rows. Created xsd structure and was able to select in stageFile action. since i am expecting single trailer r…
-
Difficulty summing one column while aggregating other columnsSummary I am trying to take a file that has thousands of rows and dozens of columns and aggregating it to only 5 columns. I have successfully aggregated the 4 rows of id…
-
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…
-
Incorrect XML Structure sent by ScheduleReportServiceWSS service.Summary Unable to fetch child elements data from 'ScheduleReportWSSService ' response operations in OIC.Content Hi All, I have the following requirement: We want to fetc…
-
Unable to read the response of Oracle BIP scheduler service ScheduleReportWSSService in OICHello Everyone, We are using below wsdl service to schedule a BIP report in oracle fusion cloud: WSDL : https://XXXXXX:443/xmlpserver/services/ScheduleReportWSSService?w…
-
OIC Failing Due to XML Size Limit Exceeding 100MB in ATP Data TransferWe are encountering a critical issue in Oracle Integration Cloud (OIC) while transferring data from a public ATP table to a private ATP database. When executing a SELECT… -
how to write a CLOB column with XML content as a single file with original XML contentSummary: OIC-BIP-OCI Bucket File - how to write a CLOB column with XML content as a single file with original XML content Content (please ensure you mask any confidentia…
-
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…
-
Pre-built extract for HireRight License ValidationSummary: Hi there. We are working with HireRight to implement the License Monitoring program they offer. With that, we are looking for the 'pre-built extract' referenced…
-
stage action append the text data in a loop to a fileSummary: Hi Experts I have a requirement in integration to write the string data in a loop to a file using stage action i.e. append the string data to the file in each l…
-
How to calculate signature in OIC using HMAC sha 256Summary Calculate signature in OIC using HMAC sha 256Content Hi All, In OIC, How to calculate signature using HMAC sha256 Is there any script available in OIC calculate … -
OIC Mapping - Remove end of line from Data from source systemSummary: HI, We have data coming from source system with 'end of line' characters, which is causing the issue in Oracle fusion ERP import process. Is there mapping funct…
-
OIC how to map to payload of type AnyTypeSummary Map to payload of type AnyType in OICContent How do i map to my payload of type AnyType which is considered as a node in OIC. If i use parse xml the tags are rem…
-
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…
-
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…