Mapping
Discussion List
-
Read ByteArray in OICSummary: I have REST API which gives CSV data as ByteArray. In OIC we are calling API and setting response as Binary. I want to pass the data to stage file. Can someone … -
Need ical expression to schedule integration daily 4 timesSummary: Hi All, I need ical expression to schedule integration daily at 10am,1 pm, 5 pm,11 pm EST time. Content (please ensure you mask any confidential information): V… -
"Recommend" OIC featureSummary: Please, can someone give a light on this. I started learning OIC some 3 years ago, and the "Recommend" feature seemed to work, I mean for some common mappings, … -
Append select dataSummary: Hi I am getting AP line data from SQL Query1 and based on condition need to merge SQL Query2 AP line data into SQL query 1 . Then need to Send AP line data to A…
-
Efficiently Handling DB Insert/Update Activity in OIC w/ No Response PayloadSummary DB Insert/Update Operations in OIC don't have a RESPONSE Payload confirming if the operation successfully applied to the DB, requiring special handling.Content H…User_2025-02-07-23-59-52-354 226 views 5 comments 0 points Most recent by Biman Dey Sarkar-Oracle Integration -
How to subtract timestamp variables?How to subtract one timestamp variable (HH:MM:SS) from another timestamp variable to capture a result providing the difference? -
Can I process data in bulk using SOAP webserviceSummary: Processing Multiple sets of records in one go using SOAP Webservice. Content (please ensure you mask any confidential information): We have a requirement where …
-
Map html to REST including tagsSummary When trying to map attributes containing html formating the tags are just removed by OIC.Content We are trying to implement an integration between DB-AQ and a Or…
-
BI Report read issue in OICSummary: When i am trying to read BI Report in oic using stage activity but getting error . attached xsd file for reference. Content (please ensure you mask any confiden…
-
Attaching PDFs to Multiple InvoicesSummary: Content (please ensure you mask any confidential information): Hi all, I am attempting to attach PDFs to multiple invoices (a one to one). The way things are se… -
what is the diference google maps and herein mexico city company izzi we have the new 24A in development but we don't see any diference between google masp and here in the documentation shows a map with some blu…juan alberto medina 51 views 1 comment 1 point Most recent by Eduardo Kimura-Support-Oracle Field Service
-
' value coming in mappingSummary: Hi While Assigning business unit value , i am getting extra character like "'" in it. How to handle this ? Content (please ensure you mask any confidential…
-
Update null value to a table column not working with ATP connectionSummary: Hi Team I'm using ATP connection to update the column value to null, but passing null here is not updating existing value in the table column. How to update any…
-
How to get the UniqId to pass it as a parameter in OICHow to get this UniqId and pass it to the URI e.g., we need the gradeUniqId to pass it to the following endpoint: /hcmRestApi/resources/11.13.18.05/grades/{gradesUniqID}…
-
how to fetch specific stringSummary: Hi I want to fetch specific string from given string. Whatever value is present in "()" that need to be fetched. Industrial Minerals Company (IMC) ---> IMC Ma'd…
-
List files OIC not workingSummary: NA Content (required): Hi Team, We were trying to list the files from a FTP server which is on Port 21 and observed that List files is not working and it is not…
-
Can we modify the default encoding xml declaration while writing a file to stage operation?Summary: I want to write a file with below output - instead of . Can this be done in xslt or OIC? I have tried but this didnt work. Any suggestions would be helpful. T… -
Request mor info , Reassign PCS version 3Summary: In oracle PCS version 3 , in case of taking action like request more info or reassign , how to get who will be the assign to take action or provide more info , …
-
HCM adapter Flow patterns submit flow operation how to pass parameter values in integration mappingSummary: Hi Experts I want to use Fusion HCM rest API to run the "Make EFT Payments" payroll process with integration using HCM adapter but i'm not getting how to pass t…
-
How can I get column name for Attribute in AIF_TARGET_APPL_MEMBERS table.I need to extract Attribute details of entity dimension in a column while exporting data. I am able to extract details of Alias (or parent name using PARENT_NAME instead… -
Passing the date range as a parameter while calling the SQL statement in OICSummary: I need to pass the sysdate-1 to sysdate as a parameter while calling the SQL statement from DBCS at mapping level in OIC.Please help to use proper available fun…
-
How to read a record type file in OIC?Summary: We are trying to read a file which is a fixed length file, but file has multiple record types. For e.g., file contains a header and multiple detail lines with d…
-
OTBI Report to VBCS Rest Endpoint **SOLVED**Summary Extracted OTBI Report - map to POST to store in VBCS Business ObjectContent Hello, I've successfully extracted the contents of an OTBI Report from our ERP Cloud … -
Locate Nearby Resources - Not working as expectedWe have examples of field resources utilising the Locate Nearby Resources functionality and the returned data is not as expected. We see "no results shown" or random fie…
-
how to retrieve deleted activity ?Summary:the activity was deleted by mistake and we need to retriew it , how can we do it ? Content (please ensure you mask any confidential information): Version (includ…Ramesh S-Oracle 31 views 2 comments 0 points Most recent by Anastasiia Semenova-Oracle Field Service -
OIC- Map empty json sub-node set to csvHi, I have the requirement to map input json data to csv output. In the input data we have Courses and for each course, we have a liste of existing sessions planned for …
-
How to use encodebase64reference function for more than 10 mb dataSummary: How to use encodebase64reference function for more than 10 mb data Content (please ensure you mask any confidential information): Hi experts, I am facing an iss…
-
How to handle Source Null value in MapperSummary: Hi If i don't have any value in Expiry date column from source side then I want to remove this element from payload. How can we achieve this ? Content (please e…
-
TRANSLATION-ERROR-01# exception occurred while translating the response into the accepted media typeSummary: Hi While creating sample OIC i am getting below error. I am simply doing division of 2 numbers . please find screenshot for reference. { "type" : "10.5.3", "tit…
-
2OCI Data Integration pulling data increments using BI PublisherOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Mastek Description (Required): I am f…Jaydev1993 11 views 1 comment 2 points Most recent by Anjali Devi Jampala-Oracle Idea Lab – Integration Cloud