Mapping
Discussion List
-
Number sequences in OICSummary Is it possible to control a number sequence in OIC?Content The integration receives some XML data and must create a fixed-length text file in the destination (FT…
-
JavaScript library function for xpathSummary Unable to activate integration with javascript library function for xpathContent It works if the same function is used for orchestration. Version 19.4.2.0.0 (191…
-
Working with timezones in OICSummary Working with timezones in OICContent From the integration source, I receive two data: 1) A "datetime" in YYYYMMDDHHMISS format and a timezone (like "America/Los_…
-
Overwrite record in MapperContent Hi Team, I have been trying to figure out a way for the below logic: I have a file, which has records like below: 000PAM222604659MOWBRAY, SWATHY 101456 050 20191…
-
Map with ForEach Error executing XSLContent Hi experts, I have an input with two sets of records: "DadosCondutor" and "ServicosConsulta". I want to map DadosCondutor to Condutor. In DadosCondutor there is …
-
Mapping from hierarchical data text file to XMLContent Hello, community. I've just got this really hard integration task. I have a text with the following content: 1,00422,1,Pen,103,4,across the street3,6,across the …
-
skip record in for-each present in mapperContent I have write adapter in which I have for-each loop for two levels(1. for-each of assignments, 1.a. for each of Global_Card_Components_State). The Global_Card_Com…
-
Read File in Segments to REST Service insert to ATP databaseSummary Read File in Segments to REST Service insert to database results in all rows written in each segment readContent I have a very large file to import to my integra…
-
Perform On Table - Select operation is not working as expectedSummary Perform On Table - Select operation is not working as expectedContent Hi , I am trying to fetch data from two tables. I am doing it with "Perform operation on ta…
-
Map html to REST including tagsSummary When trying to map attributes containing html formating the tags are just removed by OIC.Content We are trying to implement an integration between DB-AQ and a Or…
-
Generate unique number while reading in segmentsSummary How to generate a unique number in the xslt while reading the file using segment read from stageContent Hi, I am reading an invoice file using the AIC stage read…
-
Attachment service 'ErpObjectAttachmentService' attaching Invoice PDF Twice in OICSummary Attachment service attaching the InvoiceImage Twice using OIC for few invoicesContent Hi All, We are using the 'ErpObjectAttachmentService' service to upload the…
-
Get child text from an xml element in a mappingContent Implementing the suggestion in this topic - Include mapped output as the value of another output..., I need to get the text content of an XML node returned from …
-
Date Conversion errorSummary Getting type/cast error when calculating Date 30 days before.Content Hi - trying to get date 30 days before but getting error FORG0001: invalid value for cast/co…
-
DateTime Issues : DD-MON-RRRRContent Hi All, My requirement is to format the input date and subtract one day from the given date. The requirement sounds simple but the date is not getting formatted.…
-
Convert comma-delimited String to XML NodeContent Hi, I am trying to convert an input variable which contains comma-delimited string values into an XML nodeset using oraext:create-nodeset-from-delimited-string a…
-
OIC - handling nested Json array is failing when internal array is emptySummary OIC - handling nested Json array is failing when internal array is emptyContent Hi, I have a service provider response that should be mapped as-is to the OIC int…
-
How to convert/transform a simple csv file into FBDI template with master-detail data?Summary How to convert/transform a simple csv file into FBDI template with master-detail data?Content Hi Everyone, I'm using FBDI template for Account Receivables - Auto…Karthick Rajarathinam 18 views 2 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Integration
-
FTP Adapter - Master Detail CSV File - Unable to IDENTIFY master detail informationSummary FTP Adapter - Master Detail CSV File - Unable to IDENTIFY master detail informationContent Hi Everyone, Scenario- CSV placed in FTP location in the below format.…
-
Write JSON File to FTP in ICSSummary Write JSON Response from HCM to FTP Json FileContent Hi I have a scenario where I am receiving JSON payload from HCM rest api. I need to transform and write a JS…
-
Fixed Length to CSV conversionSummary File ConversionContent Hi Team, I am trying to convert Fixed length file to CSV The issue i am facing is: Some of the data lines in the fixed length file don't h…
-
OIC Email Notification - Dynamic HTML tableSummary How to send email notification with dynamic HTML table. The number of rows in table will vary.Content I have a requirement where i need to send email notificatio…
-
What's the difference of "For Each" action and adding for-each during mappingContent Hi experts, In integration we are reading one file which has multiple lines, after that we want to call a DB procedure for each line(line value as input paramete…
-
Order by array variableSummary Order by array variableContent Hello, We have a webservice that returns an array for us with two dimensions “Name and Sequence”. I need to sort this array by the…
-
Are business event available to capture customer account creation/update?Summary Are business event available to capture customer account creation/update?Content Hi Everyone, I'm looking for a business event that triggers when a (Trading Comm…
-
Multiple line within a single mapping elementContent I have used the below wsdl to generate scheduled report from fusion; WSDL: http://:/xmlpserver/services/v2/ScheduleService?wsdl The request mapper for the above …
-
How to load overtime information into Oracle HCM?Summary How to load overtime information into Oracle HCM?Content Hi Everyone, I have a requirement to load overtime information of an employee from a 3rd party system to…
-
How to run a integration by clicking a single url/linkContent Requirement: I want to send the url of integration in a mail notification. On click of that url, the integration should be triggered in OIC. I initially used the…
-
Array variable OIC (ICS)Summary Array variable OIC (ICS)Content Hello, We have a "foreach integration" and I would like to create an array variable with the result of that integration. After th…
-
Subtraction functionContent Hi, Requirement: I want to subtract two value from various response and show in the final response. Problem: One value coming as string, so I tried to convert as…Mohana Gopal Selvam-Oracle 16 views 12 comments 1 point Most recent by Mohana Gopal Selvam-Oracle Integration