Mapping
Discussion List
-
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…
-
OIC REST - how to save xml payload to ATP clob column opaquelySummary OIC REST - how to save xml payload to ATP clob column opaquelyContent I am trying to build a simple REST integration that when called from Postman with an xml pa…
-
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…
-
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…
-
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_…
-
OIC3 xslt template throws error by default mcube-9500?Summary: Content (required): resolution for xslt templates Version (include the version you are using, if applicable): OIC gen3 23.08 Code Snippet (add any code snippets…Durgaprakash Aradhyula-Oracle 33 views 0 comments 0 points Started by Durgaprakash Aradhyula-Oracle Integration
-
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… -
need help to understand xpath error -OICSummary: Hi Guys. I am geting this xpath error, however I have no Idea how to "bebug" it. Content (required): Version (include the version you are using, if applicable):…Rodrigo L Sartorato 732 views 5 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration -
The attribute INVENTORY_ITEM_ID is missing for service getProductRelationShipContent Hi Experts, I'm trying to execute the "Oracle Salesforce ERP Opportunity to Order" recipe and getting below error: The attribute INVENTORY_ITEM_ID is missing for… -
OIC Mapping IssueSummary OIC Mapping IssueContent I know this is the ICS forum, but in OIC has anyone else noticed that the mapping is not working? I'm using Firefox. The ability to drag…
-
How to transfer "Oracle ERP Cloud" connection response to param of a JavaScript function?Summary: I put a "Oracle ERP Cloud" connection in an integration to get supplier info from Oracle Cloud Procurement. I create a JavaScript function to check all supplier…
-
Parameter reset in scheduled integrationSummary: Hi I am using Scheduled integration and through scheduled integration i am passing values to Soap connection .I am not able reset parameters. It seems whatever …
-
Access data recieved from a SQL stored procedure as rowSetSummary: Access value of a specific column in a specific row within a RowSet. Content (required): I have a SQL Stored Procedure which returns a table together with anoth… -
How to access specific nodes by filtering by a parameter without having to use a loopSummary: Access specific information from a JSON data collection Content (required): Hi experts, { "people":[ { "Name":"Oliver James", "Age":"29" }, { "Name":"Jack John"…
-
How to make a field optional in REST API connection's Request Wrapper?Summary: The OIC integration is intended to handle REST API calls and invoke Oracle Cloud ERP adapter to create a supplier. I created a REST API connection as a trigger …
-
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…
-
Remove duplicatesSummary: Hello! I'm using a For-Each in the node that repeats in the Response to generate a CSV file. Its working but there are lots of duplicates that I need to avoid: … -
How to pass key value pairs from metadata dynamically to a rest connection in OICSummary: I have an integration where I need to create a customer in Stripe account using Rest Connection. I need to pass required fields to the rest in order to create a…
-
How to make attachment optional in notificationSummary: Hi Epxerts I have an integration with notification action to send email notification in the flow but the problem here is that I have a attachment reference mapp…
-
How to hanndle special charcters while subscribing from AQ using AQ adpterSummary: Source : Oracle EBS AQ Target : Third party vendor Using OIC, we are subscribing the message from AQ(AQ adapter) in XML format using XSD which contains the valu… -
How to achieve File to base64 in OIC.Summary Here, how we can do File -> Base64Encode? and What operation we have to choose in the FTP adapter?Content I have a requirement, I have to convert the base64encod…
-
How import a file to UCM from a tableSummary: How import a file to UCM from a table Content (required): Hi everyone, I have a fbdi files in a table and I try to import to UCM. The content is in a column of …
-
How to expose OIC endpoint with optional query params ?Summary: How to expose the OIC endpoint with optional query params? OIC Endpoint by default: https://:443/ic/api/integration/v1/flows/rest//1.0/v1//updatedworkers?oic_qp…
-
How to do application/x-www-form-urlencoded request in OIC rest adapterSummary How to do application/x-www-form-urlencoded request in OIC rest adapterContent Hi all, In POSTMAN, I can able to get a response using Body as x-www-form-urlencod…