Mapping
Discussion List
-
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 31 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
-
3Remove 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 1 view 1 comment 3 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…
-
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 … -
OIC - JavaScript Function Library Timeout IssueSummary Calling a JS function in OIC Orchestration with 15-second timeout limitContent Hi, We just found out that the “Wait” Action in OIC/ICS is only available for Sche… -
fault error notification in Email attachmentSummary: Hi All I want to send scope level fault error code and error reason as a attachment in email notification. Can you please guide us. Regards Mayur Content (requi…
-
How to upload sales order in different status as per R12 to fusion using FBDI template.Summary: We are migrating from Oracle Apps v12 to Fusion and loading sales order data using FBDI template. Need to know how to upload closed orders as well as lines whic…
-
OIC - REST Invoke - Read JSON response for 400 Status CodeSummary: Hi there We have REST Invoke operation and it is sometimes giving 400 status with JSON response. How can read the JSON data in case of a 400 status code? Conten…