Mapping
Discussion List
-
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…
-
OIC stage file write operation to get md5 checksum is not workingSummary: Hi Team, We have an OIC integration that is receiving a file as binary attachments, we have a requirement to validate the checksum of the file, so we are writin…
-
The "Name" parameter in OIC ERP adapter for invoice validationSummary: I am going to call Oracle Cloud ERP's validateInvoice API from an OIC integration. I tried out Oracle Cloud ERP's API directly by Postman first to validate my p…
-
but actual coSummary Content Type doesnt match even though POSTMAN gives the responseContent We are facing an issue where from VBCS REST API, we are receiving response when its execu…
-
How to add "finder" Query Param in OIC ERP Adapter for paymentsExternalPayeesSummary: I want to get PayeeId for a supplier site in an OIC integration. I tested the ERP API directly and it worked well. In OIC integration, I put a Oracle Cloud ERP …
-
How to generate unique id for each record in OIC integration mappingSummary: Hi all, how we can generate the unique ID for each record and it will never repeat. I tried with date timestamp but even seconds are not changing. If my file ha…
-
Trying to create Fusion Item in WMS sideSummary: Hi I am trying to create Fusion Item in WMS side But facing issue. Endpoint - /wms/api/init_stage_interface Attached information for your reference. Content (re…
-
Is there a way to add a new line above header csvSummary: I am trying to use a write file action in an integration that I have developed, and I feel like I have hit a limitation. Content (required): The recipient of th… -
Attachment of log file of ESS job request not coming correctly in email notificationSummary: Hi I ran ESS job "Generate Receipt Advice" for single PO in OIC and looking for same log file in email attachment. i am getting email attachment but it is of 1k…
-
OIC translation error : HTTP 502Summary: OIC endpoint throws HTTP 502 error while parsing an error message in a scope fault Content (required): We have an OIC interface that invokes an external REST en…