Mapping
Discussion List
-
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 … -
Locate Nearby Resources - Not working as expectedWe have examples of field resources utilising the Locate Nearby Resources functionality and the returned data is not as expected. We see "no results shown" or random fie…
-
how to retrieve deleted activity ?Summary:the activity was deleted by mistake and we need to retriew it , how can we do it ? Content (please ensure you mask any confidential information): Version (includ…Ramesh S-Oracle 32 views 2 comments 0 points Most recent by Anastasiia Semenova-Oracle Field Service -
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…
-
2OCI Data Integration pulling data increments using BI PublisherOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Mastek Description (Required): I am f…Jaydev1993 11 views 1 comment 2 points Most recent by Anjali Devi Jampala-Oracle Idea Lab – Integration Cloud
-
4Remove references to GLOBAL_ID of knowledge modules in ODI export filesOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Global Services Center Descrip…Debadrita Ghosh-Oracle 2 views 1 comment 4 points Most recent by Anjali Devi Jampala-Oracle Idea Lab – Integration Cloud -
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…
-
In Field Service Cloud, how to invoke Google Maps suggestionsWe are having issues when the Technicians are using the "Navigate" option on the app, instead of sending the co-ordinates, we are now sending the address : Number, stree…
-
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…
-
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…