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
-
Read excel file with multiple tabSummary: Hi I want to read excel file which having multiple tab. For E.g Excel having 3 tab name like A,B and C. I want to read B tab. How we can achieve this. Content (… -
How to pass bearer token in REST connection in oic3Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Ignore null values in REST API outputHi All We are using REST API to query data based on list of values using IN, however null values are being extracted for the criteria. If there a way for null values to … -
How add new line space between two strings using concat function?How add new line space between two strings using concat function? -
OIC User for Basic Auth on APIs - Prevent Access to the OCI ConsoleHi everyone, Considering I have an API built on OIC and I want a supplier to consume this API, I need to create a user on the OCI console for this supplier, right? In ca…
-
Difference between query parameter and Finder in REST APISummary: Difference between query parameter and Finder in REST API Content (please ensure you mask any confidential information): Hi Expert, when we need to use query pa… -
Observability -> Instances search bar is not workingSummary: Observability -> Instances search bar is not working Content (please ensure you mask any confidential information): Hi, Why the instances search bar is not work…
-
How to amend an expired contract via APISummary: I would like to amend an expired contract via API, but the API documentation says the amend API does not support this: "This method lets you amend a contract. T…
-
OIC Integration: Extra $ Symbol in Update Manager API Request to Microsoft Graph APISummary: I am working on an OIC integration to update manager details in Microsoft Azure using the Graph API. The request payload I am using is as follows: API : https:/…
-
How to send large size attachments to AP Invoice using APISummary: Hello Team, looking for solution to send large data attachments files to AP invoice using Rest API Content (please ensure you mask any confidential information)…
-
Calling DB Procedure from OIC is taking too much timeCalling DB Procedure from OIC is taking too much time, where as when the procedure is executed independently in the Sql developer it is getting completed within seconds.
-
Scope is not working for all mappings inside that scopeSummary: Scope is not working for all mappings inside that scope Content (please ensure you mask any confidential information): Hi, I have a loop and within a loop there…
-
Colon is not valid for HcmParam name error while Create worker into HCM from OICUnable to create worker in HCM via HCM Cloud Adapter connection from OIC connecting to fusion HCM via HCM Cloud Adapter and getting error as Colon is not valid for HcmPa… -
We need to Connect IDCS through OIC and create the users in IDCS?we are try to connect the IDCS console through REST API but unable find the correct scope in IDCS. how to create users in IDCS using Postman and provide the steps. https…
-
Get all data assignments API is case-sensitive for searchesSummary: We have noticed that the https://docs.oracle.com/en/cloud/saas/financials/24d/farfa/op-datasecurities-get.html API is case sensitive while searching using the q…
-
Create a new snapshot resource for an Analytics instanceSummary: For creating a new snapshot BAR file in Oracle Cloud Infrastructure (OCI) storage of Oracle Analytics instance below is the JSON payload: { "type": "CREATE", "n…
-
X-Forwarded-Host is showing OICs hostnameHi, We have an OIC application integration that can be triggered from PeopleSoft. I have now added the custom headers X-Forwarded-For, X-Forwarded-Host and X-Real-Ip to …
-
How to pass the Fusion UCM server document id or doc name while uploading attachments in fusion apiSummary: Hi Experts I'm building one integration to upload the attachment to the Oracle fusion REST API, (huge file). I'm able to upload the file to UCM but when i refer…
-
Does Oracle OIC support reading CXML files?Hi, I am just overthinking as I am about to start working on building an accounts payable integration in OIC and am unsure whether the cXML file is directly supported. R… -
ERP connection, send file to UCM for general purpose for storageSummary: Hi Experts I want to make use of ERP connection → send file to UCM to upload huge files to fusion and then refer it in the REST API with the doc name. Could you…
-
OAUth connection issue in PostmanSummary: Hi I am trying to call integration using O auth but it is failing. Content (please ensure you mask any confidential information): Version (include the version y…
-
Crypto JS library- AES.js to bundle up in my jar along with my Javascript function for EncryptionSummary: We are trying to do Field level Encryption using ephemeral Data Encryption Keys and an OIC Javascript function. I have tried bundling up the dependent Javascrip…
-
How to fetch Child link output in REST APISummary: Hi I am getting below response in ds node. In that File location tag , attachment link in there and i need output of that. I was assigning file location to next…
-
Need VBSC application usage detailsSummary: Hi Team, We need information on which VBCS application is accessed by which user. Please can you let us know how to get these details. Content (please ensure yo…
-
OCI Logging Search detailsSummary: Hi Team, We are getting OCI audit logs through Observability & Management → Logging → Search, through the audit console. We are using the query below to get res…
-
format-date time function is not working in Gen3?Summary: Trying to format date time from 2025-03-10T05:09:05.049+00:00 to 10-Mar-2025 but its giving blank. xp20:format-dateTime(2025-03-10:09:05.049+00:00,‘[D01]–[MNn,3…
-
Create flex fields for an existing sales orderSummary: Hello everyone, I have the following problem that requires your support: I have a sales order created in the ERP A context has already been created with the fle… -
Leveraging OIC to transform invoice number from IDR-imported invoicesSummary: Client has 3,000 utility invoices per month. These will be scanned in via IDR. Each month, the service or customer account number on the invoice would be the sa…
-
OIC Failing Due to XML Size Limit Exceeding 100MB in ATP Data TransferWe are encountering a critical issue in Oracle Integration Cloud (OIC) while transferring data from a public ATP table to a private ATP database. When executing a SELECT… -
How to send TransmissionAck back to OTM from one way integrationSummary: We are implementing OTM integration. We have a requirement where once request is received from OTM, we need to send acknowledgment back to OTM and process the r…