Oracle E-Business Suite (R12.1.3) Technical RICEW

Master the basics of SQL for Oracle apps, covering DDL and DML, select queries with from, where, group by, and having, plus null handling with NVL and decode.

Explore relational databases in Oracle ERP and master joins, including inner, equijoins, outer (left) joins, self-joins, and Cartesian joins with employee and department data.

Learn pl sql as a block oriented language for Oracle databases, covering declare begin exception end, anonymous versus named blocks, variables, dbms_output, and loops.

Explore PL/SQL procedures and functions, compare their usage, and learn packaging basics. Understand parameter modes (in, out, inout), calling methods, and the role of package specification and body.

Learn PL/SQL complex data types, including records and collections, with arrays and associative arrays, and explore bulk collect and bulk insert for high-volume data processing.

Learn plsql packages, including specification and body, and how to declare and invoke subprograms. Explore bulk collect and bulk insert for large data, plus truncate versus delete.

Explore RDF reports in Oracle E-Business Suite, compare Oracle Report Builder and Oracle XML Publisher, and learn to design data model, layout, and output formats for actionable business information.

Learn to design RDF reports with bind parameters in Oracle E-Business Suite, create colon-prefixed input parameters, validate binds, and wire value sets for organization and header IDs.

Learn to initialize the Oracle apps API for multi-org access, enable underscore global, and test synonyms, then design a parameterized purchase order report using value sets and dependent lookups.

Apply lexical parameters to modify runtime where clauses using ampersand, distinguishing lexical from bind parameters; implement after parameter triggers, format triggers, and placeholders for dynamic reports.

Explore how Oracle reports triggers work (before/after parameter, before report, between pages, after report) and master-detail reporting, including data models, XML outputs, and parameter handling.

Demonstrates global temporary tables and lexical parameters, compares them with normal tables, and guides designing, populating, and triggering data for complex Oracle reports.

Learn to design XML Publisher reports in Oracle E-Business Suite by combining data logic, layout, and translation with templates in PDF, HTML, or Excel.

Explore XML Publisher group reports and hierarchical data display, using grouping levels, parent-child structures, and aggregates (sum, average, minimum, maximum) across header and line data examples.

Explore using Excel templates in Oracle XML Publisher to design single-sheet and multi-sheet reports, configure lookups, register Microsoft Excel templates, and define data groups and tags.

Explore xml report techniques using the data template approach with global temporary table logic, employing before and after report triggers to populate and display data for sales orders.

Demonstrates bursting XML reports in Oracle E-Business Suite, covering data templates, bursting control files, runtime template selection by nationality, and multi-channel output (printer, email, fax, file).

Build a single PL/SQL main program that calls an XML publisher report and a bursting process, then attach the bursting output to a specific entity as attachments.

Explore designing xml publisher reports with dynamic columns in oracle e-business suite r12.1.3, using data-driven column generation, row/column grouping, and pivot table concepts to adapt to changing data.

Explore generating XML from PL/SQL with the ad layout API, designing the XML data model and template, and invoking the template via a concurrent program.

Explore how the SQL loader utility loads data from a data file into an Oracle table using a control file, with log, bad, and discard files.

Master the GL interface in Oracle E-Business Suite using the open interface approach, moving data from staging to interface tables and running the general import program.

Learn to import and update inventory items via the open interface approach, loading data from csv with a control file into a staging table, validating, and creating or updating records.

Use form personalization to invoke concurrent programs and custom forms via a special menu, with prerequisites like assigning the program to the request group and mapping launch actions.

Learn to develop Oracle forms in the e-business suite: configure forms path, use templates, design a window, canvas, and data block for xl_invoice_header, then compile and register.

Build a master-detail form in Oracle Form Builder by creating a department data block as master and an employee data block as detail, wiring a proper relationship and tabular display.

Learn how the Oracle E-Business Suite workflow builder designs items, processes, notifications, and messages using PL/SQL, stores workflows in database, and enables PL/SQL API invocation.

Explore designing for your action workflow with supervisor and employee notifications, approval/reject paths, start and end nodes, messages, attributes, and PL/SQL API calls.

Learn how to embed region information in Oracle E-Business Suite notifications, including region path, function invocation, and parameter passing, plus attaching documents as blob content.

Learn to reuse standard workflow components from STD files in a custom item, configure attributes, and implement wait and timeout; explore business events with subscriptions and workflow integration.

Explore two workflow samples in Oracle E-Business Suite (R12.1.3): broadcast notification and notification response validation. Learn to create a rule, assign users, and validate responses.

Learn how to display dynamic HTML content in a notification, fetch the content from plsql, and attach HTML as both content and an attachment within a workflow example.

Implement gl inbound integration in oracle e-business suite with a shell script, sql loader, and plsql api to read csv files, load staging and gl interface data, and run import.