xml
Discussion List
-
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… -
Email notifiction with HTML bodySummary: Hi I am using below html tag in notification body but getting same content on email . it seems some issue. do i need to mention something in parameter In failur…
-
Dataset to csv in oicSummary: I have the following case: I have an integration that reads data from a BIP report. This report has two datasets that retrieve different data independently. I'm… -
Attaching XML payload to JSON target in XSLT (OIC Mapper)Summary: Attaching XML payload to JSON target in XSLT (OIC Mapper) Content (please ensure you mask any confidential information): I have a requirement where I have to at…
-
XML Response errorSummary: Hi I am trying to configure request response in xml format but getting error. while uploading output.xml file getting error. Content (please ensure you mask any…
-
Cannot assign variable inside "foreach"Summary: Cannot assign variable inside "foreach" Content (please ensure you mask any confidential information): upon trying to assign value of a node from node-set which… -
Parse response wrapper as JSONSummary: Hi, We have an integration in which we are sending some data to a database, the data we want to send is in this format: UPLOAD result for candidateID:…
-
OIC Error in Mapper while uploading to Object StorageSummary: Hi team, I am facing below error in mapper Error during evaluation of XP "ora:doXSLTransformForDoc('resources/processor_824/resourcegroup_827/req_22253bcb45fa45…
-
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…