Oracle Application Framework (OAF) & Workflow Bonus Sessions

Configure JDeveloper for Oracle application framework by selecting the correct plugin version and unzipping the package. Create a workspace, application module, and sample page with proper naming conventions.

Discover how Oracle Application Framework uses items and regions to design pages, build an MVC structure with text input and submit button, and handle button clicks in the controller.

Explore how link, image, and icon items trigger dynamic events in OAF pages, handle client actions, and pass parameters to navigate to destinations.

learn to display database table data with a view object in oracle application framework by building a model-view-controller design and a simple, paged, read-only table.

Learn to build a list of values (lov) in Oracle Application Framework using MVC, with a database query for operating units and mapping to return the selected value.

Demonstrate the PopList sample in OAF, designing a drop-down with ledger IDs and login names, retrieving the selected value, and handling the poplist event to display details.

design a simple search page using a region style query bean, enabling purchase order and supplier name searches without java logic, via result-based construction mode and query parameters.

Design a search page in Oracle Application Framework (OAF) using QueryBean and AutoCustomizationCriteria, converting query criteria to dropdowns, mapping the search panel to results, and configuring page regions.

Design a manual search page in OAF with java logic and region layouts to query item data by inventory item or item number.

Learn to perform DML using entity objects in Oracle Application Framework by implementing CRUD operations (insert, select, update, delete) on a custom table via a page table region.

Learn to perform DML with entity objects in Oracle Application Framework, including insert, update, delete, and read via wrappers, using primary keys and programmatic and view-based approaches.

Deploy an OAF page by copying class and XML files to the server, then deploy page XML to the database and register the page with a function and menu.

Explore OAF debugging techniques using System.out.println logs, breakpoints, and watch lists to trace code execution. Enable diagnostics and GBM debugging from project properties to view runtime queries and generated statements.

Create and deploy a shared region in Oracle Application Framework to display user and employee details across pages, using region design, controller, extenders, and testing in context.

Learn how to integrate OAF components by displaying lookups, validated values, and messages using read-only lookups, dynamic queries, and tokenized or bundle-based messages with practical examples.

Learn when to use SQL statements, prepared statements, and callable statements in OAF, and how to invoke PL/SQL functions and procedures from Java via JDBC.

Explore invoking an OAF page from a standard form using form personalization, passing parameters to a custom page and validating with diagnostics and impersonation.

Explore how to use the OAF switcher region to conditionally display icons based on a value, converting a column into a switcher region with image cases.

Learn to populate a global temporary table using a PL/SQL package, pass parameters, handle exceptions, and invoke the package from Java in OAF to display complex data per session.

Explore descriptive and key flexfields in Oracle Application Framework (OAF), and learn how descriptive flexfields extend applications without core changes, display data, store values, and control behavior.

Explore invoking concurrent programs, passing parameters, and submitting requests via the job API in Oracle Applications, and learn to invoke workflows and work with table value sets.

Master the master-child page with partial page rendering using spel to refresh region or item. Apply logic to enable or disable rendering of buttons and components for user interface control.

Learn to build a two-page Oracle Application Framework mini project featuring an invoice header and lines, with search, view, update, and attachments, using page regions, lookups, and parameter passing.

Explore how OAF integrates with XML reports to manage data, images, and reporting workflows, addressing delays and evolving decisions in complex processes.

Demonstrate a mini project in Oracle Application Framework and workflow, building a two-page flow with a search page and an environment page, featuring create, delete, update actions and regions.

This mini project session enhances the page with a status lookup that auto publishes records and enables view, update, and delete, plus parameter-driven navigation.

Review invoice header and lines design in Oracle Application Framework (OAF) and workflow, outlining entity and view objects, line region rendering, and practical programmatic rendering strategies.

Explore implementing a mini project with currency dropdowns and line type lookups, attach documents, and map line meanings to display values while validating line and header amounts.

Learn the difference between personalization and extension in Oracle Application Framework, including how to enable profiles, personalize pages and regions, and migrate personalization via XML.

Understand oaf extension concepts in the oracle application framework, including personalization vs extension and c extension for custom logic versus query changes, with a practical end-to-end workflow.

Explore how to personalize and extend Oracle Application Framework pages by adding items and regions, configuring events, and implementing business logic through site-level extension.

Explore OAF CO extension basics for the buyers work center, including percolation, personalization, and debugging. Learn how to copy Java classes, enable diagnostics, and validate extensions on pages.

Master OAF VO extension in Oracle Applications, including when to extend, substitution, and binding. Create a new project, gather class and XML files, and apply personalization.

Implement the OAF VO extension for the buyer work center by following nine steps to extend views, manage substitution, and deploy personalized pages via XML files and decoders.

Explore how the Oracle workflow tool provides a graphical, code-free environment to design items, processes, functions, and notifications, store workflows in database, invoke via API, and monitor status.

Design an approval workflow in OAF with supervisor notifications, employee responses, and information versus approval messages, and connect it to PL/SQL procedures while validating end-to-end notifications.

Learn how to embed region information in a notification, register the region as an OAF region function, and pass parameters, with examples of messages and attaching documents to notifications.

Explore Oracle workflow basics: standard components, standard files, copying to custom items, and configuring start and end activities with notifications and business events.

Learn how to send broadcast notifications to multiple users by defining a rule and assigning runtime roles, and handle workflow responses with a valid response procedure.

Display dynamic original content in Oracle Application Framework notifications and attach the same content as a workflow attachment using a custom API and XSLT.

Configure JDeveloper for r12.2 in Oracle Application Framework, set the environment, establish a database connection, create a workspace, and build a hello world page for application development.

Learn how to build a read-only page in Oracle application framework by linking a view object to an application module, querying cursor data, and displaying it in a table region.

Learn to implement lov and poplist components in Oracle Application Framework (OAF), enabling query-based dropdowns with search, value selection, and form value transfer to other components.

Design and implement an AP invoice search page in Oracle Application Framework using a lov and a poplist parameter, with model-view-controller structure and dynamic query logic for non-mandatory inputs.

Explore how an entity object (EO) wraps DML on purchase orders, enabling create, read, update, and delete through view objects and pages in Oracle Application Framework.

Deploy Oracle Application Framework pages in EBS R12.2.9 and R12.1.3 by organizing model-view-controller files and deploying XML pages with the XML importer, then validate deployment in the database.