Mapping
Discussion List
-
We need to sort an array of fields in OIC by the most recent last updated date.Summary: We need to sort an array of fields in OIC by the most recent last updated date (in timestamp format), eliminate duplicate values, and retrieve the unique record… -
Maximum limit reached js expression oicSummary: We are getting maximum limit reached when executing a custom JavaScript library function as part of our oic integration flow in OIC 3. We understand that there …Abhilash K - Deloitte USI 22 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Integration -
how to make OTBI to take semi colon (;) separated string as multiple parametersSummary: I am calling OTBI report using SAWSESSIONSERVICE from OIC. when I pass multiple parameters into OTBI through the OIC mapper its not generating output. Content (… -
Import Journal Cloud ERP mapping is failing with the error for debit and credit amountSummary: We are facing the below error for all the transactions however, the same data is getting processed from SOAP UI application.Any pointers are highly appreciated.…
-
Read excel file with multiple tabSummary: Hi I want to read excel file which having multiple tab. For E.g Excel having 3 tab name like A,B and C. I want to read B tab. How we can achieve this. Content (…
-
encodeReferenceToBase64 function failing files more than 10 BM filesSummary encodeReferenceToBase64 function failing files more than 10 BM filesContent Quite important requirement as files should be encoded base 64 and pass to other serv…
-
OAUth connection issue in PostmanSummary: Hi I am trying to call integration using O auth but it is failing. Content (please ensure you mask any confidential information): Version (include the version y…
-
How to fetch Child link output in REST APISummary: Hi I am getting below response in ds node. In that File location tag , attachment link in there and i need output of that. I was assigning file location to next…
-
Error in stage file activitySummary: Hi Getting below error, while reading file. Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…
-
format-date time function is not working in Gen3?Summary: Trying to format date time from 2025-03-10T05:09:05.049+00:00 to 10-Mar-2025 but its giving blank. xp20:format-dateTime(2025-03-10:09:05.049+00:00,‘[D01]–[MNn,3…
-
REST API failing with "415 Unsupported Media Type"Summary: Hi I am trying to run REST API in postman but it failing REST API - /fscmRestApi/resources/11.13.18.05/contracts/{contractsUniqID}/action/submitForApproval Cont…
-
OIC REST - how to save xml payload to ATP clob column opaquelySummary OIC REST - how to save xml payload to ATP clob column opaquelyContent I am trying to build a simple REST integration that when called from Postman with an xml pa…
-
How to fetch href linkSummary: hi I want Response from href link in next node. How we can get it. For e.g I am getting subinventory response using below rest api /fscmRestApi/resources/11.13.…
-
DeFault handler is disabled in OIC gen3Summary: Hi Need to understand why Default handler is disabled . Content (please ensure you mask any confidential information): Version (include the version you are usin…
-
How to get the hostname of VBCS and OPA instance linked to OIC at runtime in mapperSummary: Hi Experts We are using Oracle Integration 3, i have a requirement to give the link to VBCS page at runtime and also for OPA instance (Process automation). I co…
-
File Reference Retention in OICSummary: File Reference in OIC - Retention Details Content (please ensure you mask any confidential information): Hi, I am trying to get more details how a file/stream r… -
How to create a switch to check for nullSummary: I need help figuring out how Oracle is built to handle nulls in switch and xslt logic. Content (please ensure you mask any confidential information): I have an …
-
How to Update AwardHeaderDFF in OIC mapper if DFFs are not showing in ERP AdapterSummary: Hello, I am new to using OIC and cannot figure out how OIC expects me to feed it the data it needs in order to update the DFFs that are configured on the Award …
-
OIC Mapper does not handle non-ASCII7 characters in elememt names wellSummary: The mapper in OIC does not handle element names from JSON or XML that contain accented characters. Content (please ensure you mask any confidential information)… -
Unable to find auto-mapping suggestions in OIC(Oracle Integration Cloud) mapper Gen 3?Summary: I am trying to Develop a Integration Invoking B2B and in mapper I was expecting auto mapping recommendation. Usually i used to get in OIC Gen 2 But i am unable …
-
How to calculate signature in OIC using HMAC sha 256Summary Calculate signature in OIC using HMAC sha 256Content Hi All, In OIC, How to calculate signature using HMAC sha256 Is there any script available in OIC calculate … -
The attribute INVENTORY_ITEM_ID is missing for service getProductRelationShipContent Hi Experts, I'm trying to execute the "Oracle Salesforce ERP Opportunity to Order" recipe and getting below error: The attribute INVENTORY_ITEM_ID is missing for… -
OIC Mapping - Remove end of line from Data from source systemSummary: HI, We have data coming from source system with 'end of line' characters, which is causing the issue in Oracle fusion ERP import process. Is there mapping funct…
-
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…
-
Add Image in the OIC email NotificationSummary: Hi I want to add image in the OIC email notification body part. Please suggest. Content (please ensure you mask any confidential information): Version (include …
-
OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQLSummary: OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQL Content (required): Hello All, I am facing this issue in the screenshot when I use TO_DATE …
-
How to create Multiple line from singleSummary: Hi I want to create 2 line from one line request payload. basically i am looking 2nd line with same information like LineNumber=1. 2 8128
-
Not getting the data in response after mapping the filed for rest adaptor in OICI have created a rest adaptor to get the transmission report data from OTM . I have tested it first via postman . below is the request and response : Request : Transmi…
-
XSLT to find elements whose total is equal to a target valueSummary: I have an xml in the following format and a target value. a 10 b 15 c 25 I need to find all the elements whose value is equal or less than the target va…
-
BI report Pdf Output in email notification attachmentSummary: Hi How to send BI report(pdf format) in OIC email notification attachment. Content (please ensure you mask any confidential information): Version (include the v…