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
-
Extract fields from XML responseSummary: In OIC i'm receiving a BI Report that has xml data in it (i added a sample response as an attachment). I need to access the individual Columns out of the Row ar… -
How to get the status of HCM Extract ESS job status in details using Webservice in OIC?Summary: Hi All, We have built an HCM Extract which is integrated to third party via OIC and third party system pass parameter values based on the requirement. Extract D…
-
Use round function to rounding to 2 decimal placesSummary: Use round function to rounding to 2 decimal places Content (please ensure you mask any confidential information): Hi experts, I working in data maping but I nee…
-
Invoke OIC Integration from Fusion/ESS JobSummary: Invoke OIC Integration from Fusion/ESS Job Content (required): Hello, I wanted to know if it is possible to invoke/run an OIC Integration directly from Oracle F…
-
Is Refresh of OIC Instance is feasible. If yes then impacts upon Instance Refresh and steps to do itIs Refresh of OIC Instance is feasible. If yes then impacts upon Instance Refresh and steps to do it
-
UKG Pro WFM (Dimensions) Timecard File Import into OracleSummary: Has anyone done a Timecard Import from UKG Pro WFM (Dimensions) to Oracle HCM/Payroll and how did you go about handling processing of the data? We are currently…
-
ATP got ORA-00001 when insert sequence in the primary keyHi All, I tried to use sequence to insert data in my table's primary key: I set the increment to 50 after read this document: But when I run the integration it shows 'OR…
-
Is there a way to configure OIC Gen3 to use Exchange 365 as the MTA?Hi team, We recently had a scenario where our email limits of OIC(10k) were breached due to high volume SI testing. Since we are still on Gen2, we requested Oracle to ra…
-
Gen3 OIC Dashboard monitor accessHi Team, Since Insights is not a part of Gen3 OIC anymore. we want to make our OIC dashboard public for few users to consume. is there a way that we can make the oic mon…
-
How to set user context when calling SaaS Rest API using OIC using common ConnectionWe are calling the Sales Order Hub REST API from OIC and need to pass the user context to indicate who created the order in the VBCS application. Is there an easy way to…
-
What Job role or Privilege is needed to view Supplier Registration Requests using REST APISummary: We have a requirement to view Supplier Registration Requests using REST API (/fscmRestApi/resources/11.13.18.05/supplierRegistrationRequests/). But we are getti… -
Multifactor authentication for OIC instanceSummary: Multifactor authentication for OIC instance Content (please ensure you mask any confidential information): Is it possible to enable Multifactor authentication f…
-
How to use business events for item creation and updation? what are the functional setups?Summary: We want to use business events for Item creation and Item Updation to interface data into another system through OIC. Are there any functional setups needed to …
-
How to create Multiple line from singleSummary: Hi I want to create 2 line from one line request payload. basically i am looking 2nd line with same information like LineNumber=1. 2 8128
-
Use the replace or replace String functions to remove special charactersSummary: Hi everyone, I need to remove special characters from a string for example: "A.*BC(D E+FGH?/IJK L#M%&//#?¡'¡N~OP" I have tried to apply the functions without su…
-
Can we send encrypted file as an attachment in the notificationSummary: Can we send encrypted file as an attachment in the notification Content (please ensure you mask any confidential information): Can we send encrypted file as an …
-
Need to add OAuth based authentication in a webservice application composerWe are attempting to create a web service in Application Composer, where we are adding OIC credentials and creating a global function to access the token. However, the p…
-
ERP OIC Callback Error - TBA Token Received In FA EHF Callback Request Is Not ValidSummary: We have a Receive Callback Message upon completion of FBDI bulk Import Job in OIC which stopped working after we migrated to Cloud Console. We have allowlisted …
-
Refresh Access Token Error When Calling OIC EndpointI have been stuck on this issue and need help figuring out how to refresh access token for an OIC endpoint. I am designing an integration that reactivates an integration…
-
Where does the credentials mentioned in a connection saved in OIC?In OIC to connect to ATP etc.. we use credentials in the connection. Where does these credentials of a connection saved ?
-
Instance Id change number to varchar due to Gen2 to Gen3 integrationsSummary: Last week changed UAT Oic Integration from Gen2 to Gen3. Instance ID of Oic had changed from number to varchar. How to change integrations with Instance ID defi…
-
Synchronizing Employee and Manager Details with Microsoft Office Using Oracle Integration CloudSummary: I have a requirement to synchronize employee and manager details from Oracle HCM to Microsoft Office using Oracle Integration Cloud (OIC). The data includes emp…
-
Does OIC have a feature to dynamically choose connections during runtime(based on target parameter)?Summary: Does OIC have a feature to dynamically choose connections during runtime? Content (please ensure you mask any confidential information): We have multiple fusion…
-
old OIC instance from June aborted when restarted integration. Config to not retain such old data?I have a scheduled integration which I restarted for the 1st time ever in November. Suddenly I saw an old errored out instance from June getting aborted. Where is the co…
-
Rest and ERP Adapter Connection not able to refresh access token after refresh token expiry timeSummary: We have configured the client and resource app in IDCS which and trust is established between fusion application and IDCS. Now we are using OAuth Authorization … -
Read timed out error while invoking BIP report from OICSummary: We are trying to invoke BIP report in pdf output from OIC, report invocation is taking 5 minutes and after that it errored out with below error: javax.xml.ws.We…
-
OAuth Callback - Failed retrieving access token from service providerSummary: Getting this error "[OAuth Callback] Failed retrieving access token from service provider" when trying to get an Authorization code. Config was done as per docu…
-
OIC Integration activation failure in Gen3Hi, We have created one OIC integration which involves a REST trigger and one invoke REST connection. That Integration is getting failed in activation with below error: …
-
Get error when OIC integrations runs over 5minsHi All, I created a complex integration to load data to HCM, I think it needs about a hour to complete because there is a loop to call other REST API, and I got error 'd…
-
Configure ERP Cloud Adapter with OAuth Authorization Code Credentials Security PolicySummary: try to configure Configure ERP Cloud Adapter in OIC Gen3 to invoke Fusion Application REST endpoint With OAuth Authorization Code Credentials Security Policy at…