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 … -
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…
-
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…
-
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…
-
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 …
-
Are the OIC Integration flow details stored in a table?Are the OIC Integration flow details stored in a table?
-
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 66 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/…
-
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…
-
I am trying to read a xml file which is UTF-8-BOM encoded and Stage Read fails in OICSummary: I am trying to read a xml file which is UTF-8-BOM encoded and Stage Read Activity fails in OIC stating that "SAX Exception raised while trying to SAX Parse Inpu…
-
OIC Gen 3 activity stream does not show fault handler executionSummary: I have created an example integration flow to experiment with Gen 3. I have a fault handler, but the activity stream does not show the execution of the steps in… -
Oracle Integration Message consumption details at interface levelHi Team, Oracle Monitoring dashboard shows consolidated messages consumption for a date range. Is there any way to get details at the interface level? We have more than …
-
How to integrate suppliers into oracle ERP cloud? is it REST API or FBDI?Summary: How to integrate suppliers into oracle ERP cloud? Which is the preferred method? is it REST API or FBDI? We may receive multiple creation scenarios like create … -
Can we disable Integration and Process' End User interfaces?Summary: We built a process application and integrations, but want our customer's end users to only interact with them using our webapp that sends REST API calls to the …
-
How can i generate a email template to send email notification integration at runtimeSummary: Hi Experts I want to send an email like below with integration where the data will grow in table and also the note based on the criteria, how to generate such k…
-
/crmRestApi/resources/latest/resourceUsers API is giving error to pass the contract infoSummary: Hi Team, We are trying to create sales person, bu first creating resource using enpoint - "/crmRestApi/resources/latest/resourceUsers" Error Message You need to…
-
How to do application/x-www-form-urlencoded request in OIC rest adapterSummary How to do application/x-www-form-urlencoded request in OIC rest adapterContent Hi all, In POSTMAN, I can able to get a response using Body as x-www-form-urlencod…