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
-
Restricting OAuth2 client credentials to a specific integration?Summary Is there a way to limit OAuth2 client credendials to authenticate to a specific OIC integration?Content We have successfuly used the documentation https://www.at… -
404 NotAuthorizedOrNotFound in Oracle API Gateway for OIC3 Factory APIsSummary: I have created API Gateway deployment which has OIC3 REST APIs () i.e. Factory APIs as backend URL. API Gateway deployment endpoints are working fine and return… -
OIC Gen3 Outbound IP address (Ingress or Egress)We are planning to upgrade the OIC instance to Gen3. We can see form the Oracle documentation that the OIC Gen3 instance will have new IP addresses. The Outbound IP from…
-
OIC User with no password expiryHello Team, I have a requirement. My upstream & downstream systems access OIC SFTP server to consume/place the flat files from their code (Java program). OIC user has cr… -
Oracle API Gateway Implementation DetailsSummary: Hi Team, We were looking out of some information around the implementation of Oracle API Gateway for all OIC integrations and Fusion Rest and SOAP API's trigger…
-
XML Attachments in notifications, weird/ non sense behaviour.Summary: Hi, please has anyone seen this before? I am completely stuck, because I do not know where to look for. In OIC gen3, I have isolated an integration to send noti…
-
Is Instance ID in OIC Gen3 not a numeric one?Summary: Is Instance ID in OIC Gen3 not a numeric one? In the Gen3 it is showing as "R-NOnHQNEe8p2yXhQ8uxaA" though it is System geneerated, but can this be configured t… -
Unable to connect to Microsoft Azure SQL Database from OIC using MS SQL Server AdapterSummary: Hello Everyone, I am unable to connect to Microsoft Azure SQL Database from OIC using MS SQL Server Adapter? Options tried: 1) to use the connectivity agent as … -
Getting error while creating REST Connection using OAUTH in OIC to connect to ThirdpartySummary: Hi Experts, We have reqyirement to connect to Service Now from OIC using REST API. We create a REST Connection using the "OAuth Resource Owner Password Credenti…
-
Issue while trying to update using ATP adapter using the option "Run Sql Statement"Summary: Unable to use update query in Run Sql Statement option under ATP adapter Content (please ensure you mask any confidential information): I selected the Run Sql S…
-
XSLT Filtering not workingSummary: I have 2 arrays and I'm trying to apply in line mapping filter but is not working, is there a reason? We are trying to build a "lookup" read. Content (please en…
-
Run BIP report callbackSummary: Decouple OIC integrations retrieving data via BIP report with callback Content (please ensure you mask any confidential information): We would like to increase …
-
OIC Gen2 Lookup REST API - All of a Sudden "Unauthorized 401" Error*****Summary: We have been using the 'Export a Lookup' REST API below without any issue - so we have been executing this API for a long time (which is also in our SIT & … -
Refresh token expirationWe are planning to start an integration with Oracle HCM using the authorization code grant type. Our intention is to renew the access token using the refresh token once …
-
Token Authentication in REST APIHi, For the seeded ERP/HCM REST APIs currently using Basic Authentication with username and password which customer raised as security concern. Is there possibilities to… -
Do we have any callback webservice for "Custom ESS job set" completion?Hi , We have a "custom ESS job set" in fusion, which we can submit through the ESS Webservice provided by fusion through SubmitRequest operation. But do we have any orac…
-
Need ical expression to schedule integration every 1 hourSummary: Need ical expression to schedule integration every 1 hour Content (please ensure you mask any confidential information): Version (include the version you are us… -
I am unable to find the plsql procedure in atpdb connectionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to enable the Business Service ItemCostService:retrieveItemCost?Hello, I'm trying to set up the business service in the ERP connector in OIC GEN 3 but it's not showing up. Here's an example from another instance: Does anyone know wha…
-
time comparisonSummary: How can I compare two times in an OIC 3 flow. Content (please ensure you mask any confidential information): I want to receive an access token, make a variable … -
Custom EDI document creationSummary: Need to create custom EDIs 753 & 754 in 4010 version. Also, REST APIs to get B2B documents are working in OIC via REST connector but not working in POSTMAN. Con…
-
401 Unauthorized while invoking External Rest API using two way SSL enabled Rest connectionSummary: We are trying to invoke the external two way SSL enabled REST API in OIC. Client has provided the SSL certificate, We have generated a keystore as per Oracle do…
-
XML PARSING FAILEDSummary: Im using the SOAP payload to load data into fusion through PLSQL procedure running in APEX, Im getting the response correctly in SOAP UI , but while im running …
-
DBCS Table import issueSummary: While importing DBCS table , getting below error. Content (please ensure you mask any confidential information): Version (include the version you are using, if …
-
App driven integration - paginationHello Team, I need to develop an Integration which has to be exposed as an API. This can be done using App-driven/Application Integration. In this integration, I need to…
-
What is the maximum volume or file size supported by concur adapter in OIC?We want to integrate to Concur and want to export the expense reports from concur and load them as payable invoice in Oracle cloud. What will be the volume or file size …
-
What are the error tables for 'Upload Customer' FBDI jobHow can we get information on the status of each 'Upload Customer' job run in detail from OIC? which error tables contain the details of any errors encountered during th…
-
API for Fixed assetsAnyone knows REST or SOAP API to update fixed asset's location flexfields? I need to change the location field data which is having wrong data, need to update with corre…
-
OIC Gen 3: How to reuse property file after loaded to UCM for FBDI importsSummary: Property files have been successfuly loaded to UCM. If you are loading FBDI files, how do you reference back the property files? Is it better to always include …
-
OIC to process larger jason payloadSummary: We are trying to validate journals from Enterprise Journal(FCCS) with external validation set to custom (new functionality released by oracle), for which integr…