Integration
Discussion List
-
assign oic array to varchar2 field in DBSummary: Hello everyone, help with the following case. I have an integration in OIC that internally invokes a Rest service, this service has a response that contains an … -
OIC - Is there a way to check UTF-8 encoding while reading a file from SFTP?Summary: Hello, Is there a way to check if a file is UTF-8 encoded while reading a file in OIC? There is a requirement to process a file only if it is UTF-8 encoded Than…
-
Not getting the data in response after mapping the filed for rest adaptor in OICI have created a rest adaptor to get the transmission report data from OTM . I have tested it first via postman . below is the request and response : Request : Transmi…
-
How can I monitor intermittencies on an OIC instance within OCI?Summary: Hello community. I am looking for guidance on how to detect intermittency or outages on an Oracle Integration Cloud (OIC) instance created within Oracle Cloud I… -
OIC Outbound IP - Sufficient & Secure for whitelisting in OCI?Summary: Is OIC Outbound IP sufficient and secure for whitelisting in security rule for access within private subnet? Content (please ensure you mask any confidential in…
-
BICC: How to Find Current Run ExtractsSummary: I an trying to submit BICC extracts through esswebservice. I see extracts are being submitted and completed without any issues. However, when I check UCM for th…
-
Unable to find private endpoint parameter in OIC terraform codeSummary: Hello Team, Our project requires us to set up a Private Oracle Integration Cloud (OIC) using Terraform, which involves creating OIC in a private subnet within a…
-
Issue with Read File adapter after Unzipping fileSummary: Issue with Read File after Unzipping Content (please ensure you mask any confidential information): I am modifying an existing OIC integration and adding a Stag…
-
XSLT to find elements whose total is equal to a target valueSummary: I have an xml in the following format and a target value. a 10 b 15 c 25 I need to find all the elements whose value is equal or less than the target va…
-
BI report Pdf Output in email notification attachmentSummary: Hi How to send BI report(pdf format) in OIC email notification attachment. Content (please ensure you mask any confidential information): Version (include the v…
-
Excel file generation using OIC 3 with BIP reportSummary: Hi Experts We have a requirement to generate an excel file with OIC 3. As our customer is not using OCI resources like functions, we are left with option to use…
-
Fetch Distinct value from BI ReportSummary: Hi I am getting multiple customer data in BI report and I need to pass only distinct Customer to For loo( Highlighted in Yellow color) How to achieve this ? Con…
-
Impact of huge Business Events volume in Oracle ERP Cloud and OICSummary: Impact of huge Business Events volume in Oracle ERP Cloud and OIC Content (required): We are planning on building multiple event based real time OIC integration…
-
Java file issueSummary: hi I am trying to upload a JavaScript file to OIC Library, but it prompts: "Failed to create Library. Unable to parse function formatNumber(num,locale="en-US",d…
-
convert BI report Email address into stringSummary: Hi We are getting email address in BI report and we need to send email to these email address in one email. Please suggest how we can achieve this. Content (ple…
-
Zip files with password using Stage File Operation in OICSummary Zip files with password using Stage File Operation in OICContent Hi, Is it possible to Zip files with a password using Stage File Operation in OIC? Thanks
-
How to Reset the BICC Extract To last run Date via APIHi Team, How to reset the BICC Extract to last run date using the Oracle API. Can some one please provide inputs as we are using the BICC in the integration and as part …
-
invalid_grant : The token has already been consumedSummary: invalid_grant : The token has already been consumed. Content (required): We set up trust between Identity domain and ERP and configured OAUTH. This is to call F…
-
Are the OIC Integration flow details stored in a table?Are the OIC Integration flow details stored in a table?
-
How to update an existing integration using Project deployment in OIC 3.0Summary: Hello, I am using Project in OIC 3.0. I tried to update an existing integration in OIC target environment using project deployment. Here are the steps that I fo…
-
parameter value is not getting passed to DB adapter in OICgen3Summary: I am invoking an Oracle ATP connection in my integration. I want to fetch IDs from my database table for which I am writing a simple sql query. I have tried thi…Jigyasa Kamthan-Oracle 19 views 2 comments 0 points Most recent by Jigyasa Kamthan-Oracle Integration -
Delete Statement is not Working in Database Adapter In OIC?Summary: We are Tring to Delete Data From Table EX: DELETE FROM table_name Integration is Showing Success but Data is not Deleting From the Table. Content (please ensure…
-
downloadESSJobExecutionDetails in ErpIntegrationService returns SocketTimeoutExceptionSummary: We are leveraging the downloadESSJobExecutionDetails in the ErpIntegrationService to download ESS job output files from Oracle Cloud ERP. Although the service u…
-
Oracle Object Storage Subfolder listing using REST APII have bucket (Dev-Buck01) which is hosting three folder and sub folders Dev-Buck01/GL/Jan24/ Dev-Buck01/GL/Feb24/ Dev-Buck01/AP/Jan24/ I want to download files from GL/…
-
Debug Disappeared automatically from ProductionSummary: Debug Disappeared automatically from Production Content (please ensure you mask any confidential information): Hi, From our Production OIC instance the Debug Ch…
-
Unable to call local integration from an integration in OIC Gen3Summary: while configuring a local integration call from an integration, below error is coming. The local integration is active but still when trying to call from other …Jigyasa Kamthan-Oracle 64 views 5 comments 0 points Most recent by Biman Dey Sarkar-Oracle Integration
-
Unable to see DFF within OIC flow as an Input SourceUsing SOAP service CustomerAccountService operation findCustomerAccount to retrieve DFF value. It is returned in the response payload but not accessible within OIC as an…
-
How to configure certificates required for backed api in oci api gatewayWe need to call an api deployed on oci api gateway from ODA. The backed we configured on OCI api gateway needs a certificate to be configured on client(which is api gate…
-
Mapper fails to solve choose-when from rest-responseSummary: Hi Could anyone assist me with mapper logic. We need to download publicly available information (https://api.eksport.mattilsynet.no/kodeverk/v1/country-certific… -
Response of OTM DB Servlet API is not coming in valid xml formatI have tested the OTM DB Servlet API to retrieve transmission report data, but the response is not coming back in the correct XML format. As a result, we are facing diff…