Oracle Cloud ERP(SaaS) Technical- ICS/VBCS, Dell Boomi Bonus

Explore Oracle cloud erp bi reports by navigating to reports and analytics, building a data model from an sql query, and creating a simple tabular report. Archive catalog for migration.

Learn how to design and publish simple Oracle Cloud ERP reports using data models, templates, and publisher navigation—from queries and data sources to exporting PDF or HTML outputs.

Design a parameterized report by defining a data model and layout, using a user input parameter (person number) to filter data via a query and list values from the database.

Explore parameterized reports in Oracle Cloud Publisher by building dependent project and task parameters, with list of values, refresh on change, and template level grouping.

Register a report as a job in Oracle Fusion Cloud ERP via setup and maintenance, configure the report ID and job type, then schedule and republish outputs from templates.

Learn how to design and upload an Oracle Fusion Reports Excel template using a BI Publisher plugin, define data models with queries, set metadata, and generate reports from Excel output.

Explore invoking a soap web service from python to run a dynamic sql-based report via the Public Report Service, returning output from a ref cursor without changing the data model.

Explore BI Publisher reports in Oracle Cloud ERP using Excel templates to generate XML, HTML, and text outputs, with header and lines data models.

Design a parameterized Oracle Cloud report using a data model and data source, register a parameterized enterprise scheduler job, and migrate or deploy the report across instances.

Identify the standard BI report, copy its template to a custom folder, and modify the template to customize outputs, while optionally updating the data model and validating results.

Design a data model and template in BIP to generate QR code and PD417 outputs, mapping data to QR code data using Oracle syntax and selecting PDF as default output.

Explore how to design and deploy sub templates in Oracle Cloud ERP publisher, including header and footer templates, and learn to upload, invoke, migrate them using import and template tags.

Learn to build Oracle cloud ERP dashboards in SaaS, including analyses, prompts, and dashboards with key performance indicators (KPIs) and business metrics, and export to Excel, PDF, or HTML.

Learn how to build Oracle BI batch reports with section context switching, using for each and group links to generate multi-invoice PDFs with correct per-invoice page numbering.

Learn to render blob images dynamically in a report by converting blob content with an input stream in a template and resizing using inches, pixels, or percentage.

Learn to render a dynamic star rating in reports using for each and shape offset, driven by user rating values with a position function and modulus-based party rating examples.

Explore translating Oracle reports with xliff templates to produce multilingual outputs. Understand xliff structure, source and target languages, language codes, and testing via scheduler and end jobs.

Hide a specific Oracle standard catalog folder for non-admin users by removing it in the custom by Webcat reporting duty, then run the import job and verify after refresh.

Create an ESS job for a VIP report using dependent value set parameters, with an independent ledger name and a year-dependent parameter feeding a third mapped parameter.

Explore global level functions in Oracle Fusion VIP reports, creating group aggregates like invoice count and total invoice amount across invoices and lines, and designing RDF templates for display.

learn to schedule a bi report dynamically by passing date parameters (current date, first/last day of month) and set monthly or daily schedules with email notifications.

Learn to secure a BI report by creating a custom BI abstract role, assigning it to a user, and configuring BI catalog folder permissions for controlled access.

Discover how to customize the standard pivot PDF report for the purchase order in Oracle Fusion by duplicating the report to the custom folder, uploading a template, and configuring it.

Customize the standard pivot pdf report in Oracle Fusion by copying it to the custom folder via the xmlrpc server. Upload and apply a modified template for purchase order pdf.

Learn to design parameter-based OTBI reports with no SQL, enabling business users to filter by ledgers, asset books, and asset numbers through prompts and subject areas.

Explore an OTBI report drill-down sample that links invoice numbers to a web page to display invoice details, with URL parameters and a hyperlink to open in a new window.

Learn to display a custom OTBI report as an infolet on Oracle Cloud pages by enabling a sandbox, using page composer, and configuring count and detail reports.

Design an OTBI report from the data model, add bursting logic, and configure a job to send email alerts using a matching template.

Explore bursting OTBI reports in Oracle Fusion using an agent, configure schedules and delivery options, and publish reports to email or attachment through actionable intelligence.

Design a pivot view in OTBI analysis by selecting general ledger data, filtering to 2023, and dragging fields like accounting period, ledger name, source, and category to summarize by period.

Explore inbound interface and implement supplier creation with SOAP-based web services in Oracle Cloud, validating the WSDL via SoapUI and providing supplier name, business relationship, and tax organization type.

Discover how Oracle Cloud ERP exposes SOAP and REST web services, test with SoapUI, Postman, curl, and discover WSDL for supplier operations with username token authentication.

Explore creating messages in the Oracle Cloud ERP UI and uploading them with REST API using a three-file data loader (manifest, messages, message_tokens) zipped and sent to payables import.

Use the ERP integrations REST API to upload attachments to Universal Content Management (UCM) by sending base64-encoded content in a JSON payload, authenticated via basic authentication and tested with Postman.

Create and manage payable invoices using REST in Oracle Cloud ERP. Fetch, create, and validate invoices via REST API, including header and line data from the UI and Postman.

Create expense reports in Oracle Fusion using the UI and REST API, leveraging templates, views, and expense types, then validate and attach line items via Postman and check status 201.

Explore loading GL data with FBDI in Oracle cloud ERP, from creating a CSV via an Excel macro to uploading to UCM and running load interface and import journals.

Explore importing contracts into Oracle Cloud ERP via FBX inbound interfaces, generating a zip of CSV files from an Excel template, then mapping fields and running manage file import activities.

Explore purchase order import using FBDI in Oracle Cloud ERP, including the four sheets and corresponding interface tables, and the two-step load from interface to base tables.

Import contract purchase agreements into Oracle Cloud ERP using FBDI, preparing header and global interface data, scheduling the import, and validating results through interface error checks.

Explore the simplified spreadsheet approach for customer conversion in Oracle Cloud ERP, generating csv files from an excel template and loading data into interface and base tables.

Master loading supplier attachments in Oracle Cloud ERP via FBDI, covering supplier profile, site, and business classification attachments. Follow steps for file and zip handling, content validation, and import processing.

Learn to import payable invoices in Oracle Cloud ERP using FBDI, creating header and line data in CSV, loading via interface tables, posting to GL and subledger, and validating results.

Learn to import sales orders into Oracle Cloud ERP using the VDI template, mapping header, line, and address data with mandatory fields like source transaction and party identifiers.

Learn how to import a one-time payables payment request in Oracle Fusion using FBI templates, load via the interface to base tables, and validate with reports and the invoices UI.

Learn to bulk upload lookup types and values using a pipe-delimited csv file-based import in Oracle, loading via UCM and importing through Manage Common lookups.

Explore the inbound interface with FDI, the application development framework desktop integration, via an Excel add-on that connects Excel to Fusion using MVC architecture for general ledger imports with validation.

Learn to upload general ledger daily rates into fusion ERP using the create daily rates template, load into the interface and base table, and run import and calculate daily rates.

Explore Oracle Integration Cloud Service as a cloud-based integration platform that connects on-premise and cloud applications using adapters and connections for seamless data flow.

Set up a basic rest-to-rest routing integration with a trigger request and an invoke response, then map the employee id to the Apex rest web service endpoint to test.

Learn to design and test a simple rest web service in Oracle Cloud ICS, navigating the integration designer, creating a rest trigger connection, and deploying a rest echo integration.

Learn how to invoke an Oracle Cloud REST API from ICS using trigger and invoke connections, map supplier id, and test the JSON response.

Configure ICS to invoke Oracle Cloud ERP soap web services using a WSDL, with a trigger and soap connections, to create a supplier via the create supplier operation.

Learn how to install and configure the Oracle Integration Cloud connectivity agent on Windows to connect Oracle Cloud ERP with on-premise databases and apps.

Learn FTP inbound to outbound with Oracle Integration Cloud, reading files from the inbound directory and writing to the outbound directory via a scheduled orchestration and for each loop.

Learn to use the Oracle cloud adapter in OIC to import payable invoices from FTP in one step, mapping file details to ERP Cloud with minimal coding.

Learn how to invoke an Oracle Cloud ERP BI report from OIC using a SOAP WSDL, configure the SOAP connector, pass report parameters, and handle the base64 payload output.

Read files from an ftp inbound directory, download them, zip them with a stage file, and write the resulting zip to an outbound ftp location.

Learn to implement end-to-end ERP cloud data import using Oracle Cloud Marketplace recipes, wiring FTP sources to ERP cloud adapter and FBDI for journal entries.

Explains publish to OIC and subscribe to OIC integration styles, showing how to publish messages via a rest publisher and subscribe to a queue to write to an FTP folder.

Explore Oracle integration cloud offerings—integration cloud services, process cloud service, and visual builder cloud services—and design, publish, test, invoke, and monitor a simple process application with no coding.

Learn to invoke a rest web service from Dell Boomi using the http client, including configuring the connection, operation, and Json response profile for Oracle Cloud ERP.

Learn to load data from a CSV file into a database using Dell Boomi, including disk read, Oracle connection, mapping to employees, and dynamic insert.

Explore Dell Boomi, using logical shapes, execute shapes, and mapping to read employee data from the inbound directory and route records to outbound via a split document with department conditions.

Explore how Dell Boomi logical shapes enable parallel execution using branch and root, handling inbound directory files, routing by name to department and employee outlets, with get and send operations.

Learn to invoke a soap wsdl service from Dell Boomi, read local xml files, map payloads, and call the Oracle Cloud ERP create supplier operation for an inbound interface.

Read files from ftp and write them to ftp using a ftp connection, configure inbound and outbound directories, and apply get and send actions in a Dell Boomi workflow.

Explore the foundations of Oracle Visual Builder Cloud Service, Jet, and MVVM architecture, including REST endpoints, business objects, templates, and drag and drop plus coding.

Explore Oracle visual builder cloud service (VBCS) to design web and mobile pages with drag-and-drop components in a browser, using minimal code and REST data bindings to Oracle ERP Cloud.