Integration
Discussion List
-
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…Malla 14 views 1 comment 0 points Most recent by Sarah Bernau - Oracle Integration-Oracle Integration -
Another user has changed the row with primary key oracle.jbo.Key AttributeSummary: Another user has changed the row with primary key oracle.jbo.Key Attribute Content (please ensure you mask any confidential information): Hi Experts, I oftenly …
-
Issue with "Enable Localization System Options" (empty dropdown in the UI).Hello, We are trying to enable Global Descriptive Flex fields GDF for testing purposes. Specifically Malaysia. Our understanding is that to use GDF country specific loca…
-
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…Scott Hillier Accelalpha 36 views 7 comments 0 points Most recent by Scott Hillier Accelalpha Integration
-
Strengthening Oracle Integration Security: Automating Password Rotation in IDCSIntroduction In modern enterprise environments, Oracle Integration Cloud (OIC) acts as the central nervous system for data flow across SaaS and on-premises systems. Howe…
-
Non-SSO Login for OIC UISummary: We have an audit requirement to track production activities with certain roles. Our tracking software requires a local login screen with username/password rathe…
-
EPM integration agent multi period import from on-premise file to data exchangeHi All, I am trying to do multi-period load using On-Premise File Data Source Application, but getting below error when it is trying to import dat file. Application Sub …Prem Siva Kumar Reddy Rami Reddy 6 views 1 comment 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
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… -
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.
-
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…
-
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…Scott Hillier Accelalpha 21 views 3 comments 0 points Most recent by Scott Hillier Accelalpha Integration
-
"There is no RPA flow in the Project". Cannot see RPA BOT in dropdown list to call from IntegrationSummary: We have created a RPA bot in the project and its in activated state. However when we try to configure, to call it from Integration we cannot find it in the list… -
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… -
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…
-
When attempting to load grade rate through HDL, some error are occured.Summary: When attempting to load grade rate through HDL, following Error was thrown: Error 1:An error occurred. To review details of the error run the HCM Data Loader Er…
-
Translation to native failed. Element 'EnteredDebitAmount' not expected..Hi Expert, I am creating integration for bulk data import to journal import, while running integration getting following error. Error Summary: oracle.fabric.common.Fabri… -
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' …
-
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…
-
Running an ESS job via Oracle Integration, unable to get PDF outputSummary: Running a [Fusion Financials] Print Transactions ESS job via Oracle Integration. I am then trying to download the output. So far I can just download zip file th…
-
how to enable SSO login for OIC gen3Summary: Hi Team I am using SSO login option to login into fusion application. Same way I want to use SSO and login into OIC gen3 instead of username and password. Conte…
-
Compare latest datetime from SFTP to current datetimeSummary: Compare latest datetime from SFTP to current datetime Content (please ensure you mask any confidential information): I am looking for a valid function in OIC in…
-
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… -
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.…