Mapping
Discussion List
-
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…
-
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…
-
Java file issueSummary: hi I am trying to upload a JavaScript file to OIC Library, but it prompts: "Failed to create Library. Unable to parse function formatNumber(num,locale="en-US",d…
-
convert BI report Email address into stringSummary: Hi We are getting email address in BI report and we need to send email to these email address in one email. Please suggest how we can achieve this. Content (ple…
-
Unable to see DFF within OIC flow as an Input SourceUsing SOAP service CustomerAccountService operation findCustomerAccount to retrieve DFF value. It is returned in the response payload but not accessible within OIC as an…
-
How to do application/x-www-form-urlencoded request in OIC rest adapterSummary How to do application/x-www-form-urlencoded request in OIC rest adapterContent Hi all, In POSTMAN, I can able to get a response using Body as x-www-form-urlencod…
-
Upload Document OPA REST API with Multipart/Form-DataSummary: I have made an Integration in OIC, which capture data from my PaaS Tables. Attachments are uploaded as BLOB, and my integration has extracted those BLOBS from P…
-
Oracle Integration Cloud 3: For-each repeating element is read onlySummary: Am I missing something obvious? When configuring a for-each loop in OIC 3, the field to configure a repeating element is read-only so I can't pass it any values… -
Extract fields from XML responseSummary: In OIC i'm receiving a BI Report that has xml data in it (i added a sample response as an attachment). I need to access the individual Columns out of the Row ar…
-
Use round function to rounding to 2 decimal placesSummary: Use round function to rounding to 2 decimal places Content (please ensure you mask any confidential information): Hi experts, I working in data maping but I nee…
-
Can we send encrypted file as an attachment in the notificationSummary: Can we send encrypted file as an attachment in the notification Content (please ensure you mask any confidential information): Can we send encrypted file as an …