Mapping
Discussion List
-
Integration attempts to check filesize but errorsSummary: Simple Integration lists file on FTP server, then for each file I check whether file is less than 4000 bytes or its extension is 'TXT'. If TRUE then I move to a… -
Value is not getting reassigned in For eachSummary: Value is not getting reassigned in For each Content (required): I am reading a file using Read File in Segments and using a for each to iterate the records of R…
-
perfomance difference between nested for each loops vs. XSLT with single loopSummary: i have working integration with 3 nested loops (result sets, rows, fields) that looks bulky in OIC. 2 outer loops have no actions beside narrowing xml elements … -
how to map element for given attribute in OIC mapperSummary: is there simple way to map XML element for given attribute value without using XSLT Content (required): for example payload has following structure: 123 abc …
-
Date & Time FormatHi, Due to some field limitation, we are using text field in Target system and source is Date & Time type. Both fields are in Fusion modules (Sales & Work Order). Is the… -
ReadFileinSegments throwing errorSummary: Content (required):Im downloading report data using downloadReportDataChunk operation. After that i use a stage write with opaque schema. Both these operations …
-
Incase of change in WSDL request type( few fields added).. how the mapper will get reflectedSummary: Suppose, there is complex mapping defined for the SOAP service in OIC( which is having huge request payload elements) and there is a requirement to add one new …Narasimha Reddy Chetibottu 11 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
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… -
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,…
-
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…
-
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…
-
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 …