Mapping
Discussion List
-
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 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 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…
-
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…
-
Integration Error: Error in listing files in the remote directoryContent Hello! We encounter the following error when making FTP call (List Files operation) in one of our orchestrations. Anyone familiar or has encountered this issue b…
-
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 … -
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…
-
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…
-
Integration between OIC and Coupa > Ability to send Attachment via REST APISummary: Integration between OIC and Coupa > Ability to send Attachment via REST API Content (required): Hello All, I am trying to send file attachment from OIC to Coupa…
-
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 21 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…
-
UPS Integration to Oracle Inventory Management Cloud through OICSummary: One of my customer uses UPS as a 3PL for forward and reverse logistics process. They send lot of data (Sales Orders) through EDI from Oracle to UPS. And from UP…Vishnuvarth Subramanian-Oracle 24 views 1 comment 0 points Most recent by Kanchankumar Khedkar Integration
-
ERP Adapter issueSummary Error: The application has encountered an unexpected error. Please check the applications connection details, credentials and retry your request.Content I'm tryi…
-
REST API for Get all lookup codes > How to escape special charactersSummary: REST API for Get all lookup codes > How to escape special characters Content (required): Hello All, I want to use the Get all lookup codes REST API in OIC (work…
-
Reading first occurrence of the repeating element column from the JSON fileSummary: Hi Team, I am trying to read a JSON file ( sample content pasted below ) via OIC. My requirement - Pick the single/first occurrence of the repeating 'additional…
-
OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQLSummary: OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQL Content (required): Hello All, I am facing this issue in the screenshot when I use TO_DATE …
-
Oracle Database Adapter - SQL IssueSummary Issue while trying to create a SQL queryContent Hello guys, i'm trying to implement a simple query as code snippet but i'm receiving the following error: Error: … -
Get Base64 from REST API to Retrieve Attachment from a ProcessSummary: I am using following REST API to get the attachment and it works fine on postman. Content (required): I am not sure what or how should I configure the REST adap…
-
Any XSLT function to get the Last Day of a Month when the input parameter is sent as MON-YY?Summary: Any XSLT function to get the Last Day of a Month when the input parameter is sent as MON-YY? Content (required): We have a requirement to get the Last Day of a … -
(copy-of) Payload from parent Integration to child Integration is not working as expected on readSummary: Hello, Need some guidance here please. we are passing an xml structure (Copy-of) from parent integration to child integration and then we are trying to use the …Balaji Sivaselvaraja-186077 71 views 5 comments 1 point Most recent by Balaji Sivaselvaraja-186077 Integration
-
How to Map data from multiple data sets or nodes to target nodeSummary: How to Map data from multiple data sets or nodes to target node Content (required): Please find the attached file for detailed explanation of my query. I have d…