Mapping
Discussion List
-
Turn a Comma Separated string into multiple parametersSummary: I have an API that takes 1 or more query parameters called base. These appear in the URL as ?base=GBP?base=USD?base=EUR for example. I want my integration to ta…Scott Hillier Accelalpha 36 views 7 comments 0 points Most recent by Scott Hillier Accelalpha Integration -
Data got corrupted while processing through stage file segments actionHello All, Using Opaque schema we are converting the BIP encoded file into text data and storing in memory using stage file action. We are reading using stage file - rea… -
Convert CSV string to Array in Mapping - create-nodeset-from-delimited-string ?Summary: I've got an API which requires an array of string into a parameter called base. I want to use a Comma Separated Value passed into my integration which I convert…Scott Hillier Accelalpha 21 views 3 comments 0 points Most recent by Scott Hillier Accelalpha Integration
-
Excluding whole rows from being staged based on certain criteria - mapper?Summary: In OIC Gen 3 I have the response from an API call being mapped directly to a stage file write. So ALL the rows returned are immediately written. I want to exclu…
-
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… -
How to map optional nested Substitutes data to parent Components using XSLT reliably?Summary: I am working on an event-driven integration scenario with a multi-level hierarchical payload. The structure consists of Item Structure(Non-repeating Parent), Co… -
Where should we create or maintain common lookup valuesSummary: We have a requirement to derive invoice approvers based on Cost center and BU value. Cost Center (CC) is available on invoice but BU is not. Currently CC and BU…
-
Issue with passing empty array to JSON in mapperSummary: Hi Community, I have a requirement to pass the empty array to JSON message which is published to KAFKA. Source is xml which has hierarchical data and when an ar…
-
Schedule Parameter not taking Default value in OICSummary: Schedule Parameter not taking the Default value in OIC Content (please ensure you mask any confidential information): Hi All, I have scheduled the integration w…
-
XSLT Filtering not workingSummary: I have 2 arrays and I'm trying to apply in line mapping filter but is not working, is there a reason? We are trying to build a "lookup" read. Content (please en… -
Email notifiction with HTML bodySummary: Hi I am using below html tag in notification body but getting same content on email . it seems some issue. do i need to mention something in parameter In failur…
-
Why is noone mentioning having to recreate mappings when upgrading to Gen 3?When upgrading from Gen 2 to Gen 3 it is fairly well known that the Instance ID goes from being a Number to a Char value. If you are using the Instance ID in a mapping, …
-
How to view the notification content in OIC gen3Summary: How to view the notification content in OIC gen3 Content (please ensure you mask any confidential information): Hi All, In OIC Gen2, we were able to view the no…
-
csv Headers not showing - File Adapter - IOCSummary When I write csv files using File Adapter the headers are not showing.Content Hi All, I'm using file adapter to write CSV files. However I can't make it write th…
-
What actions do not support Parallel and why does it behave this way?Summary: I've noticed that I can't use temporary files within a parallel thread. Can you tell me why Oracle might not have considered this option? Can you also help me b… -
Attaching XML payload to JSON target in XSLT (OIC Mapper)Summary: Attaching XML payload to JSON target in XSLT (OIC Mapper) Content (please ensure you mask any confidential information): I have a requirement where I have to at…
-
Integration Activation FailedSummary: Hi While activating integration it got failed. Content (please ensure you mask any confidential information): Version (include the version you are using, if app…
-
Table Trigger event IntegrationSummary: As soon as Supply registration entry is created in the system, can we send any notification via OIC? Basically Once data is inserted in the fusion table#POZ_SUP…
-
Need BI report responseSummary: I need BI report response. Response mapper is outside scope. Not able to see stage file response outside response mapper. How i can map stage file BI report res…
-
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 (…
-
Parse response wrapper as JSONSummary: Hi, We have an integration in which we are sending some data to a database, the data we want to send is in this format: UPLOAD result for candidateID:…
-
How to update Integration response in SaasSummary: Hi I am calling integration from VBCS page and we are getting response from the integration . Now we need to use this response to update few columns in Saas? Re…
-
How to Map Array of String Objects in OIC Integration FlowSummary: Hi Community, I’m seeking guidance from OIC experts regarding a mapping challenge I’ve encountered. If anyone has faced a similar requirement, I’d appreciate yo… -
Run Integration from postmanSummary: Hi I am trying to run Integration from postman. Here i have given trigger connection details. While running from postman i am giving Oauth details . ALso able t…
-
XPath expression failed to execute Error during evaluation of XPath "ora:doXSLTransformForDocHello Friends, I am getting an xpath error while mapping xml string using parseXML(TOInputPayload) function to stage file Below is code snippet from code view of OIC Map…
-
Convert a delimited string to an iterable object and perform actions for each valueSummary: How can I iterate through values in a delimited string using a "For Each" action in OIC when createnodesetfromdelimitedstring isn't working as expected? Content… -
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…
-
How to map two arrays to one target with repeating childrenSummary: Does anyone know if it is possible to join two json files together in OIC? I have to report the ID and projectID in one response payload back to target system, …
-
OIC to Amazon S3 IntegrationSummary Fetching and Placing files in S3 buckets using OIC integrationContent Hi , We have a requirement where we need to fetch files from Amazon S3 buckets. We followed…
-
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 (…