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
-
I have connection reset issue when doing a Merge operation in SQL Server tableSummary: I have an integration that extract data from Fusion and loads the data into SQL server table. I can insert a new record or update an existing record in the SQL … -
Data got corrupted while processing through stage file segments actionHello All, Using Opaque schema we are converting the BIP encoded file into text data and storing in memory using stage file action. We are reading using stage file - rea… -
Turn a Comma Separated string into multiple parametersSummary: I have an API that takes 1 or more query parameters called base. These appear in the URL as ?base=GBP?base=USD?base=EUR for example. I want my integration to ta…
-
OIC Multipart/Form-Data Attachment (CSV) Fails with 500 ErrorSummary: I am using OIC to send data out to another system which accepts Multipart/Form-Data. It works fine in Postman but error out in OIC. I have followed documentatio…
-
Convert CSV string to Array in Mapping - create-nodeset-from-delimited-string ?Summary: I've got an API which requires an array of string into a parameter called base. I want to use a Comma Separated Value passed into my integration which I convert…
-
How to enable Oracle managed DR in OIC Gen3.Summary: Requirement is to enable oracle managed DR in OIC Gen3. But unable to find DR option while provisioning OIC instance. Did the process change? What are the steps…
-
Certificates in Setting OIC3Summary: There number of certificates under setting >certificates in OIC. Need help in understanding what are these certificates. One of the certificate is set to expire…
-
Error while invoking OIC REST API from POSTMANSummary: Hi Team, Iam facing issue while calling the OIC - Integration REST API from POSTMAN. It fails with error 401 unauthorized.
-
Excluding whole rows from being staged based on certain criteria - mapper?Summary: In OIC Gen 3 I have the response from an API call being mapped directly to a stage file write. So ALL the rows returned are immediately written. I want to exclu…
-
How to get unique values from a column using OICWe are trying to read a file and convert it into a FBDI file so that it's loaded into Oracle Fusion. Our Initial file will look like below Name City Country Phone Suki M… -
Receive Requests from ERP Cloud Applications (explicitly sent from Groovy Script or Business Logic)Summary: Hi Experts I want to make use of this operation in ERP connection Trigger i.e. Receive Requests from ERP Cloud Applications (explicitly sent from Groovy Script …
-
can we use private endpoint of OIC gen3 used to connect to atp database in private networkSummary: can we use private endpoint of OIC gen3 used to connect to atp serverless database in private network without using OIC agent to connect to atp database. Conten…
-
Getting permission issue while opening the task in OPA even with adminSummary: Hi Experts I'm assigned to the group in IAM which is attached as admin for OPA instance, but when i try to open the task to see the deatils in the workspace tra…
-
Oracle Integration Administrative API to stop or start an OIC instanceI want to be able to stop (an start) a DEV/TEST OIC Gen 3 instance using the Oracle Integration Administrative API; initially using POSTMAN but eventually from an integr…
-
How to map optional nested Substitutes data to parent Components using XSLT reliably?Summary: I am working on an event-driven integration scenario with a multi-level hierarchical payload. The structure consists of Item Structure(Non-repeating Parent), Co… -
OTM REST API - How to send transaction refnums?Hello! How can I add transaction level refnums using REST API Transmission Resource? In the Transmission XML, this can be done by adding the Transaction refnums to the T…
-
Setting up OCI Notification Service for OIC IntegrationSummary: Setting up OCI Notification Service for OIC Integration Content (please ensure you mask any confidential information): Hello - I am wondering if anyone has succ…
-
Where should we create or maintain common lookup valuesSummary: We have a requirement to derive invoice approvers based on Cost center and BU value. Cost Center (CC) is available on invoice but BU is not. Currently CC and BU…
-
Oracle OIC integration to call spain tax authority SII serviceSummary: OIC integration to call SII Spain Tax Authority Service which requires Client certificate authentication Content (please ensure you mask any confidential inform…
-
OIC mapping based on a source fieldHi All, Source XML is in a repeating group but target structure is flattened as per below I have tried to use…. IF role = 'remitTo' then map name to IF role = 'shipTo' …
-
OIC instances stuck "In progress"Summary: OIC instances that have a status of "In progress" forever. Content (please ensure you mask any confidential information): I am reaching out to see if anyone els… -
How to convert an existing user account to an OIC User account.We have an existing user account in Oracle Fusion HCM, and the requirement is to enable this user to act as an OIC (Oracle Integration Cloud) user. Could you please guid…
-
Send an email with attachment with the Microsoft OIC AdapterSummary: I need to send an email with an attachment with the Microsoft OIC Adapter. Any advice or examples you can share? It is not very obvious to me the order of the s…
-
Rethrow-fault is unavailable to addHas something changed in Oracle Integration 3 in regards to the "Rethrow Fault" action? I'm unable to add it into my integration. It's available under actions to select.… -
Following error occurs when trying to edit a mapping in an existing integrationSummary: [" detail"java.lang.reflect.InvocationTargetException; ICS-11451: An error occurred during update of slement; ICS-10064: An error occurred while preparing mappe… -
error paht request json OICSummary: Error calling a REST via JSON. How can I call a REST via JSON within OIC Gen3? Already done: 1.
-
Customer FBDI Import(19 tables)Summary: Hi everyone, I have a question regarding the Customer FBDI Import (19 tables) for Customer Profile.If I want to import both the Profile at the Account level and…
-
Trying to create a table in Snowflake with the Snowflake OIC adapterSummary: Trying to create a table in Snowflake using the Snowflake OIC adapter with Configure Action "Run a SQL Statement" and getting error "Error: SQL Query entered is…
-
Is there a way to sequence the schedule parameters created as part of a scheduled integration in OICSummary: Content (please ensure you mask any confidential information): We currently have five parameters defined as part of a scheduled integration. As per requirement,…
-
Integration project loosing owner everyone when some deploy the projectSummary: OIC Gen3 - projects → given permission to everyone, but every time the owner logged in and deploy the project, they lose everyone role, and remain only current …