Integration
Discussion List
-
Strange double quotes appearing in transferred txt fileSummary: SCENARIO: HCM Extract creates .txt files on webcenter (delimited with '~'). OIC picks these files up and transfers these to a DMZ server. The recipient is seein…
-
Is it possible to have dynamic routing in Oracle PCS (Process Cloud Service) workflowsSummary: Is it possible to have dynamic routing in Oracle PCS (Process Cloud Service) workflows ? We have a requirement to dynamically fetch the approvers and based on w…
-
OIC Question re: File PatternSummary: We often do a FTP list files command in OIC. This will look for an explicit file pattern (eg: *.csv). How do we set this up to allow *.csv and *.CSV (all caps)?…
-
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…
-
Create XML file signed with P12 PKCS #12 fileHi Gurus! I need to create a XML file with signature based on a P12 (PKCS #12), how can i reach that ?. Is there any configuration to upload this file and sign in OIC ? …
-
Populate Hyperlink in EDI file with OICHi, I have been trying to add a URL as hyperlink using href html tag into the EDI file via OIC mapper. Instead of a hyperlink it is coming as a string, not sure if the h…
-
List files OIC not workingSummary: NA Content (required): Hi Team, We were trying to list the files from a FTP server which is on Port 21 and observed that List files is not working and it is not…
-
Can we modify the default encoding xml declaration while writing a file to stage operation?Summary: I want to write a file with below output - instead of . Can this be done in xslt or OIC? I have tried but this didnt work. Any suggestions would be helpful. T…
-
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 …