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
-
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… -
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… -
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… -
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…
-
Rounding issue for OICSummary: We define the mapping and insert into ra_interface_lines_all table. Current situation fails in AR invoice import because import expect amount be 9742.16. The am…
-
Is it possible to receive the item import process id while doing bulk FBDI import?Summary: The general norm of doing a bulk FBDI import viz. OIC is we zip the properties file and the csv files together and upload it through ERP adapter for import whic…
-
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…
-
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… -
How to call fusion REST/SOAP services using the SAML method using API Authentication?Summary: We have already configured the consumption of the Fusion API using JWT token, but we need to understand how to connect to the Fusion SOAP/REST services using th…
-
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 …
-
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…
-
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… -
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…
-
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 11 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…
-
Issue With XML Element xmlns Declarations Added By Data Stitch In Subsequent OIC MappingI am trying to map to the following json response: { "uniqueID": "1", "featureCollections": [ { "type": "FeatureCollection", "features": [ { "type": "Feature", "geometry…