Integration
Discussion List
-
ESS job "Process Electronic Bank Statements" from OIC or ERP, resets file permissionsSummary: When processing files using the ESS job "Process Electronic Bank Statements" from OIC or directly from ERP, we have observed that the process resets or wipes ou… -
sample csv format for RFI.EXT_FIN_SYSTEM_FILES_CONTENT table file_content column?Is there any sample csv format for the data present in the RFI.EXT_FIN_SYSTEM_FILES_CONTENT table file_content column? For all data_type. RFI version 24. -
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…
-
Object Storage file download using REST APII am able to download file using stf adopter Write file option, but issue is that the name is not getting dynamic. Below are the steps to get the file Below are the step…
-
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…
-
Should all non production OIC gen2 instances be upgraded to OIC gen3 before Production move to gen3?Summary: Can we have one non production environment in Gen2 even after upgrading Production to Gen3, at least for 2 weeks? Is it a mandate that all non production enviro…
-
How to create REST connection with Hash-based method authentication (HMAC) code in OIC?We have to build an integration to connect with Interfolio application which uses HMAC based authentication. How do we create connection in OIC with HMAC?
-
REST_REQ_PLD_ERR Error while calling a REST Service using POSTContent Hi All, I am having an issue while calling the REST Service from OIC. The error details are as provided below. Error Message -
OIC Integration with Kafka ERRORSummary OIC Integration with Kafka ERRORContent Hello All, We are getting an error message when we try to setup a scheduled orchestration using the Kafka adapter in OIC …
-
How can I filter in a bucket using the OIC 3 OCI Object Storage call (List Objects)?Summary: It looks like the new OIC Object Storage call does a recursive listing whether you want it to or not. You can't specify a prefix and/or a folder name. Content (… -
Can i use custom SMTP server to use with OIC3 instead of internal OIC or OCISummary: Due to upcoming changes to email acceptance policies, we'd like to start using our own SMTP gateway with OIC3. is it possible? are there any plans to implement …
-
OIC - Cloud Adapter connection issueTo invoke the Oracle Fusion web service, we are transitioning to OAuth. OAuth has been set up, the connection has been configured, and it works fine. However, one issue …
-
OIC how to map to payload of type AnyTypeSummary Map to payload of type AnyType in OICContent How do i map to my payload of type AnyType which is considered as a node in OIC. If i use parse xml the tags are rem…
-
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 59 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…