- 10
- 15 947
Note To Self
เข้าร่วมเมื่อ 8 ธ.ค. 2020
A video channel for demos and videos for NoteToSelf.dev
OIC Basics - Using the Mapper Code Window
In this video we take a look at the mapper action,
and specifically see how we used the code window on the mapper to help us solve an XLST issue that we had.
We had a requirement to create a scheduled OIC integration that would
get some exchange rate values from an external provider using an API,
and to transform those values into rows of data for a CSV input file
which would then be loaded in Oracle ERP Cloud using the 'Import and Calculate Daily Rates' FDBI loader.
and specifically see how we used the code window on the mapper to help us solve an XLST issue that we had.
We had a requirement to create a scheduled OIC integration that would
get some exchange rate values from an external provider using an API,
and to transform those values into rows of data for a CSV input file
which would then be loaded in Oracle ERP Cloud using the 'Import and Calculate Daily Rates' FDBI loader.
มุมมอง: 644
วีดีโอ
Using Variables, Property Values and Schedule Parameters
มุมมอง 3502 ปีที่แล้ว
As developers we make use of variables in our integration flows. Sometimes to set static values, but mostly to set values on-the-fly at runtime. Having hardcoded values in our flows is never a good idea as it creates an unnecessary burden on the Support team, but more importantly makes are integrations very inflexible. In this video we'll take a quick look at some of methods of setting, passing...
Subscribing to Business Events in OIC
มุมมอง 3.9K2 ปีที่แล้ว
This video takes a look at an example business event in ERP Cloud, and how we can use it to invoke an integration in Oracle Integration Cloud.
Using OIC for Data Migration
มุมมอง 4632 ปีที่แล้ว
Should you use OIC to migrate data? Probably not...but could you? In general terms there are a few ground rules for data migration. Firstly, assume that the Client will be using Excel or CSV files. Rarely does data migration use real-time or near real-time processes to obtain data from sources. Secondly, the data migration loaders need to be re-useable, and the load mechanism needs to be repeat...
Oracle Integration Cloud Basics - Data Stitch
มุมมอง 2.6K3 ปีที่แล้ว
In this video we take a very quick look at the "data stitch" action functionality in OIC.
OIC - Creating Notifications with table data
มุมมอง 2.5K3 ปีที่แล้ว
Oracle Integration Cloud (OIC) allows you to create notifications for users. Some of our users asked whether they could receive notifications containing a table of data? Maybe to easily see rows that have been processed? Or a have a table containing error information perhaps? In this video we look at using a Custom Function, the function being written in JavaScript, and using it to convert comm...
Oracle Integration OIC Insights
มุมมอง 1.3K3 ปีที่แล้ว
As part of the OIC second generation product Oracle give customers access to 'Integration Insights'. It is available when a subscription to the 'Enterprise' edition is opted for. Although it is not a business intelligence product, Insights does provide a capacity for business process activity monitoring or real-time process analytics. Oracle suggest using Insights for tracking business performa...
OIC - Email Notifications with File Attachments
มุมมอง 3.5K3 ปีที่แล้ว
This video shows how you can create alerts, or notification emails, with file attachments that could be sent to users. There is a size limit imposed by Oracle of 2MB for the total size of the email, plus any attachments.
Integrated SOA Gateway - On premise ISG with OIC
มุมมอง 6174 ปีที่แล้ว
Integrated SOA Gateway - On premise ISG with OIC
ISG3 Process Flow
มุมมอง 1564 ปีที่แล้ว
The high level process flow for my blog post 'Exposing On-Premise Oracle Integrated SOA Gateway Service to Oracle Integration Cloud'
How to solve the below mentioned problem while changing the mapping Map is in view mode No modifications are allowed.
You cannot edit the mapper if the integration is currently active. You must either deactivate the current integration, or if it is in use then create a new version, or clone it, to edit the mapper in a development capacity. Test your mapper changes then activate.
html: <html> <head> <meta charset="UTF-8"> <title>Email template with table.</title> <style> table, th, td { border: 1px solid black; border-collapse: collapse; } </style> </head> <body> <p>Dear End User</p> <p>The following data items have been processed.</p> {tableData} <p>Please contact "Note to Self" for more information</p> <p>Regards</p> <p>The Integrations Team</p> </body> </html> Thank you very much!
Hi. Can you please help me to understand ISG in detail
Please take a look at the ISG series of posts I did on my blog. notetoself.dev/2020/09/30/using-oracle-integrated-soa-gateway-a-worked-example/
Im trying to enable B2BMessageCreated Event which fetch in get api call since its has some limits . Can you provide any other to fetch erp id for B2BMessageCreatedEvent to enable it.
Hi sir, Currently we only have access to Oracle ERP cloud applications, and we want to generate events for business objects like item or inspection plan- according to document you shared we can subscribe to these events in Oracle integrator cloud UI but we don't have access to integrator cloud. So my questions are- 1. Do we have to purchase oracle integrator cloud services for processing events in SCM cloud? 2. Can you please make a video on creating an item in Oracle SCM -> creating event for that -> and triggering an external url after event genration. Thank you for your time .
I believe that only the Oracle ERP Cloud adapter on Oracle Integration Cloud can subscribe to these events, so you would need to have OIC for this. Thanks for your suggestion regarding a video. I'm actually finding it difficult to find time to produce new content at the moment, but will consider this for a future release.
Got it, thanks!👍
How can we generate events for modification(create, update) in Oracle SCM objects such as item, inspection plan, work order, etc?
Please take a look at Oracle documentation... docs.oracle.com/en/cloud/paas/integration-cloud/erp-adapter/oracle-erp-cloud-adapter-capabilities.html
Thank you sir, I will look into it👍
Great
thk it was really helpfull
function generateTableFromString(commaSepString, eolDelimiter) { var allRows = commaSepString.split(eolDelimiter); var table = '<table style="text-align:left;border-collapse:collapse;background-color:white;">'; for (var singleRow = 0; singleRow < allRows.length; singleRow++) { if (singleRow === 0) { table += '<thead>'; table += '<tr style="background-color:black;color:white;">'; } else { table += '<tr>'; } var rowCells = allRows[singleRow].split(','); for (var rowCell = 0; rowCell < rowCells.length; rowCell++) { if (singleRow === 0) { table += '<th>'; table += rowCells[rowCell]; table += '</th>'; } else { table += '<td>'; table += rowCells[rowCell]; table += '</td>'; } } if (singleRow === 0) { table += '</tr>'; table += '</thead>'; table += '<tbody>'; } else { table += '</tr>'; } } table += '</tbody>'; table += '</table>'; return table; }
Do we have an option to clone the model.?
Hi, I have stiched payload and send it to target inside a loop.After sending the stitched payload, my loop start again and wanted to create fresh stitch with new set of values and invoke target with new set of values only. But when stitching starts again, old set of values also getting stitched along with the new stitched value. How we can null previous values as well as element so we can invoke target again with new stitched value only ?
Can you please share the JS and Integration pack as well? , its a very important concept. Thanks for your effort and sharing this concept