API
Discussion List
-
Get Last successful run date and time for scheduled orchestrationsWe need to get the last successful run date of a scheduled orchestration so that we can pull the data from Oracle SAAS accordingly. Followed this blog but it didnot work… -
Generating Column Header using FTP AdapterI want to add a single column header in my CSV file being produced by FTP adapter in OIC. I understand we have to create a repeat node in the OIC mapper to add a header.…
-
Move file from Stage File location to FTPI need to send a file to FTP.I am creating it locally using stage file action and trying to move to FTP,but I see the FTP adapter doesn't support it. Do we have to read …
-
can i configure IDCS application to generate JWT for outbound API call?Summary: there decent number of white papers that describe how to configure IDCS to enable JWT/OAuth for inbound API calls to OIC endpoints, fro example https://wpsbutto… -
REST/SOAP/PLSQL API on why COA is invalidSummary: Content (required): We have a requirement wherein we need to validate the COA segment structure received as input and return valid/invalid status along with the…
-
Get Binary content using SOAP AdapterWe are trying to use the UCM GET_FILE service to get the binary content of a file which we have to pass to another rest api for creating attachment in Document of Record…
-
Rest API call improve performance in OICSummary: Improve Performance while doing rest call in OIC Content (required): We have a requirement where we need to call an Oracle Project Rest API which updates the ta…
-
HTTP Request while invoking REST endpointSummary: would like to see the HTTP request when making third party rest api invocation. OIC is making a call to third party rest api, invocation is successful and recei…
-
Integration Error This Position Name already exists in EBSSummary: This Position Name already exists in EBS Content (required): We have Integration for Position from HCM to EBS. Reading File from SFTP, we are facing some issues… -
Issue while using scheduleReport SOAP Operation of ScheduleReportWSSServiceSummary Issue while using scheduleReport SOAP Operation of ScheduleReportWSSService from OICContent In OIC, we have configured a SOAP Connection with WSDL URL: https:///…
-
Namespace Issue while using getScheduledReportOutputInfo SOAP Operation of ScheduleReportWSSServiceSummary Namespace Issue while using getScheduledReportOutputInfo SOAP Operation of ScheduleReportWSSServiceContent Issue with getScheduledReportOutputInfo SOAP Operation…Shivakumar Ayyanagowdar-Oracle 660 views 7 comments 0 points Most recent by User_2025-03-07-05-44-16-607 Integration -
HCM Rest Api filter by dateHow can we filter the HCM worker api by the LastUpdateDate? Have tried the below:- 1)q=(LastUpdateDate BETWEEN '2017-09-15T00:00:00.000%2b00:00' AND '2022-09-15T00:00:00…
-
How to get a person's Territoriy(s) in OSC via a REST call.Summary: We're using OIC up update opportunities and we have the email of the person who is passing in the opportunity. We know the territory of the opportunity. I just …User_2025-01-31-22-45-25-100 1 view 0 comments 0 points Started by User_2025-01-31-22-45-25-100 Integration -
Customer specific ASN creationSummary: Hello Wizards, have you implemented customer specific ASN, real time data exchange (EDI) with 3PLs, Freight Forwarders and Suppliers. Content (required): Hello …Vishnuvarth Subramanian-Oracle 11 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Integration
-
Customer specific ASN creationSummary: Hello Wizards, have you implemented customer specific ASN, real time data exchange (EDI) with 3PLs, Freight Forwarders and Suppliers. Content (required): I am l…Vishnuvarth Subramanian-Oracle 1 view 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Integration
-
Expose Oracle SAAS queries or OTBI Datamodel as rest apiHi All, I know we can create OTBI report and call that using SOAP webservice. But is there a way where we can expose Oracle SAAS queries or Datamodel as rest apis which …
-
OTBI reports file/payload sizeWe are executing OTBI reports in OIC.I was wondering if the OTBI report brings data which makes the payload size more than 10MB, how do we handle that? What is the best …
-
JwT Token generation in OICHi All, We are trying to consume Oracle SAAS APIs in OIC using REST adapter(not using Oracle SAAS adapter).We followed all the steps in the below document https://www.or…
-
Rest API to validate accountCombinationsSummary: Has anyone used /fscmRestApi/resources/11.13.18.05/accountCombinations API to validate an account combination recently? Links:- REST API for Oracle Financials C…
-
API to initiate approval for AP InvoicesSummary: Content (required): We found that we can run the ESS Job from OIC and put a wait to initiate the payables invoice approvals, however, we could not find any API …
-
Authentication mechanism for calling Oracle SAAS apiHi All, We are calling Oracle SAAS rest apis for our integrations in our OIC4SAAS processes. We want to know what is the best process to authenticate these rest apis. Do…
-
APEX_WEB_SERVICE.MAKE_REST_REQUEST Calling OICHello Everyone! I have a situation, I have been using the APEX_WEB_SERVICE.MAKE_REST_REQUEST with the POST method(REST Call) to run the token based OIC Pooler integratio…
-
Matching against values in valuesetWe have a requirement where we have to retrieve a certain valueset values from Oracle SAAS. Retrieve values from a 3rd party application. Match these values against thos…
-
Service account and rest api endpoint for OIC process exposed as a REST apiWe have to expose an OIC process as a REST API to a 3rd party application. Need help on the below:- 1)The full OIC REST api endpoint that is auto generated is big. Is th…
-
Encrypt and decrypt values in OICSummary: We are trying to call a rest api in OIC. The rest api endpoint uses a custom http header parameter for authentication. I have the below question:- 1)How do we e…
-
Database mapper showing parameters as arg1, arg2, arg3,arg4 instead of showing its names.Summary: Content (required): Hi team, We are trying to create a REST API by integrating an Oracle Database with OIC. So as we select the table name and after validating …
-
How to Convert a Synchronous OIC Integration to One WaySummary: I want to convert a synchronous OIC integration to one way. Integration is using REST trigger. When I am trying to uncheck "Configure to receive a response", OI…Venkata Chakradhar P 51 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
API to load bulk data in Oracle SAASSummary: API to load bulk data in Oracle SAAS Content (required): Hi, We need some API which can be used to load bulk data in Oracle SaaS . Version (include the version … -
Question about Oracle Cloud Platform Application Integration 2021 Specialist 1Z0-1042-21Summary: HI , Is there any difference between 1Z0-1042-20 and 1Z0-1042-21 exams? Do both these exams contain the same questions? Are there any new questions added to 1Z0…