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
-
OIC - CICD ProcessSummary: We are looking to implement CICD process for OIC. As per the Oracle Integration document: https://docs.oracle.com/en/cloud/paas/application-integration/whats-ne… -
How to read HTTP Response Headers for a REST Adaptor API call?Summary: For a certain integration, I need to read HTTP Response Headers to extract certain cookies from a REST Adaptor API Call, and then further use them in another AP… -
BICC PVO usage with different PVO'sHi All, We have a requirement as below and trying to understand if this can be feasible from BICC. Seeded PVO with query parameter and columns Same Seeded PVO with diffe…
-
OIC to Splunk IntegrationSummary: Has anyone worked on integrating OIC with Splunk or similar tools to synchronize activity and audit history? If you have, I’d be grateful for any insights on ho…
-
OIC Gen3: Payloads in Activity HistorySummary: As we are aware, Oracle has imposed a 24-hour limit on payloads in the activity history for OIC Gen3, which can create quite a few headaches when issues pop up …
-
Scheduled parameter in OIC 3 takes old value even after changingSummary: In OIC 3, we are seeing the parameter value for a scheduled integration is not updating its value. For eg., a filename parameter is used and we are testing for … -
Has anyone used the VB add-in for Excel to update data on AP invoice headers?Summary: The VB add-in for Excel is recommended for use to update AP invoice headers via the REST API's. We are a CLOUD SaaS customer and use OIC for integrations. Has a…
-
Transfer worklogs from OTL to JiraHello, I am trying to build an integration in OIC to send worklogs data from HCM to Jira. I have setup the Jira connection in OIC, but there is no option to search/updat…
-
VBCS Backend and Service Connections AuthenticationSummary: My question is around the Authentication method used in the "Server Identification" section when you create a new Backend/Service connection in VBCS Content (pl…
-
OIC-Convert epoch time to DatetimeSummary: Hi All, I need to convert the epoch time to date time format in OIC. I do not see any out of the box function to do this. Appreciate any inputs. Thank you. Cont…
-
How to use nest loop about ATP query in integration flowHi All, I am a beginner of OIC. Now I have 2 autonomous database tables stored data from 2 different system. I'd like to compare one of their columns, if the are the sam… -
Oracle ERP Maintenance work order picking with WMSSummary: I am having trouble finding specific OIC details mentioned in the Integrate Manufacturing and Maintenance Work Order Picking Requests with Your Warehouse Manage… -
Oracle Process Automation (OPA) Error ENGINE-03051Summary: Error while running a process automation Content (please ensure you mask any confidential information): I tried to create a sample OPA using the below Oracle Li…
-
Cannot edit same imported project into 2 Gen3 instances in the same cloud at same time.Summary: I have 2 Gen3 Instances Dev3 and Test3. If I import the same project into each instance, then edit both at the same time. The first one I open "loses lock" with… -
Fusion to Third party API Connectivity issueSummary: Hi Team We are facing random issue while connection Third party system(LIMS) through Fusion Via OIC. same set of records it is processing and some time it is fa…
-
Error in "ReadEnrichedFileInSegments" activity stream after OIC Gen3 UpgradeSummary: Error in "ReadEnrichedFileInSegments" activity stream after OIC Gen3 Upgrade Content (please ensure you mask any confidential information): After OIC Gen 3 upgr…
-
Advice Required: On Demand Integration ExecutionSummary: On Demand Integration Execution Content (please ensure you mask any confidential information): Hi Experts, We have a requirement to invoke OIC based integration…
-
OIC Connection import workaroundHi All, is there a workaround to import Connections in OIC just like how Integrations and Lookups are being imported? I checked existing REST endpoints but there is none…
-
ATP Adapter or ORDS REST Services: What’s the Optimal Solution for Integrating with OIC?Summary: We are in the process of integrating the Oracle ATP database with OIC to facilitate certain business logics. With the anticipated large data volumes, we are try…
-
FTP File name Pattern - OIC GEN 3I am trying to move a file from source FTP location to Target. so when the source file name is "test.txt" i am trying to rename the target with "test_%yyMMddHHmmss%.txt"…
-
Large volume file processing OICSummary: OIC Integration takes very long time to process (> 8 hours for 50k records in the input source file). Looking forward for suggestions or corrections to improvis… -
Download large files from HTTPS link in OICWhat can be a good workaround to download files larger than 100mb over HTTPs in OIC integration? There is a mandatory compliance requirement from one of the EU countries…
-
download the XSD file from the OIC Integration?How to download the XSD file uploaded into an OIC Integration in Gen 3 version?
-
Substring last 5 characters from a string - OIC GEN 3Need to Substring last 5 characters from a string from an integration in OIC GEN 3. I am expecting substring("r e dwood", -5, 5) will result "dwood". So I tried below fo…
-
OIC3 Post Upgrade: Difference between OAuth and Basic AuthenticationSummary: Hi All, We are trying to test the integrations in OIC3 post upgrade which having REST calls with Basic authentications in Gen2 . As per the Oracle , Post Upgrad…
-
OIC Gen 3 and "Design-time built-in APIs"?The Oracle Integration 3 eligibility checker is suddenly giving me the warning "DT factory api's should be accessed using Oauth in Oracle Integration 3. Change Basic aut…
-
What mechanism OIC followed to ensure data reached to EBS (or destination server)Mechanism followed by OIC to ensure data to EBS (or destination server) are same as OIC passed -
How to pass collections to PL/SQL package from OICSummary: We are in the process of transferring all direct table operations (insert/update/delete) from the OIC database activity to a PL/SQL package. However, we are enc…
-
OIC Table SchemaHi Everyone, I would like to ask if there's a way to know what is the schema of the table configured in the OIC. Currently modifying an integration and I need to configu…
-
How to enable an external oracle database to update table in Oracle DBaaS hosted in OCISummary: Is there a way to connect to a DBaaS table from an Oracle on-prem database? How to enable an external oracle database to update table in Oracle DBaaS hosted in …