Mapping
Discussion List
-
How to read a file from 4th lineSummary: How to read a file from 4th line Content (required): Hello Expert, we are getting CSV a file where the header is in 4th row and data is starts from 5th row.Now … -
Add line break in XML fileSummary: Content (required): Hi experts, I am working on an integration which will generate an xml file, my schema is as follows:
-
need help to understand xpath error -OICSummary: Hi Guys. I am geting this xpath error, however I have no Idea how to "bebug" it. Content (required): Version (include the version you are using, if applicable):… -
How to pass null value for LOV field in OIC mapper. How to remove tag from payload if its nullSummary: How to pass null value for LOV field in OIC mapper. How to remove tag from payload if its null Content (required): I am trying to update list of 9 DFFs via REST…Jaeyshree Kumaran Kalpana 3 views 3 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Integration
-
Extract Data from SaaS to VBCS ApplicationSummary Extract Data using an OTBI ReportContent Hello, I have a requirement to retrieve data from our Oracle ERP Cloud applications. I need to extract the data via an O… -
ERP Adapter issueSummary Error: The application has encountered an unexpected error. Please check the applications connection details, credentials and retry your request.Content I'm tryi…
-
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… -
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 1 view 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…
-
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 …