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
-
NameSpace remove from OIC MappingSummary: Hi Team, Source mapper is contains the xmlns namespace along with element(ReferenceTransmissionNo), below is the example: -
Moving Files with different formats from ftp server to local server.Hi All 1) I would like to move 2 files with different formats from 1 server to another via a single integration. Even though its basically an ftp mget I still need to do…
-
One way Procedure calls in Oracle DB AdapterSummary: Invoke Long running DB procedures is Oracle Database Content (required): We are Invoking Oracle Database procedure from OIC which on has only input parameters. …
-
Dynamic Number of attachmentsSummary: Content (required): We have a requirement to send an email notification with multiple attachments from OIC. The maximum number of attachments are 10 and these a…
-
Integration attempts to check filesize but errorsSummary: Simple Integration lists file on FTP server, then for each file I check whether file is less than 4000 bytes or its extension is 'TXT'. If TRUE then I move to a…
-
Can we place multiple SQL queries inside an Oracle DB Adapter?Summary: Content (required): Hi team, So we are trying to make a REST API integrated with an Oracle OnPrem Database which will be fetching information against a few ques…
-
OIC pass null to destination attributeSummary: Content (required): I am using OIC for interface between Oracle EBS and SF. Which value should I pass to destination attribute in order the reset/clear the valu… -
Value is not getting reassigned in For eachSummary: Value is not getting reassigned in For each Content (required): I am reading a file using Read File in Segments and using a for each to iterate the records of R…
-
Delivering Real Customer Value with Agile Innovation: Heathrow rapidly moves to Oracle Cloud and conSummary: LHR success story Content (required): Heathrow rapidly moves to Oracle Cloud and connects with hybrid Integration The continuous delivery of constant small inno… -
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 … -
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… -
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… -
3-legged OAuthSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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 …