To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Integration
Discussion List
-
PCS Roles issueDears, We have an issue with PCS Task page where any user can see the transactions for other users when he open the managed by me tab. In our solution we have an employe… -
Agent Instance status check failed. Response received - Not Found Error encountered.Hi folks, While re-establising connectivity agent to OIC agent group, seeing below error. Agent Instance status check failed. Response received - Not Found Error encount…
-
Can I install OIC Agent on premise server that is not connect with internet?Summary: Can we connect an Oracle Integration Cloud agent to a On Premise server that is not connected with internet? Content (please ensure you mask any confidential in…
-
File Server x OIC - Audit LogsHello Everyone, Is there any way to check audit logs for operations on a OIC File Server? We want to know which users are working with the files in there, and what are t…
-
REST Adapter with OAuth Client Credentials using JWT Client AssertionIn Oracle Integration Cloud (OIC), I’m configuring a REST Adapter with the Security Policy: OAuth Client Credentials using JWT Client Assertion. However, I encounter the… -
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…
-
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…
-
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…
-
How to use .jar file in OIC for encryptionSummary: In our current E-Business Suite (EBS) setup, we use a .jar file for encryption. Unfortunately, OIC does not support direct use of .jar files for encryption in f…
-
Getting 406 error while calling oracle pcs rest api for retriving attachment as streamSummary: Hi Everyone, Getting 406 error while calling oracle pcs rest api for retriving attachment as stream(response type is stream) Error: Not Acceptable.The 406 Not A… -
Integration TimeoutsWe have a number of integrations that are regularly timing out from OIC PAAS > Oracle Fusion Historically these have worked, however now they are timing out due to runni…
-
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…
-
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…
-
Is there any way to identify the long running integration jobs??Hi, We have over 500 integrations in production, and some of them take more than four hours to process, ultimately resulting in timeout errors. We are looking for ways t…
-
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 …
-
Is there any REST API that could capture the Fusion authentications through SSO?Summary: We want to track the number of authentications in the cloud fusion hcm that's going through SSO, we don't have the Chooser login enabled. There is a doc id - Fu…
-
Are the OIC Integration flow details stored in a table?Are the OIC Integration flow details stored in a table?
-
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…
-
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… -
Does anyone know why running a BIP report from OIC produces different result vs. ESS?Summary: We created a BIP report to generate data in XML for a data integration, but some elements are getting dropped when it's run from OIC. Content (please ensure you…
-
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…
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…
-
submit multiple HCM Extract from OICWhen I submit multiple HCM extracts from an OIC flow using a while loop for incrementing (1 corresponds to extract 1, 2 to Extract 2 and so on), sometimes I get a SOAP f… -
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/…
-
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…
-
How to trigger OIC Integration using IDCS Oauth option from Groovy ScriptHi , Has anyone tried to invoke OIC integration from groovy script using webservice option. I am trying to create Webservice with IDCS OAuth and all details are given st…
-
Correct REST Framework Version for Oracle API'sSummary: Hi Team, We see that Oracle provide different REST Framework Versions for invoking API's and some operations are not allowed in default versions. Can some pleas…
-
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…