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
-
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… -
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…
-
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…
-
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 …
-
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… -
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… -
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… -
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…
-
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… -
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…
-
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…
-
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 -
how to call factory api with runtime url instead of design time urlSummary: Hi Expert I'm building an application and want to call the integration factory API i.e. for lookups but i don't want to use the design time url as it needs quer…
-
Unable to Update "Period From" and "Period To" in AR Invoice Line Additional Information via REST APSummary: I need help updating the Period From and Period To fields on an AR Invoice Line in Oracle Fusion Receivables using REST API. Navigation Path: Fusion Home → Rece…
-
Error while running REST API integration in OICHi everyone, I created a simple integration in OIC where I’m just making a REST API call with request and response. In my scenario, EDMCS is both the source and the targ…
-
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 …
-
Oracle Integration Gen3: How to filter scheduled integrations which are in paused/Stopped stateSummary: We are trying to filter out integrations which are in paused/Stopped state. Currently we go to Observability —> Integrations and manually scroll through the lis…
-
Flow Execution Error: Workflow: modelIdFlow, State: startState, Action: constructResultSummary: Getting Error while consuming OCI Gen AI action in the integration "Flow Execution Error: Workflow: modelIdFlow, State: startState, Action: constructResult" i h…
-
How to use Visual builder studio Git repository for Integration projectsSummary: Hi Experts I have a requirement to backup projects and deployments (export / import) with git repository but in the documentation it says only github.com is sup…
-
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… -
OIC Schedule API update failing with "input string error for time"Summary: When we are trying to use OIC Schedule update/add schedule its failing with error as " "detail":"","status":"HTTP 500 Internal Server Error","title":"For input …
-
Is there any shortcut to map multiple fields at once in OIC mapper?Summary: I am trying to use Write File in Stage File action. In the mapper, I need to map around 200 fields from read file response to write file request. Is there any s…
-
Document Understanding and Intelligent Document Recognition / Invoice ScanningSummary: Document Understanding and Intelligent Document Recognition Content (please ensure you mask any confidential information): I have asked this same question on th…
-
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…
-
What privilege is required to view Journal Headers and Journal Lines in the journalBatches rest cal?Summary: I'm trying to create a custom role to allow access to the "/fscmRestApi/resources/11.13.18.05/journalBatches" endpoint. The batches show up but I do not get jou…
-
ATP Connection OIC gen3Summary: Content (please ensure you mask any confidential information): I'm passing the information from a BIP extract to the ATP DB connection using OIC. Whenever there…