Mapping
Discussion List
-
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… -
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 …
-
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…
-
How to send data as per the below Json formatSummary: How to send data as per the below Json format Content (required): Hi Expert, I have requirement to send the data as per the below JSON structure. I need to send…
-
How Insert date field from csv into databaseSummary: What is the correct way to process a date to insert into a database? Content (required): Hi experts, I have a csv file on the ftp server like this: I have confi…
-
Remove Trailer record from file during Stage Read OperationSummary Need to remove trailer record which is of different format than other records from txt file using stage read operation (ICS fails with error "Error while reading…
-
REST API for Common Features > Create a lookup code > Ability to Create Multiple Lookup CodesSummary: REST API for Common Features > Create a lookup code > Ability to Create Multiple Lookup Codes Content (required): Hello, We would like to create multiple Lookup…
-
Ability to Get the Value of XML Tag Based on CriteriaSummary: Ability to Get the Value of XML Tag Based on Criteria Content (required): Hello, In the below XML, the tag '' repeats and it has 2 child nodes and : Is there …
-
Reading large JSON file in OIC IntegrationSummary: Hi , We have a requirement where we are getting JSON file of around 90-100 MB. We cannot use stage read to read entire file as it supports upto 10 MB only. Also…
-
Any insight console sharing forum?Summary: Content (required): Pretty simple request, is there any forum specifically for sharing custom insight consoles? I noticed they can be imported and exported, so … -
EDI transactions support with OIC and CMKSummary: One of my customer does EDI transactions with 3PL and Contract Manufacturer. The transactions like Inventory Receipts, Ship confirmation, sales order picks tran…
-
Data Stitch: Datatypes might not be compatible: Anonymous .vs.Summary: Datatypes might not be compatible: Anonymous .vs. Content (required): Hello experts, I'm working on an integration which launches another integration inside a f…
-
Integration with UPS for Inventory management using OICSummary: My customer uses UPS as a 3PL. When ever they transfer inventory from repaired product back to service. They want oracle inventory management cloud to UPS to do…Vishnuvarth Subramanian-Oracle 44 views 1 comment 0 points Most recent by Bhavesh S-Oracle Integration
-
Mapping issue in sample integration with EBS from the OIC documentationSummary: Unable to add 'if' construct under P_HEADER_ID Content (required): Add the Oracle E-Business Suite Adapter (Trigger) and the REST Adapter (Invoke) to the Integr…