Mapping
Discussion List
-
Updating child element of Repeating(Unbounded) element in GlobalVariable using stitchSummary: Hello, I have a requirement where I am receiving and processing a JSON payload in OIC. The payload has multiple child elements and a few of them are repeating c… -
How to concat a repeating element valueSummary: I have to build an integration.We send a request and we get an XML response.We are consuming the message from the outbound queue.Attaching the XML message.I wan…
-
How to return a array from a javascript functionSummary: Hi guys! I writed a code to return a array from a javascritp code (see an exemple below). However when I map the resoult in my payload, I get the array as an co… -
6Be able to return an array from javascript functionOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Accenture Description (Required): I w…Rodrigo L Sartorato 52 views 0 comments 6 points Started by Rodrigo L Sartorato Idea Lab – Integration Cloud
-
Remove empty elements via XSLSummary Remove empty elements via XSLContent Hello! Has anyone tried to remove/scrub empty elements via XSL in OIC? We already placed conditional mapping for each elemen…
-
Flat File ReadingSummary: I have one requirement as mentioned to read in the ATP database in two tables. What are the best possible ways to read the file considering it to be more than 1…
-
How to avoid concatenationSummary: Hi, Source has one or more records, but Target accept single record only. I just drag and drop the source field to target field. Since I mapped the repeated ele… -
Pass JSON payload as-is without OIC Mapper to SaaS REST APISummary: Content (required): Is there any way we can form a JSON payload and pass that payload as-is without mapping each element from left to right? Version (include th… -
Assign variable mapped to a tag thats not generated in REST API response throws errorSummary Assign variable mapped to a tag thats not generated in REST API response throws errorContent I have mapped rest api response to variable "Payroll". The tag(Payro…
-
How to add padding in OICSummary How to add padding in OICContent Consider my value is 5. I want to add left padding. The length should be 9. The expected output is 000000005.
-
OIC Error message handling to remove line breaks, carriage return etc and replace with spaceSummary OIC Error message handling to remove line breaks, carriage return etc and replace with spaceContent Hi Team, We want to create an error report as a pipe-delimite…
-
How to consume business events outside OICContent Hi All, Is it possible to consume SAAS business events outside OIC. Please let me know the other options to consume business events. Thanks Harish
-
Insert into multiple ATP tables from OICSummary Insert into multiple ATP tables from OICContent HI All As part of the integration we are fetching xml data from HCM which need to parsed and enriched to create t… -
Run BI report >10MB in OICSummary Run BI report >10MB in OICContent I am trying to run a report from Oracle BI using OIC. I am using runreport method of Reportservice (https://****.xx.us2.oraclec…
-
How to read Data from .pdf filesContent Hi Team, we have a requirement to read data from .pdf files .Is it possible in OIC and if not the what are the other way to read the data from .pdf file. Thanks,…
-
Difference between Appointment, Work Order and Activity in Oracle Field Service CloudContent Hello, Can you please let me know the difference between Appointment, Work Order and Activity in Oracle Field Service Cloud? I have checked with few experts in t…
-
Unable to email the attachment i am getting in response message in OICSummary I am not sure what mapper should i used to email the attachment i am getting as a response XSD payloadContent Hi, I am trying to get the response payload which c…
-
OIC - How to invoke BIP ws and read output dataSummary How to invoke BIP web service and parse/read the output in OIC?Content Hi everyone, How to invoke BIP web service and parse/read the output and share the parsed …
-
Data Masking Feature in OICSummary Data Masking for Sensitive DataContent Hi folks, Is it possible to perform data masking for sensitive data in OIC? Maybe something similar like this feature whic…User_2025-02-06-10-44-24-377 45 views 2 comments 1 point Most recent by User_2025-02-06-10-44-24-377 Integration -
Read excel file in OICSummary We have a requirement, where we want to read Excel file in OIC and call a web-service to refer this dataContent Hi, We have a requirement where excel file is giv…
-
Write Limit of stage fileContent Hi All, I am pulling data from DB (By select and it can have less than or equal to 10k data) and i am writing into stage file. My question is what is the limit t…
-
0Common Capability for Assign, Stitch and MapOrganization Name OVODescription Currently in OIC there are 3 different ways to map data elements, either using Assign, Stitch or Map. They are all effectively doing the…
-
Need Solution to read fbdi format file from UCM , transform in OIC to FBDI format and invoke ESSSummary Need Solution to read fbdi format file from UCM , transform in OIC to FBDI format and invoke ESS jobContent Need pointers for the integration road map for manual…
-
callback integration failingContent Hi All, I am getting below error in call back integration .please tell me what is the reason of this error Error Summary: ICS runtime execution encountered {http…
-
How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB TableContent How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB Table? Please advise if anyone has any pointers/blogposts/solution in transform…Shivakumar Ayyanagowdar-Oracle 16 views 4 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration -
Do we have possibility to read and write an excel file in OICSummary Do we have possibility to read and write an excel file in OICContent We have 2 requirements: 1. To read an excel file, process the data 2.To write an excel file …
-
How to send response from global faultContent Hi All, I have build a one app driven integration where in the trigger rest connection i have provided the request and response payload.If some thing error occur…
-
Convert Comma Separated into OR delimiterSummary Convert Comma Separated into OR delimiterContent Hi, I am currently doing a logic on changing the data format from: "listOfAccountNumbers" : "0000001, 000002, 00…
-
Using lookup-xml in integrationsContent Hi, I've been trying to implement a solution which needs to join data from two different files. File A contains business data and File B(xml) contains reference …
-
How to lookup a value in one xml based upon some key in another xml in ICSSummary looking for example to use lookup-xml functionContent Hi ICS community, We would like to lookup a value from one xml (response received from a REST call) based u…