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… -
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 …
-
OIC High-Volume Data TransformationContent Hi, We have a project for ERP Integrations (FBDI Import and Load) using Autonomous Integration Cloud. For the GL Integrations, the expected flow is: 1. Read the …
-
Invoke Request Job Set using OICSummary: I am not able to invoke ESS Request Job Set using OIC. I am getting error in using connection itself. Can someone help or in case of any blogs/materials Content… -
Connected OIC using EBS adapter but not able to find business event related when item is create ,ordSummary Connected OIC using EBS adapter but not able to find business event related when item is create ,order creation and customer creation etcContent Connected OIC us…
-
SFDC Bulk Job is not returning job id on a custom objectSummary: I am trying to load data into SFDC Custom object via bulk job 'update' operation using SFDC Connector. My integration is completing with no errors but SFDC Bulk…
-
Performance issue while loading time entries via Rest API in OICSummary: We are facing significant performance issue when loading time entries through the Rest API in OIC. Its taking around 1hr to load 2.5k records, but the expected …
-
Enabling OAUTH in OIC gen3Summary: Hello Team, Our lower instances got upgraded to OIC generation 3. After the upgrade, OIC REST API calls with basic authentication are not working. To overcome t… -
how to enable SSO login for OIC gen3Summary: Hi Team I am using SSO login option to login into fusion application. Same way I want to use SSO and login into OIC gen3 instead of username and password. Conte…
-
Fusion - Apex integrationHi Experts, We are using oracle fusion application cloud ERP(SAAS). We also have paas services (OIC4Saas and apex on DBCS) for saas extensions. We wanted to use Oracle F…