Mapping
Discussion List
-
How to map multiple values of complex nodes using for each loops within data mappingSummary: I am using OIC version 3 Content (please ensure you mask any confidential information): I have an XML input in which I have complex nodes: I need write a CSV fi… -
How to map a request value by filtering the information by the current value of a for eachSummary: Content (please ensure you mask any confidential information): Hi experts, I have an XML structure, I have created a for each on a certain node where I need to …
-
Integration between OIC and Coupa > Ability to send Attachment via REST APISummary: Integration between OIC and Coupa > Ability to send Attachment via REST API Content (required): Hello All, I am trying to send file attachment from OIC to Coupa…
-
Receivable Receipt Webservice - Remittance Reference DetailsSummary How to Populate PO Number in Receipt Remittance Reference DetailsContent Hi, We are using 'StandardReceiptService' webserice to create Receipts and applying invo…
-
OIC3 xslt template throws error by default mcube-9500?Summary: Content (required): resolution for xslt templates Version (include the version you are using, if applicable): OIC gen3 23.08 Code Snippet (add any code snippets…dpconsultant-Oracle 1.5K views 2 comments 1 point Most recent by Hemanth Lakkaraju-Oracle Integration
-
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 47 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
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…User_2025-02-07-23-59-52-354 214 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… -
' 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…