Mapping
Discussion List
-
How transform application/x-www-form-urlencoded to JSON payload using stage file?Content Hello, An external system invoking OIC with the request content-type application/x-www-form-urlencoded. After decode the reference to string, how do I map to eac… -
Get the node value from a repeted node.Summary I want to get the href value from a payload that have several href in the response. Is there a function to be used on the map operator to get just the first ocur…User_2025-02-05-08-52-13-026 26 views 9 comments 1 point Most recent by User_2025-02-05-08-52-13-026 Integration -
Hanlde dynamic REST response in OICContent Hi Experts, I'm calling the external REST API in OIC which returns the dynamic response as below: Response-1 { "name":"Ankur", "age":1 } Response-2 { "contact":"… -
Configure Trigger REST adapter to accept text/html response bodyContent Hello, I am trying to configure a trigger rest adapter to call an external API that returns a XML text as the response but with the content-type text/html. How s…
-
OIC mapping - XPath expression failureContent Getting back to working on this project after almost a year. Via this forum, Hemanth helped me create parent/child xsd's (attached) for a multi-namespace xml pay…
-
source ID not available in the database record, we have to collect the missing source ID and we haveSummary source ID not available in the database record, we have to collect the missing source ID and we have to send those IDs to the source.via email.Content Hi, I have… -
How to return custom error response from default handlerContent Hi All, I have created an app driven integration for creating a requisition where end user will pass the request payload and in the response i am passing the req…
-
Lookup Table Column in ForEach ActivityContent We don't have any database, so storing list of eligible BU in the lookup with some other fields. I want to use this table column (lets say BU) as ForEach Rowset.… -
How to skip mapping for a particular value in mappingContent Hi All,- I have a one requirement where i have to create requisition using SOAP web-service. The scenario is end user will send supplier item number and i am dir…
-
How to unzip the .iar file using WinZip softwareContent Hi All, After exporting the integration i want the mapping file so that i can edit the mapping the notepd++.How can i unzip the .iar file and get the mapping fil…
-
Assign JSON Array in MapperContent I have a requirement where I need to map JSON array to an object in Mapper. I am attaching the screenshots, please guide if there is any easy way or any workarou…
-
OIC substitution to SOA || Simple and Complex Integration || Oracle Service BusContent Hi team, I have three queries regarding integrations. Firstly, what do we mean by simple and complex integrations? I have seen in many blogs being mentioned that…
-
Parse a file with trailer in OICSummary Parse a file with trailer in OICContent Hello I am trying to parse a file with trailer in OIC. Since the format of the trailer line is different to the other dat… -
Aggregation Using For-Each-Group in MapperSummary Aggregation Using For-Each-Group in MapperContent I have the following data input: AAA Line 1 1000 2020-04-01T00:00:00Z BBB Line 2 100…User_2025-02-06-20-15-08-280 37 views 7 comments 0 points Most recent by Kanchankumar Khedkar Integration
-
How to generate sequence for FBDI in IntegrationSummary How to generate sequence for FBDI in IntegrationContent Hello I am building a Integration in OIC to generate the Payables FBDI from the input txt file. Sequence …
-
FEB2021 Update: Directly Edit Raw XSLT Code in Mapper ConsoleSummary As mentioned on the FEB2021 Update, we can now directly edit Raw XSLT Code in Mapper Console.Content Hello, As part of the FEBRUARY 2021 Update - we can now dire… -
Object(global) of class cannot be converted toContent Hi, While integrating OIA with Oracle database in Oracle Integration Cloud(OIC), as we mapped global(id) of OIA a default parameter to a primary key id of Oracle…
-
Getting a list of errors while Integrating OIA with Oracle DBContent Hello, While integrating OIA with Oracle DB, as we activate the integration and insert values from OIA UI to the Oracle DB to store inside the database, below ar…
-
OIC Reading the file and encoding fails with size ERRORsSummary OIC Reading the file and encoding fails with size ERRORsContent Gurus, We have a integration where we receive the zip file that contains multiple .csv files insi…
-
GET/POST operation to make a REST API put values onto a UIContent What operation should we use in the REST API to put values to a UI , as we are trying to push the values from one component (OIA interview) to (OCE) through OIC.…
-
How to sort records in OICSummary How to sort records comin from source based on a field valueContent Hi Team, We are trying to processing the records after we sort them. We are getting data from…
-
Count nodes after mapping occursSummary Loop over some values and count the number which match a criteriaContent Hi all, Having a hard time trying to figure out how to do this. I have an integration th…
-
To generate a REST API integrating OIC with OIAContent We are trying to integrate an interview of OIA(Oracle Intelligent Advisor) configured as SAVE operation inside OIC where we are trying to post a variable Policy_…
-
To integrate OIA with OICContent We want to integrate OIA with OIC where we are trying to map the input variables (values provided by the user in the OIA interview) and the output variables (com…
-
Simple type deserialization issue while upserting data to Salesforce Custom ObjectSummary Simple type deserialization issue while upserting data to Salesforce Custom Object thorough OICContent Hi Team, We are trying to upsert data from DB to Salesforc…Jagadeesh Kumar Thontapaka 277 views 0 comments 0 points Most recent by Jagadeesh Kumar Thontapaka Integration
-
Mapping an array to the specific fieldsContent Hello! I'm having some issues with a mapping on an integration. This integration will receive an array of properties like this bellow: [{ id : 1, value: a }, { i…User_2025-02-04-13-42-25-344 90 views 2 comments 0 points Most recent by User_2025-02-04-13-42-25-344 Integration
-
How to get inside scope values or connection response in outsideContent Hi, I try to get inside scope values is outside scope integration. Thanks Prakash J
-
REST Adapter for Fusion API doesnt form payload well if it has ""Summary REST Adapter doesnt form payload well if it has "[" & "]"Content We have a requirement where we need to call a fusion Bulk REST API (Role removal API) and see th…
-
Converting date in csv file to format like 2020-11-22T17:00:00.000-08:00Summary Date to string conversion while calling REST APIContent Hi, I have a csv file in 'DD-MON-RRR HH:MI:SS' format which i need to pass to HCM timeRecordEventRequests…
-
Error Writing to Stage File in OICSummary Writing to Stage File Activity throws an Error when all data is filtered out in the Corresponding Map using XSLTContent I have a 'Write-to-Stage-File-Activity ad…