Integration
Discussion List
-
Impact of Data retention to 185 days in OIC Production environment? Does it impact performance ?Summary: We want to increase the data retention in OIC from 60 days to 185 days . Want to understand will there be any impact on the performance ? Content (required): We… -
How to get hierarchical data from data model to OIC integration?Summary: Hi Experts, In Oracle Fusion SaaS ERP, I make a data model and it has hierarchical structure. I would like to call it from an OIC integration and extract data f…
-
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…
-
Issue while attaching ucm File at manage invoice level on Fusion from REST api.Summary: We have imported a file to UCM and trying to refer the same at the Manage invoice level on Fusion UI. The below rest api has been used, though it shows file at …
-
facing issue while triggering app driven integration from fusionSummary: I have given integration End Point URL to fusion through sandbox for a particular button so while clicking on it has shown to enter username and password after …
-
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…
-
OIC - Business Event - Apply Multiple filter criteria in xpath exprSummary: Hi, The requirement is to subscribe to the Purchasing Event and take action on PO Creation. However the same event triggers for all Create, Change, Closed event…
-
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…
-
CASDK-0005 error with some business events using Oracle ERP Cloud AdapterContent Hi experts! I'm using trying to create and App Driven Orchestration Integration using Oracle ERP Cloud v.19.4.3 Adapter to Receive Business Events raised within …
-
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…
-
Is it possible to run Payroll Process i.e. Make EFT Payments with integrationSummary: Hi Experts I want to run the payroll process flow i.e. Make EFT Payments from Oracle Integration. Is this possible like we run a ESS job ? Please let me know th…
-
How can I get column name for Attribute in AIF_TARGET_APPL_MEMBERS table.I need to extract Attribute details of entity dimension in a column while exporting data. I am able to extract details of Alias (or parent name using PARENT_NAME instead… -
Passing the date range as a parameter while calling the SQL statement in OICSummary: I need to pass the sysdate-1 to sysdate as a parameter while calling the SQL statement from DBCS at mapping level in OIC.Please help to use proper available fun…
-
Read records from file with variable lengthSummary:I need to read a csv file. This file contains different records. But each records has a different amount of fields. How can I read the file. So record 1 can cont…
-
is it possible to trigger App driven integration while clicking on the EndPoint URlSummary: I want to Give the End Point URl In the Fusion So when clicking on the Endpoint URL the app driven integration needs to trigger and in that integration i have c…
-
How to read a record type file in OIC?Summary: We are trying to read a file which is a fixed length file, but file has multiple record types. For e.g., file contains a header and multiple detail lines with d…
-
OIC integration is working fine in Gen-2 but when deployed in Gen-3 it is going into ErrorSummary: OIC integration is working fine in Gen-2 but when deployed in Gen-3 it is going into Error Content (required): We have a integration which will take a .dat file…
-
OIC Business Identifier ( Tracking) Issue in Gen2Summary: I have an integration which exposed two verbs ( POST and GET ). I deleted the GET flow from the integration and now I am not able to update the tracking fields … -
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 …
-
Error when assign current-date() to a Date type global variableSummary: In an integration on OIC, I define a global variable named "gLaterThanDate" and its tyep is Date. When I do Data Stitch in the following ways, it all returns th…
-
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…
-
can we read MT940 file in OICI have a Bank MT940 bank statements which need to be processed to Oracle fusion through OIC. Is there any way to read the file in OIC? How can we define schema? It's not…
-
OIC to trigger "Load Interface File for Import"Summary: We need OIC to trigger "Load Interface File for Import". I have a doubt over here like where do we mention file name so that we import Zip file to ERP with this…
-
Processing Large Attachment in GetDocumentData of ScheduleReportWSSServiceContent We wanted to fetch the ESS Job report output of 'Process Receipts Through Lockbox AR LockBox Validation Report. WSDL: https:///xmlpserver/services/ScheduleReport… -
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…
-
AP Invoice business events filter expressionSummary AP Invoice business events filter expressionContent Hi, We are trying to filter out ap invoices using the below filter expression while using receive business ev…