Mapping
Discussion List
-
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…
-
OIC to Amazon S3 IntegrationSummary Fetching and Placing files in S3 buckets using OIC integrationContent Hi , We have a requirement where we need to fetch files from Amazon S3 buckets. We followed…
-
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…
-
Working with timezones in OICSummary Working with timezones in OICContent From the integration source, I receive two data: 1) A "datetime" in YYYYMMDDHHMISS format and a timezone (like "America/Los_…
-
Ess Job submission issueSummary: Hi I am trying to run "Generate Receipt Advice " ess job but its getting failing . attached error screenshot for your reference. Error Reason: CASDK-0033: Recei…
-
OIC integration to pull in new customers from SFTP fileSummary: We have a requirement wherein we need to use OIC to load new customers (from a different source system) into Oracle Fusion. There is option to use FBDI with OIC…
-
list file is not working in integrationSummary: Hi I am trying to create Projects using FBDI template . As a part of it , i have placed fbdi file in SFTP server but when i am using the list file in FTP connec…
-
Project Creations issue using FBDI templateSummary: Hi I am trying to create Projects using "ProjectImportTemplat" fbdi template. but in for each loop when trying to download it seems it si not going into it. att…
-
BIP report without data fails in Stage ReadContent Hi Team, Good day! I have been able to successfully write data records to target endpoint using OIC for BIP reports. However, when the report is executed and it …