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
-
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. -
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… -
Running an ESS job via Oracle Integration, unable to get PDF outputSummary: Running a [Fusion Financials] Print Transactions ESS job via Oracle Integration. I am then trying to download the output. So far I can just download zip file th… -
OIC Stage File Read from xml variableI'm attempting to get data from a BPI report into OIC and a SOAP connector. I can run the report, and receive the response. I then decode64 the ReportBytes element and a…
-
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?
-
Load/Bulk testing using Concur REST APISummary: We have a requirement from client to use the concur REST API using the OIC REST Adapter, to import bulk data that varies arounds 10 Lakh records. If we are tryi…
-
How to write empty csv file from stage activitySummary: We have a scenario where we are splitting source file into a valid and error records file in csv format based on validations. However, if either of these files …
-
Oracle Integration Cloud (OIC) message costing by package wiseHow can we track costing at Package or Project level, we have three Package HR, Finance , SAP to Oracle . all are deplied into single standard OIC instance. is there a w…
-
OIC Gen3 Services calling in Fusion by using BIP/ Groovy AuthenticationSummary: We are tying to consume the OIC Gen3 REST/SOAP services by using BIP/Groovy we are unable to call them." Error while processing authentication at Trigger. Faile…
-
OIC GEN3 external REST API errorWhen sending a GET request here, https://payments.cat.uk.pt-x.com/payments-service/api/security/handshake it works once or twice, then returns a 500 error every time aft…
-
What is the efficient method for performing data updates (data fixes) in Oracle Cloud ERP?Summary: We often receive requests for updating data in Oracle Cloud ERP (Oracle Fusion ERP), particularly regarding DFF values. Typically, we utilize FBDI for these upd…
-
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…
-
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 …
-
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…
-
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… -
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 gen3 integration based on OAuth2 connection type, allows endpoint use with basic authenticationSummary: Hi, I have created a rest type integration based on an OAuth2 connection as a trigger, however when performing the endpoint test by postman it allows me to cons… -
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…