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
-
Is there any way to filter the fields from the Business Event triggered from Oracle Fusion?Summary: We need a way to filter the fields from the Business Event triggered from Oracle Fusion like we have in rest api calls Content (required): We have an Event Base… -
Creation of (AR) Customer Record via OICSummary: The requirement is to create a customer party, account, address details for 'Bill-to' and 'Ship-to' and a contact point for 'email'. Content (required): We've b… -
How to list files from specific folder from Oracle Hyperion Planning REST API'sSummary: In Hyperion Planning cloud application, we have directories like inbox and outbox and some directories are available under outbox directory for example /outbox/… -
The simplest solution to generate XML file from Fusion CSV report outputSummary: What is the simplest solution to generate XML output, in a required XSD schema, from CSV Fusion Apps report outputs? Content (required): The SAF-T legal report …
-
How to download the zip document received as response from rest adapterHi, I have a rest adapter to which I send the file name.I am getting the response but how can I download this to OIC ftp location? We send the request as https://sfp.ocs…
-
Do you know any utility which provides sample JSON data with input as JSON Schema?Summary: Do you know any utility which provides sample JSON data with input as JSON Schema? Content (required): Do you know any utility which provides sample JSON data w…
-
Create BIP reports for PaaS(DBCS) and SaaSThe below query was raised(by Raghu) few years ago there were no replies/suggestions, I am raising this again. Any thoughts on this? I understand we have OTBI and BI too…User_2025-02-12-00-14-38-102 74 views 2 comments 1 point Most recent by Sagunthala Anbazhagan-Oracle -
ICS Database adapter sql is not working and throwing Error: ORA-00933: SQL command not properly endeSummary ICS Database adapter sql is not working and throwing Error: ORA-00933: SQL command not properly endedContent Hi, I have two tables Report_History and Report_Mast… -
How to return a array from a javascript functionSummary: Hi guys! I writed a code to return a array from a javascritp code (see an exemple below). However when I map the resoult in my payload, I get the array as an co… -
REST Adapter with CSV formatSummary: HI All, Can we send csv payload in REST adapter for a PUT call, Content (required): Kindly share any inputs on implementing REST adapter to send CSV payload to … -
Write file with multiple record typesHi All We are reading data from ATP tables and need to a write the file for target system which has multiple record types. Header, field1, field 2, field 3 Line1, field4… -
Reading through an unstructured file using OICSummary: Is there an option to read through an unstructured text file using OIC and finding a specific string. Content (required): Version (include the version you are u…
-
DocuSign Adapter IssueSummary Blank PDF is coming when we read the file using DocuSign adapterContent Hi All, I am doing a POC to check the OIC DocuSign adapter capabilities, My flow is 1. Cr…
-
Remove empty elements via XSLSummary Remove empty elements via XSLContent Hello! Has anyone tried to remove/scrub empty elements via XSL in OIC? We already placed conditional mapping for each elemen…
-
Flat File ReadingSummary: I have one requirement as mentioned to read in the ATP database in two tables. What are the best possible ways to read the file considering it to be more than 1…
-
How to avoid concatenationSummary: Hi, Source has one or more records, but Target accept single record only. I just drag and drop the source field to target field. Since I mapped the repeated ele… -
what is For loop execution time limit in OIC?Summary: I would like to know For loop execution time limit in OIC. I am aware of 5000 iteration limit. Content (required): Version (include the version you are using, i…
-
Accessing a file from OIC staging directory via a javascript functionSummary: Has anyone experienced accessing a file from OIC staging directory via a javascript function i.e. passing the file reference/ stream reference of the file to th…
-
How to invoke REST OIC particular integration using basic authenticationSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Customer APIs to fetch customer communication informationCustomer APIs/Data model to fetch Customer's Communication Information Hi Experts, In our UC we need to fetch Customer communication information from Fusion/ERP. Any poi…
-
File limitation on Purchase Order attachment using ErpObjectAttachmentService Web Service via OICSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
File limitation on Purchase Order attachment using ErpObjectAttachmentService Web Service via OICSummary: File Limitation on Purchase Order attachment using ErpObjectAttachmentService Web Service via OIC Content (required): 10 mb limitation on File Upload Version (i…
-
Getting MySQL Error on OIC Caused by java.sql.SQLNonTransientConnectionExceptionSummary: Error Message:- DBReadInteractionSpec Execute Failed Exception Query name: [FetchRecordSelect], Descriptor name: [FetchRecord.Test]. Caused by…
-
Single Sign-On SOAP/REST APIsSummary: Content (required): How can we trigger SOAP/REST APIs using the Single Sign-on credentials of Microsoft Azure in Fusion SaaS? We are referring to this blog of t…
-
Pass JSON payload as-is without OIC Mapper to SaaS REST APISummary: Content (required): Is there any way we can form a JSON payload and pass that payload as-is without mapping each element from left to right? Version (include th…
-
Elements are blank when Read File in Segment operation is usedSummary: Elements are blank when Read File in Segment operation is used Content (required): I'm trying to read a structured XML using the Read File in Segment operation …
-
Convert an App Driven Orchestration to Scheduled OrchestrationSummary: Can we convert an App Driven Integration to a scheduled one without having to rewrite whole integration? Content (required): Version (include the version you ar…
-
Connecting Primavera Webserices and an Apex database with OIC Can you explain the process ?Summary: I have created Two Connection s and an integration but can seem to get it to wok Content (required): What are the right steps to invoke a soap connection to Pri… -
How to generate JWT in OIC to connect to third party REST endpointSummary Need to connect to third party authentication service using JWT to get bearer token back for further accesses, can't find any option available in OIC to generate…
-
Is there a way to require the rest connect to pull one row at a time from the database ?Summary: Need Rest integration to pull one row at a time from the Apex Database and pass it to another rest API . Content (required): APEx Database to Application api Ve…