Mapping
Discussion List
-
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… -
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 11 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… -
How to send null to Mapper TargetOIC Version: 21.4.3 Hi Integration Community I have a simple requirement in OIC where a REST web service returning JSON returns an attribute which is a string but may be…David Archbold-175837 1.4K views 9 comments 1 point Most recent by David Archbold-175837 Integration
-
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…
-
Translation to native failed. Element 'EnteredDebitAmount' not expected..Hi Expert, I am creating integration for bulk data import to journal import, while running integration getting following error. Error Summary: oracle.fabric.common.Fabri…
-
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…