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
-
Oracle Integration Customer Success Webcast with Southern Company (21-MAY-2025)Summary: Please join us on May 21 to discover how Southern Company improves integration capabilities with Fusion Applications using Oracle Integration. Date: May 21, 202…Ravi - Integration PM-Oracle 72 views 0 comments 4 points Most recent by Ravi - Integration PM-Oracle -
Integration scenario - OIC3Hi Team, We need your assistance in below scenario. High-Level Process Flow Extract data from external systems (PostgreSQL, SQL Server, etc.). Load the extracted data in…
-
OIC REST Connection - Need to pass the Credentials in the request bodySummary: We have a 3rd party REST service and the end point requires us to obtain a token first by calling the end point and passing the user/password into the request b… -
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…
-
how to get the response of notification in OICSummary: We need to get the response of sent notification in OIC Gen3. Is it possible? Content (please ensure you mask any confidential information): Version (include th…
-
Unable to call local integration within project -OIC GEN3 - Not working for one IntegrationSummary: Hi I am using OIC gen3 version , within a project there are three integration. E.g A. B and C are the integrations From A, I can invoke B but from A I am not ab…
-
call procedure(oracle db) from OICHello Team, Can you please guide us for below query: How many ways to call procedure(oracle db) from OIC? What is the recommended way. Can you please give some detailed …
-
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… -
REST API to get the Position Cost Allocation fieldsSummary: Hello, What is the REST API for HCM Cloud to get the Position Cost Allocation fields ? Content (please ensure you mask any confidential information): Version (i…
-
OIC integrationsHi Team, We are recently procured OIC instance. Does OIC occupy threads during async integration. I hope only 3 threads can run for OIC instance. Can you please give som…
-
timeout - OIC3 - PostgreSQL adapterHi Team, We are using OIC3 instance. We have a integration using PostgreSQL adapter, at high level: PostgreSQL fetch (DB Adapter via Agent) Fusion receipt creation (REST…
-
Connect to ATP in VBCSSummary: Hi, i am trying to connect to ATP from VBCS using Tenancy Setting, while in OIC connection we are using agents to connect to ATP while trying to connect to the …
-
java.sql.SQLException: UCP-29: Failed to get a connectionSummary: OIC getting this error often when call to private Oracle ATP PL/SQL call execution Internal Exception: java.sql.SQLException: UCP-29: Failed to get a connection… -
Issue: Error While Creating External Bank Account in Oracle Fusion via REST API (Triggered from OIC)Summary: We are encountering an issue while attempting to create an External Bank Account in Oracle Fusion using the External Bank Accounts REST API, which is being invo… -
Error activating integrationSummary: Hello community, A clone was recently performed from PROD to TEST. In PROD, not all the necessary roles were assigned because the PROD environment is not yet fu… -
Oracle ATP connection OIC - CLOUD-0005 : Unable to establish connection. Please check connection parContent 1. Create Oracle ATP (without dedicated Exadata). 2. Try connecting the ATP from OIC by creating connection. 3. Gave Host name, port, Service name and security p… -
Integration activation failedWe are having a supplier integration in OIC to update supplier details. We are using ERP adapted to to achieve the same. The integration is working as expected in lower …
-
OIC Gen3 - iCal Expression - Schedule Integration 1st Weekday of a MonthHello Oracle Cloud Community, I am working with OIC Gen3 and need help creating an iCal (RRULE) expression for scheduling an integration. Requirement: trigger the integr…
-
How to delete fusion business event subscription using /soa-infra/PublicEvent/subscriptions API?Summary: How to delete Oracle ERP Cloud business event subscription using /soa-infra/PublicEvent/subscriptions API? Content (please ensure you mask any confidential info… -
Oracle Integration Gen 3 — Scheduled integrations: concurrency/limits and ways to increase?Summary: OIC GEN 3 Scheduled Integration Limitation Content (please ensure you mask any confidential information): I’m looking for clarity on how scheduled integrations …
-
Wait activity in OIC is making the process instance stuck - Refresh Alarm option like in SOA?Summary: Wait activity in OIC is making the process instance stuck - Refresh Alarm option like in SOA? Content (please ensure you mask any confidential information): We …
-
OIC: Multiple schedule frequencies and schedule ParameterHello All - Now, OIC Schedule supports multiple schedule frequencies (https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/define-integration-schedu… -
How to send OTBI report to SFTP serverSummary: How to send the OTBI report to the SFTP server Content (please ensure you mask any confidential information): Hello Expert, We have a requirement to push an OTB…
-
Read ONLY the first line of a csv file with 1.000.000 linesSummary: Please, I do not see the light with this problem. I need to read only the first line of a huge file (to get the ledger, group_id, etc). I do not want to read th…
-
How to Submit Recruiting Job Requisitions for Approval using Fusion APIs or OICSummary: Hi Team, I have created a Job Requisition in Oracle Recruiting Cloud through Fusion REST API from a VBCS application. The creation part works fine, but I am not…
-
java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not existSummary: For a new ATP database table we are getting below error> java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist I am able to insert into the table…
-
Getting error while enabling the checkbox from the dropdown while executing the RPASummary: Getting error while enabling the checkbox from the dropdown while executing the RPA Content (please ensure you mask any confidential information): Version (incl…
-
OIC Workday - TEST connection FailingSummary: I have created the Integration System User (ISU) and API Client in Workday. In OIC, I entered the Hostname, Tenant, Client ID, and Client Secret. I clicked "Pro…
-
Does oracle erp cloud adaper display custom objects from application composer?Summary: Hello Community, We would like to create records in custom objects in application composer of oracle using oracle fusion. We have tried using oracle erp cloud a…Koda V V Satya Sai Surya Ramakrishna 12 views 2 comments 0 points Most recent by Koda V V Satya Sai Surya Ramakrishna -
FDI Error: Data pipelines have been disabledI am receiving the error message "Data pipelines have been disabled for BI Publisher" in our FDI lower region instance with the details "BI Publisher - Invalid Credentia…
-
Is there any business event that can trigger an integration once the shipment is packedSummary: Hi, We need to trigger an integration when a shipment is packed in Oracle Fusion. Is there a standard business event available? If yes, please provide the event…