Category 222
Discussion List
-
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…
-
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… -
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 …
-
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…