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
-
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… -
Unable to download the files from UCM. the error says access denied.Summary: Unable to download the files from fusion UCM. the error says access denied. what role be to added to access the files from UCM Content (required): Version (incl… -
how to map element for given attribute in OIC mapperSummary: is there simple way to map XML element for given attribute value without using XSLT Content (required): for example payload has following structure: 123 abc … -
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… -
JournalImport Callback is not successful but AP Invoice Import callback is receivedSummary: We have enabled the AP Invoice Import callback which is successful but when we enabled the callback for Journal Import , unable to receive the callback . Using …
-
Date & Time FormatHi, Due to some field limitation, we are using text field in Target system and source is Date & Time type. Both fields are in Fusion modules (Sales & Work Order). Is the… -
Is there a way to change the bulkiport process in ERP conector based on the OIC payloadSummary: I need a way to change the bulkimport process used on the ERP connector, based on the payload received on the OIC. Is it possible? Content (required): The custo… -
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…
-
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 …
-
Creating an .iar file after manual changesSummary Creating an .iar file after manual changesContent Hi all, I have exported an integration (.iar) file, and i have modified some files. Now i am trying to re packa…
-
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 …
-
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…
-
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 …