Mapping
Discussion List
-
Issue trying to read XML with multiple namespacesHi, I have an integration that is querying a binary file from Oracle Fusion to get PO Document, however, the response is an XML with multiple namespaces that I can't rea… -
BI Report Permission issue in OICSummary: Hi I am trying to run BI Report from OIC but getting below error . Also i have checked using same user#oic_intg_user in fusion , able to run the report. Please …
-
How to filter data on expand query parameter level in REST APISummary: Hi I want to filter data on expand query parameter level. I have attached Postman screenshot is for your reference. Also Payload response for your reference. I …
-
How to Convert string to date in mapperSummary: I want to convert the input string into date format Content (please ensure you mask any confidential information): 19-APR-24 is my input string. I want to conve…
-
Incrementing Variable value in XSLTSummary: Hello Team, I have a requirement in XSLT where I need to keep on incrementing the value of counter variable by 1 whenever any of the for each loop execution is …
-
Issue while trying to update using ATP adapter using the option "Run Sql Statement"Summary: Unable to use update query in Run Sql Statement option under ATP adapter Content (please ensure you mask any confidential information): I selected the Run Sql S…Jaeyshree Kumaran Kalpana 14 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
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…
-
time comparisonSummary: How can I compare two times in an OIC 3 flow. Content (please ensure you mask any confidential information): I want to receive an access token, make a variable … -
DBCS Table import issueSummary: While importing DBCS table , getting below error. Content (please ensure you mask any confidential information): Version (include the version you are using, if …
-
What is the maximum volume or file size supported by concur adapter in OIC?We want to integrate to Concur and want to export the expense reports from concur and load them as payable invoice in Oracle cloud. What will be the volume or file size …
-
OIC: Skipping Scope executionSummary: OIC: Skipping Scope execution Content (please ensure you mask any confidential information): Hi All, Could anybody provide any information if it is possible to …
-
Attachment is in BLOB FormatSummary: Hi As per screenshot, Attachment stored in DB in BLOB format. I need to read and attach the attachment in AP invoice using REST api. How to achieve? Content (pl…
-
How to increment numberSummary: Hi I am trying create AP invoice using rest api. I want increment value 1 based on row in "getInvoiceLinesOutput" and then need to assigned value to Line number…
-
How to convert date in desired formatSummary: Hi I am getting date 2024-03-20 in this format from VBCS page and need to convert this date in 20-MAR-2024 format and further need to send date to OIC. Input da…
-
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… -
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…
-
Integration Error: Error in listing files in the remote directoryContent Hello! We encounter the following error when making FTP call (List Files operation) in one of our orchestrations. Anyone familiar or has encountered this issue b…
-
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… -
' 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…