Integration
Discussion List
-
perfomance difference between nested for each loops vs. XSLT with single loopSummary: i have working integration with 3 nested loops (result sets, rows, fields) that looks bulky in OIC. 2 outer loops have no actions beside narrowing xml elements … -
Why my data is not been written in the oracle database?Summary: Hi, I'm green in OCI Data Integration. Some doubts here regarding "Target Operator". Let me try to explain: I'm doing a flow using 2 sources from ADW (Source A …User_2025-02-12-02-17-33-345 23 views 1 comment 0 points Most recent by Jorge Herreria-Oracle Integration -
Unleash Your Potential Running Oracle SaaSThe Oracle Advanced Customer Services team invites you to attend a live webinar “Unleash your potential running Oracle SaaS.” Attendance to these webinars is by registra… -
How do I configure custom three-legged security policy in REST connection in OIC?Summary: Content (required): Salesforce developed a process to generate PDFs in Salesforce. The process requires data from an Oracle database with OIC sending data to Sa… -
Exporting OIC package to object storageI am trying to export Integrations package via API, I have tried with this curl format as directly providing username and password not possible for federated SSO account… -
ReadFileinSegments throwing errorSummary: Content (required):Im downloading report data using downloadReportDataChunk operation. After that i use a stage write with opaque schema. Both these operations … -
AP Invoice Import Callback Integration erroring with Primary Identifier: undefinedWe have AP Invoice Import integration that is successfully executed with invoices imported but the Callback integration ends in error : Primary Identifier: undefined. We…
-
Recommendation/Guidance needed on Usage of EPMAutomate versus RestAPISummary: Looking for guidance on re-engineering of current EPM jobs. Content (required): My team is beginning the process of changing our EPM job automation scripting fo…
-
Custom Events created in ERP Fusion are not showing up in the Oracle ERP Cloud Endpoint.Summary: Content (required): I am creating a custom event object form Application Composer in ERP Fusion environment. After the action: Generate Integration Events from …
-
Merge" operation to SQL Server failing with Incorrect syntax near '.4'Summary: OIC is using Merge operation on table which is on Microsoft SQL server database. Microsoft SQL server database adapter is using Agent to connect to database and…
-
How to fetch BLOB data(more than 10 MB) from data base to oracle cloud integration?Summary: In atp data base one column has blob data more than 10 MB. we need to handle this data in OIC Content (required): In OIC, we are invoking one procedure where re…User_2025-03-10-21-43-39-199 268 views 1 comment 0 points Most recent by Ganesh Jadhav-178018 Integration
-
How to get the Invoice Line DFF info using REST Service in OICSummary: /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}/child/invoiceLines/{invoiceLinesUniqID}/child/invoiceLineDff in above Service i am not able to get …
-
Incase of change in WSDL request type( few fields added).. how the mapper will get reflectedSummary: Suppose, there is complex mapping defined for the SOAP service in OIC( which is having huge request payload elements) and there is a requirement to add one new …Narasimha Reddy Chetibottu 11 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
OIC - Problem when rounding valuesSummary: We are having issues when attempting to round a few specific values in an integration orchestration. Content (required): In our most recent tests we were faced …
-
OIC : Add while loop to scope without rewriting the whole thing?Summary: Is it possible to add a while loop outside of an existing scope, to nest that scope, without having to rewrite the whole scope? Content (required): Is it possib…
-
Oracle OIC - Read option in FTP adapter with the xsd zip is not workingSummary: Read option in FTP adapter (Invoke Schema- XSD capabilities) with uploaded xsd zip is not working. The zip file has multiple xsd files with interdependencies. C…
-
Scheduling an integration on last Friday of a month + 1Summary: I have a use case where external partner the files with date of last Friday of every month and I need consume the file on immediate Saturday) File availability …
-
OIC OAuth Two legged Rest APISummary: Trying to create a REST connection in OIC for the API which supports Two legged authentication. Able to test from Postman, same is failing from OIC with below e…
-
OIC Common User Password ExpirationSummary: Content (required): We have setup a common user in OIC which will be given to external parties to call our OIC REST/SOAP based Integrations, created an Invoke c…
-
why is OIC freezing up when invoking a stored procedure in an integration?Summary: In the oracle database adapter endpoint configuration wizard, I first provide a name, next select the schema, next select the package, next select the procedure…
-
Updating child element of Repeating(Unbounded) element in GlobalVariable using stitchSummary: Hello, I have a requirement where I am receiving and processing a JSON payload in OIC. The payload has multiple child elements and a few of them are repeating c…
-
How to concat a repeating element valueSummary: I have to build an integration.We send a request and we get an XML response.We are consuming the message from the outbound queue.Attaching the XML message.I wan…
-
Subscribe Business Event from multiple OIC instances connected one ERP Cloud instanceSummary: Can we Subscribe to a Business Event from multiple OIC instances which are connected to one / same ERP Cloud instance ? Content (required): Version (include the…
-
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… -
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 …
-
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…
-
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…