Mapping
Discussion List
-
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…
-
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…
-
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 …
-
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…