API
Discussion List
-
Issue in select statmentSummary: hi When i am trying fetch data from database , i am getting below error. SQL - select xpa.batch_id, xpa.so_number, xpa.org_id from xxmdn_price_adj_tbl xpa where… -
Consume OTBI ReportHi, I would like to consume OTBI using REST or SOAP WSDL which is possible way please suggest Thanks -
Can I process data in bulk using SOAP webserviceSummary: Processing Multiple sets of records in one go using SOAP Webservice. Content (please ensure you mask any confidential information): We have a requirement where …
-
Return a json collection from a REST integration involving Oracle DBAdaptorHi All In Oracle 19c I have setup a proc that returns a nested table which references a plsql record. Back in OIC when trying to reference the proc I encountered a 'JCAB…
-
BI Report read issue in OICSummary: When i am trying to read BI Report in oic using stage activity but getting error . attached xsd file for reference. Content (please ensure you mask any confiden…
-
How to enable postman header field in OICSummary: Hi While doing Post activity , i need to enable Upsert-Mode =True . Now How i can do same thing in OIC Content (please ensure you mask any confidential informat…
-
Enhance REST call in OIC IntegrationSummary: Enhance REST call in OIC Integration Content (please ensure you mask any confidential information): I'm looking for some ideas on how I can improve the performa…
-
Get specific data group from BI reportHi, request := ' …
-
Websocket APISummary: How to call the WebSocket API from OIC? Is there an adapter available for WebSocket API calls? We have a scenario where a third-party API built on WebSocket tha…
-
' value coming in mappingSummary: Hi While Assigning business unit value , i am getting extra character like "'" in it. How to handle this ? Content (please ensure you mask any confidential…
-
Is it possible to call a web service or function created in ERP through a REST?Summary: We have a GET type API we can't call from OIC, so we'd like to know if it would be possible to call this API through a web service or server script in Fusion, a…
-
Oracle CPQ Quote Creation API/IntegrationSummary: CPQ Quote creation Content (please ensure you mask any confidential information): Hi Team, we need an API to create/Update Quotes in Oracle CPQ. currently using…
-
Validating and manipulating Received JSON data inside the integrationHello everyone, I created an Integration that receives a JSON file when triggered, and it then sends the mapped data to another endpoint through a new REST API request. …
-
How to get the UniqId to pass it as a parameter in OICHow to get this UniqId and pass it to the URI e.g., we need the gradeUniqId to pass it to the following endpoint: /hcmRestApi/resources/11.13.18.05/grades/{gradesUniqID}…
-
how to fetch specific stringSummary: Hi I want to fetch specific string from given string. Whatever value is present in "()" that need to be fetched. Industrial Minerals Company (IMC) ---> IMC Ma'd…
-
Post Contact error in OICError resolution for the issue occurring in OIC when making a POST request to the contacts API: "type" : "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.…
-
Email notification should include all the error detailsSummary: We are implementing Oracle WMS stage interface REST api using OIC for entity "ib_shipment". Current behavior of the api is if we have 3 lines and all 3 lines ha…
-
Does importServiceInstanceArchive Rest API call exist in OIC Gen3 ?Summary: importServiceInstanceArchive Rest API in OIC Gen3 Content (please ensure you mask any confidential information): Does importServiceInstanceArchive Rest API call…
-
How to create an account contact by API?Hi, I'm trying to create a contact and contact point using the REST API for contacts and attempting to link it with an account using AccountPartyId. To retrieve the acco…
-
How to give empty json object in object or change the key name at runtime for REST requestSummary: Hi Experts I have a requirement where in I have to change the key name at runtime based on some value, not sure how to achieve this in Integration mapping The n…
-
Authorization with ClientId, ClientSecret and Signature(hash with hexdigest)Summary: I'm facing an 401 - Unauthorization issue in a response of a rest endpoint which accepts clientid, clientsecret and signature in header with a json request payl…
-
Can someone please share the REST API payload for HCM submit flow for flow patternSummary: Hi Experts Can someone please share with me the HCM REST API for flow patterns to submit flow. I'm using to submit flow for Make EFT Payments but any other flow…
-
HCM adapter Flow patterns submit flow operation how to pass parameter values in integration mappingSummary: Hi Experts I want to use Fusion HCM rest API to run the "Make EFT Payments" payroll process with integration using HCM adapter but i'm not getting how to pass t…
-
How to encrypt using SHA256 in OICSummary: Need to send signature in headers encrypted using sha256. Content (please ensure you mask any confidential information): I have a payload that needs to encoded …
-
Create multi-line receipt using the /fscmRestApi/resources/latest/receivingReceiptRequests REST APISummary: We are currently calling the receivingReceiptRequests API creating a single line receipt like this example request: { "VendorId": "123456789012345", "Comments":… -
OTBI Report to VBCS Rest Endpoint **SOLVED**Summary Extracted OTBI Report - map to POST to store in VBCS Business ObjectContent Hello, I've successfully extracted the contents of an OTBI Report from our ERP Cloud … -
OIC Gen 3 Receipe Integration issueSummary: Hi 1. Movement request integration are present in recipe but we are not able to open recipe document from Oracle site. Attached screenshot document is for your …
-
How to add receipe integrationSummary: How to add OIC gen3 recipe integration in your design Integration tab. Content (please ensure you mask any confidential information): 23D Version (include the v…
-
OIC Rest adapter - OAuth custom 2 leggedHi Folks, I am trying to configure UIPath REST API in OIC REST Adapter. The Token is fetch postman and I'm also able to call the API and get expected response. But, when…
-
Can Core HR in J D Edwards work with Talent Management in Oracle HCM Cloud?Summary: Hi Peers and experts, One of our clients has Core HR and Payroll systems running in J D Edwards which they do not want to migrate to Oracle yet. However they ar…