To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Integration
Discussion List
-
IDCS REST API to get all users based on group neededSummary: Hi Experts I'm looking for a REST API for IDCS where in if we pass the group name then we will get the list of all the users who are part of that group. Please … -
Download pdf output of a BI Report in OIC/ICS using SOAP web serviceContent I need to design an integration which will run a BI report using SOAP web service and which will return a pdf output. I need to bring the pdf output in OIC/ICS a… -
Wait activity needed or not.Summary: Hi, please gurus, I would need help to know if I can remove the 2 following wait activities in my integration. This part is in a loop with 200 or 300 iterations…
-
Import Journal Job failing with no data foundSummary: I am trying to import journals through FBDI process from OIC. But its failing at Import journal with no data found. I checked the ledger values and source..all …
-
Parameter names in End-point for SQL statementsSummary: I'm fairly new to OIC Integrations and came across something that's driving me nuts, sometimes when I configure an endpoint for a SQL query it is using the actu…
-
How to implement coherence in OICSummary: Implement coherence in OIC Content (required): I have a requirement where I will call a rest service which responds back with access token (token expiry time is…
-
Unable to Download attachments from Get all attachments for an invoice API ( OIC , Oracle Fusion )Summary: I was able to send a GET request to this API and receive a correct response, however I am not able to download the attachments. The API itself doesn't send atta…
-
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 to handle errors in PCS / Process flowSummary: Hi Experts I have a process application in which I'm calling an integration, if integration fails then the flow is getting stuck. Please help me as I dont know …
-
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…
-
How to read .dat file in oracle integration cloud via stage file conceptHi Folks, Can you help me on this how to read .dat file in integration cloud via stage file. Thanks & Regards Prakash Jayavel
-
Can we merge XML files in OICSummary: We have requirement to merge the XML files that are written and created in OIC Content (required): In OIC we have a scenario where we extract invoices from Clou…
-
Sequential in OICSummary: Hello everyone, can you tell me what I need to do to be able to visualize a sequence that already exists in the database with the correct schema? Content (requi… -
invalid string escape mask at javascriptSummary invalid string escape mask at javascriptContent HI, I have the following file name (FR-EXP26621341d'Auzac de Lamartinie120120208038504.pdf ) I am using the below… -
OIC Integration with SnaplogicHDlSummary: Has anyone come across any integration that leverages Snaplogic with Oracle Integration Cloud (OIC)? Content (required): Hello Experts, Just wanted to unders… -
Process (PCS) auto approve in 2 day if action not taken by userSummary: Hi Experts Can someone please help me with the solution for below. I want the process task to get auto approved after 2 days if the action is not taken by the u…
-
Is it possible to connect OIC to an Enterprise Service Bus?Summary: OIC can conect to OSB, version 12 and higher through the agent as far as I now, but, is it possible to connect to earlier versions (ESB)?
-
How to get Integration Instance/ Visual builder instance for practice purposesSummary: I am a Contractor for oracle, trying to learn visual builder so I just created a oracle cloud account with Oracle email. Now when trying to create a Integration…
-
Error while calling ERP Callback integrationSummary: We have configured ERP Adapter trigger connection with OAuth. And have an Integration to receive events from Fusion using above configured connection. This has …
-
REST API post to create an Org record AND include the org addresses?Summary: REST API post to create an Org record AND include the org addresses? Content (required): Hi all, we are using the REST API with Python to create Org records but…
-
While loading an OIC Integration in Read-only or Edit mode, it is getting stuck indefinitelySummary: While loading an OIC Integration in Read-only or Edit mode , it is loading forever and no real error message is being displayed This is happening only for a spe…
-
How to loop multiple records in OIC Target side of MapperSummary: I would like to know if it is possible to iterate through a list of hard-coded values (Transaction ID) for the "Transaction Interface Id" field below. I do not …
-
Mapping in Scheduled OrchestrationHi, I have created an integration using Scheduled Orchestration and the connection is SOAP adapter for the below WSDL https://fa-testing.fa.ocs.oraclecloud.com:443/hcmSe… -
How to get uniqueLineId for an AP Invoice Line End Point to create its DFF.Summary: Hi, We are creating AP Invoice Header, Lines and its DFF through OIC using Fusion Rest Adapter. We created Invoice Header in OIC and get Invoice Id from Its Res…
-
OIC ServiceNow Adapter/Connection ErrorSummary: Hello everyone, I am coming to you to ask about this strange particular error I am getting when trying to get my OCI integration up and running. Let me give you…
-
Oracle Fusion REST API > Max Supported Number of Records to Pass For BulkSummary: Oracle Fusion REST API > Max Supported Number of Records to Pass For Bulk Content (required): Hello All, We are creating Lookup Codes using REST API in bulk: Do…
-
I couldn't find Replace() in string functions in OICSummary I couldn't find Replace() in string functions in OICContent Version: 20.2.3.0.0 (200705.0200.36423) am using above version OIC. i couldn't find Replace() in stri…
-
How to create a Zip FIleSummary: How to create zip file Content (required): I am creating an FBDI based AP Invoice integration and have successfully wrote two csv files header and lines on an F…
-
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…