Category 222
Discussion List
-
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 271 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 12 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…
-
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…Sachin Shaligram Zambre-Oracle 34 views 5 comments 1 point Most recent by Varun Jain-Oracle Integration
-
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…
-
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 71 views 2 comments 1 point Most recent by Sagunthala Anbazhagan-Oracle Integration -
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…
-
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…Prachit-Oracle 11 views 3 comments 0 points Most recent by Sachin Shaligram Zambre-Oracle Integration