Mapping
Discussion List
-
Rest Receivables invoice attachment with postman OK, with OIC does not work (for me...)Summary: Hello, I would appreciate your help with this issue: I use postman with this payload: https://egyp-test.fa.em3.oraclecloud.com/fscmRestApi/resources/11.13.18.05… -
How to Escape special charters (like space) in query parameters in REST adapterSummary: How to escape special charters (like space) in query parameters in REST adapter. OIC is encoding the value for Space -> + instead of %20 Content (required): Act… -
Need JSON schema for Creating JSON response for successful records via OICSummary:Need JSON schema for Creating JSON response for successful records via OIC Content (required):I have an app driven oic integration that takes in array of employe…
-
First record of stage write is always getting missedSummary: Content (required): I am passing a json as input to my app driven integration. Input [{"name":"ABC","PersonNo":"123"},{"name":"DEF","PersonNo":"456"},{"name":"G…Jaeyshree Kumaran Kalpana 13 views 4 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Integration
-
Ability to keep the integration running when the FTP connection lostSummary: Ability to keep the integration running when the FTP connection lost Content (required): Hello All, My integration uses FTP connection to List, Read, and Move f…
-
What is the best practices of using Lookup in OIC for fetching records?Summary: Need Lookup best practices. Should we create integration specific separate lookup or there should be one common lookup(as key name value pair) to be used across…
-
Stage Action Zip results in Error due to folder does not existSummary Stage Action Zip results in Error due to folder does not existContent Use Case: In OIC, I am Listing the files from SFTP Server and running a loop to fetch a set…Shivakumar Ayyanagowdar-Oracle 335 views 5 comments 0 points Most recent by Oracle PaaS Consultant-Oracle Integration -
Using Number function to increment a Number to 1 Million fails in OIC MapperSummary: We have a requirement where Incrementing a Number beyond 1 Million makes a number be represented in Scientific Notation/Exponential format and not as a number X…Shivakumar Ayyanagowdar-Oracle 213 views 3 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration
-
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:
-
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 858 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… -
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 605 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 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… -
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…