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
-
How to extract PDF from ESS child job to attach to Email Notification ActionSummary: How to extract PDF from ESS child job to attach to Email Notification Action Content (please ensure you mask any confidential information): I am looking for the… -
How to pass file from sftp to Database Blob- File size more than 10 mbSummary: Hi, In OIC, how can we pass file from SFTP to a blob/clob column in database. Specially file greater than 10 mb. Content (please ensure you mask any confidentia…
-
Error: Unable to create the request and response data definition for this SQL Query. Please fix theSummary: connecting Oracle DBAAS server from OIC Run SQL Statement and validate SQL query getting below error: Error: Unable to create the request and response data defi… -
Append operation in Data Stitch for Object type Variable is giving error.Summary Append operation in Data Stitch for Object type Variable is giving error.Content I was trying to read a file more than 10 MB from a FTP Server using Read File Op…
-
Using OAuth for OIC Gen3 to integrate with Fusion HCMSummary: I am working on setting up OAuth to be used in OIC Gen3 to access Fusion HCM REST/SOAP Endpoints. I have 2 OCI Tenancies, 1st tenancy is for SaaS Services (Host…
-
Lookup doesn't find valueSummary: We have an integration, where we are using a lookup mapper. In this mapper there is a column called 'Combined_Statusses', which is equal to the statusses of two…
-
How to do reprocessing for Event driven integrations in OIC Gen 3?Summary: We need to receive payloads through an OIC-exposed URL, which serves as the endpoint for a publisher integration subscribing to a custom OIC event we created ba… -
"transfer-encoding" to be removed from headerSummary: We use the standard REST Adapter in Oracle Integration Cloud (OIC) for sending a transmission towards an external API in JSON. This external system is failing b… -
Not able to activate integration migrated to GEN3Summary: Hi all, I would thank any help with the following ( opened already an SR but no traction for now ). I get error when activating integration in GEN3 after export…
-
The requester must be an active worker in an active work relationshipSummary: I am creating a PR via OIC through REST API, but as I add the requestor ID in the payload it says "The value of the RequesterId attribute isn't valid. must be a…
-
Hello Everyone, If we are hosting python application on OCI, then how to use Devops with the SCM.Hello Everyone, If we are hosting python application on OCI, then how to use Devops with the SCM (source management) and CI/CD pipeline applicable between OCI and APEX. …
-
How to update Receivables Credit Memo?Hello All, Is there any way to update a Receivables Credit Memo in Oracle Fusion Applications? The REST API doesn’t include all the required attributes, and the SOAP web… -
APEX integration with Oracle Fusion through OICHello, This is my first time working with APEX and I'm trying to build an integration to transfer data from APEX database to Oracle Fusion HCM. Is there any documentatio…
-
How to read data within CDATA from XML in OIC Gen 3Summary: I need to modify my OIC job for Gen 3 such that, when it is Reading the data using Stage file operation, it is able to read the data that is coming in CDATA[[]]…
-
Item Update Event is not triggering upon applying filter conditionContent we are trying to capture Item Update business event in OIC with a specific condition. i.e capture only Master organization related events and neglect rest of the… -
HCM Workers REST APIs not returning all the managers of an WorkerSummary HCM Workers REST APIs not returning all the managers of an WorkerContent Oracle HCM Rest API link to fetch all managers of the worker…
-
oic Gen-3 payload request received from trigger can use into integrationSummary: if I have an integration with a Rest Adapter trigger and as a request body I have a json, now I would like to be able to register on ATP the json that arrives a… -
How to view the notification content in OIC gen3Summary: How to view the notification content in OIC gen3 Content (please ensure you mask any confidential information): Hi All, In OIC Gen2, we were able to view the no…
-
Common Decryption Encryption ServiceSummary: Hi Team, We want to build one common service that: Decrypts a file using a specific boundary application key. Encrypts the same file using a different set of PG…
-
Charge for using OCI Connector FacilitySummary: Due to the recent update, we have to move from REST API to OCI Cloud Console. But using OCI can only hold data for 14 days. And our requirement is to come up wi…
-
OIC Activity StreamSummary: This is not a request for help but a gathering of opinions Content (please ensure you mask any confidential information): Has anybody else encountered significa… -
Activity Stream Iteration Tracing Limits in Oracle Integration Cloud (OIC) in UISummary: Hi Oracle team and community, I would like to understand the tracing and monitoring capability regarding loop iterations in Oracle Integration Cloud (OIC). Spec… -
How to download OIC agent logSummary: How to download the OIC agent log Content (please ensure you mask any confidential information): Hello All, We are looking for the steps or a document to downlo… -
How to install certificates in OIC agentSummary: How to install certificates in the OIC agent Content (please ensure you mask any confidential information): Hi All, We have a requirement to install some certif…
-
How to prevent partial file processing using OIC File server eventSummary: Hi Team, We set up the OIC System File server event to start an integration whenever a new file is uploaded, so we can decrypt and re-encrypt data files. Someti…
-
OIC Failing Due to XML Size Limit Exceeding 100MB in ATP Data TransferWe are encountering a critical issue in Oracle Integration Cloud (OIC) while transferring data from a public ATP table to a private ATP database. When executing a SELECT… -
How to bulk upload data to Oracle database using OIC?Hello, We use OIC gen3 and have a Oracle database server on prem. The connection is via a connectivity agent. I am able to run SQL queries and get output on OIC, no issu… -
purchaseRequisitions API - submitRequisition Action ResponseSummary: Content (please ensure you mask any confidential information): Is there any way to retrieve the reason why a requisition ends up with the "Incomplete" status wh…
-
Read File Error When .csv Contains Double QuotesSummary: Our Read File operation fails when reading a .csv file that encloses it's values in double quotes ",". If I manually remove the double quotes from the file then…
-
UCM PGP Encryption with OauthSummary: Hi All, We are currently using "Username Password Token With PGP Key Support" security policy for Oracle HCM Adapter connections in OIC.We want to move to " OAu…