Category 222
Discussion List
-
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…
-
Applications tab not visible in Cloud ConsoleSummary: Applications tab not visible in Cloud Console Content (please ensure you mask any confidential information): Hi, I am trying to schedule 1 P2T clone request in …
-
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 22 views 2 comments 0 points Most recent by Muhammad Naveed Haroon Integration -
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…
-
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…
-
Rest API of Process Automation that is paired with Fusion-based Cloud applicationsSummary: in the context of authentication of Rest API of Process Automation that is paired with Fusion-based Cloud applications, how can I call and get response in postm…
-
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…
-
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 …
-
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… -
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… -
Centralized location to see a list of all Open API endpoints for integrations within an OIC instanceSummary: I can view the metadata for individual OIC integrations by clicking on their endpoints. However, I'm curious if there's a more efficient way to obtain a compreh…
-
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…
-
Duplicated error when zipping fileHi all, I'm facing an issue in the OIC Gen3 24.08. When the code will zip the folder with the CSV files to load into Cloud (in FBDI format), the code failed and return t…
-
OIC3 post upgrade, not able to access swagger and test consoleTrying to test the integration post upgrade, getting above error. But our integration is in active state.
-
Append variableSummary: Append global variable ans use the nodes into the object refered variable Content (please ensure you mask any confidential information): help me pleaseeee all e… -
OIC: Multiple schedule frequencies and schedule ParameterHello All - Now, OIC Schedule supports multiple schedule frequencies () , but how can we submit multiple schedules for a single Integration, each with a different value … -
total results changing when offsetSummary: We have observed when making certain rest calls with offset and limit the total results is changing and limiting our access to information. For example, when {{… -
Capturing x-amz-request-id and x-amz-id-2 Headers in OIC Integration to AWS S3Summary: I'm facing an issue with an OIC integration that sends files to Amazon S3. Some requests are failing with an error, and AWS support has requested the x-amz-requ…