Integration
Discussion List
-
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…
-
API To Submit BICC JobSummary: Hi Team, We have created a offering pointing to two different jobs with different filter criteria and would like to submit these Jobs using API. Looks only PVO'…
-
How to recover a deleted integrationSummary: Can we recover a deleted integration Content (please ensure you mask any confidential information): I have OIC integration which i have deleted, is there a way …
-
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 …
-
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…
-
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…
-
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…
-
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 - 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…
-
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…
-
Available quantity item details are not flowing back to OFS from fusion-OIC standard integrationSummary: Hi Team,Can you kindly help on below use case scenario and recommended approach to handle it. Use case: • When parts/items consumed in OFS activity by field tec…Venkata Seshaiah-Oracle 11 views 1 comment 0 points Most recent by gajendra.pujari-Oracle Integration
-
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…
-
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…
-
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…
-
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…
-
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…
-
Approval Delegation rules in HCM cloud via API’s or Data LoadersSummary Is there a way to Create/Update Approval Delegation rules in HCM cloud via API’s or Data LoadersContent Do we have any way to create/update approval delegation r…
-
OIC Gen 3 Instance ID Datatype Change Creating IssueSummary: Hi Oracle Team, Post the OIC Gen 3 Upgrade all the existing interfaces which are using the ATP adapter to insert the data into database are failing due to OIC I…
-
Best Practice for OIC to Cloud DB: DB Adapter or RESTful Services?Summary Better way to connect in Oracle DBCS from Integration Cloud (OIC/AIC)Content Hi, I'd like to hear your inputs as to which approach is better in terms of efficien…
-
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"…
-
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 passedMuhammad Naveed Haroon 21 views 2 comments 0 points Most recent by Muhammad Naveed Haroon Integration
-
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…
-
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…
-
Sign the Message Content with XML Digital Signature in Oracle Integration Cloud (OIC)Summary: Hi Team, I have a requirement to sign the XML body with an XML Digital signature using privateKey. Is there any SOAP or Rest API to handle this? OR Any other so…
-
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 …
-
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…
-
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…
-
Consume Cloud HCM's Atom feed in real-timeSummary Has anyone got OIC Publish-Subscribe pattern working for atom feedContent I understand how we can poll atom server using a scheduled OIC integration periodically…
-
How to process more than 1000 feeds from OIC HCM Adapter Atom FeedSummary: We have a requirement to process more than 1000 feeds for a single run through HCM Adapter Atom feeds. But in the HCM Adapter under Max entries to process list …