Mapping
Discussion List
-
FileReference:How to get the contents of a file from a loop and insert them into a tableSummary: Content (required): Hi everyone, I am building an integration which downloads a .zip file I am only interested in getting an .xml file the flow is able to recog… -
OIC FTP adapter - erroing out with UTF-8-BOM encoding. Any workaround?Summary: OIC FTP adapter erroring out when the xml file is of UTF-8-BOM encoding. Works well when its UTF-8. Content (required): We have an issue while reading an invoic…
-
XSLT solution to select from 1st source only nodes NOT present in 2nd sourceSummary: Have simple case where 2 XML sources are processed in a way where nodes from 1st xml file are excluded if they already part of 2nd xml file Brute force approach… -
How to skip a row based on particular value in OIC mapper.Summary: How to skip a row based on particular value in OIC mapper. Content (required): Hi Expert, I want to skip a particular row based on filter condition.Let say for … -
For each in mapper causing translation issuesIn the FTP process in the mapper if we put a for-each loop to append multiple lines to the csv file it errors out with the error:- --------------------------------------…
-
SOAP trigger value not accessible inside IntegrationSummary: I have an App driven integration with SOAP trigger where value is received using a soap payload. When i try to assign that value anywhere throughout the integra…
-
How to Write Excel file using stage activitySummary: How to Write Excel file using stage activity Content (required): Hi Expert, I am extracting the data from the database and then i am writing the data using stag…
-
Is it possible to send the payload that the OIC received to a external systemSummary: We are currently developing a integration that needs to send the payload received in the integration. This should dynamic as it would be used in more then one i… -
Issue while using scheduleReport SOAP Operation of ScheduleReportWSSServiceSummary Issue while using scheduleReport SOAP Operation of ScheduleReportWSSService from OICContent In OIC, we have configured a SOAP Connection with WSDL URL: https:///…
-
Namespace Issue while using getScheduledReportOutputInfo SOAP Operation of ScheduleReportWSSServiceSummary Namespace Issue while using getScheduledReportOutputInfo SOAP Operation of ScheduleReportWSSServiceContent Issue with getScheduledReportOutputInfo SOAP Operation…Shivakumar Ayyanagowdar-Oracle 745 views 7 comments 0 points Most recent by User_2025-03-07-05-44-16-607 Integration -
How to convert date into YYYY-MM-DDSummary: How to convert date 28-FEB-23(DD-MM-YY) into YYYY-MM-DD Content (required): Hi Expert, We are receiving the date like 28-FEB-23 from client ,Now we want to stor…
-
Customer specific ASN creationSummary: Hello Wizards, have you implemented customer specific ASN, real time data exchange (EDI) with 3PLs, Freight Forwarders and Suppliers. Content (required): Hello …Vishnuvarth Subramanian-Oracle 14 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Integration
-
Handle empty csv file with headerHi All We have an integration reading a csv file and which goes on and creates HDL for loading data into HCM. Currently we are facing an issue when an empty csv file whi… -
PLSQL arrays and Integration CloudHi All I have an xml array posting to a plsql table and record and that works fine. But I want to set up a GET to return that plsql table into an XML array. The error I …
-
Matching against values in valuesetWe have a requirement where we have to retrieve a certain valueset values from Oracle SAAS. Retrieve values from a 3rd party application. Match these values against thos…
-
Stage File Actions - List Files and zip file is having issue.Summary: List File payload dont have the data and zip file action is going into error. Content (required): I am creating a HDL integration. I create .dat file using FTP … -
For Each on distinct valuesSummary: Content (required): Hi All, Is there a way to use For Each on distinct/unique values ? I see that there is no way to edit the input of For Each... Version (incl… -
How to use group by for more than one elementSummary: How to use group by for more than one element Content (required): Hi Expert, I am trying to get unique record and for that i want to group by two element .Below…
-
For each current indexSummary: Content (required): How can I get the current index of a for each loop (in the diagram, not xslt)? Thanks Version (include the version you are using, if applica…
-
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 16 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…