Oracle Application Framework(OAF) - Beginners to Expert

Learn to set up the Oracle Application Framework workspace and project in JDeveloper, configure environment variables and database connections, and build a hello world page with a controller.

Create a hello world page in Oracle application framework, implement a controller, and use page context and web context to handle user actions with process request and process form request.

Learn to build a result based search page in Oracle Application Framework (OAF) using an application module, a view, and a query region with a result table.

Explore Oracle Application Framework basics from beginner to expert, focusing on auto customization criteria search, result based search, and manual search with query regions and view objects.

Learn to build a manual search page in Oracle Application Framework, using a custom table and view, a view object, and a search panel with runtime where clauses.

Explore how a controller interacts with the application module, view object, and view to implement a manual search, using page context, bind parameters, and a query with a where clause.

Attach a list of values to the search page using external views; map region and return items; create a view object for order numbers and configure the lov region.

Learn how to implement dependent LOVs in Oracle Application Framework (OAF), linking org ID and order number through views, regions, and prompts, with deployment, mapping, and debugging guidance.

Learn to deploy Oracle apps pages and regions using MDS and XML importer, including Java compilation. Register as functions in the front end and attach to menus, noting 12.2 changes.

Learn to build an order search in the Oracle application framework, including a searchable page with results and a linked order detail page that passes the order number.

Learn to configure order detail in OAF by creating views and regions, linking operating unit and order number, and implementing manual search with form value and org id mappings.

Learn to build an insert page in OAF, clear fields, and save data. Create an item create page with a view, region layouts, and a button bar.

Explore navigating from the order search page to the item create page in Oracle Application Framework using page context set forward URL, breadcrumbs, and hash map parameter passing.

Explore delete functionality in OAF by adding a delete image to the result table, firing a delete action, and removing a single row from the order headers view.

Learn to create a distinct update page in OAF using a separate view to avoid cache retention, wire a save flow, and enable partial page rendering with spell-driven render logic.

Learn to implement an Oracle Application Framework delete confirmation using a standard dialogue page with yes/no buttons, hash table parameter passing, and post actions.

Explore the spell expression to dynamically render controls in oaf using a boolean transient attribute on a view object and a fire partial action.

Explore partial page rendering in OAF using a boolean transient view attribute and a spell-based render condition to show or hide descriptions based on segment one value.

Explore partial page rendering (PPR) in Oracle Application Framework (OAF), firing a partial action on quantity and value events to auto-calculate total via string-to-number conversion and multiplication.

Learn how to call a plsql procedure from oaf, using a simple page with a text box to update all employee salaries by a given percent via a callable statement.

Learn how to call a PL/SQL package procedure from OAF to save data, submit a report, and trigger a concurrent program with in and out parameters.

Learn to run a SQL query from OAF by submitting a concurrent program with a vector of parameters, passing values in order and retrieving the request id.

Learn how to call a concurrent program from oaf using a standard concurrent request class, pass arguments via a vector, manage jdbc connections, and handle the returned request id.

Explore how to add a page in Oracle Apps by registering a function, ensuring data table initialization, and passing user id, responsibility, and application short name to a concurrent program.

Explore master-detail oaf pages in 12.2, using radio selections, transient attributes, and view instances to refresh lines with partial page rendering, plus jar creation and bounce differences.

Create tabbed interfaces in Oracle Application Framework by building a sub tab layout region, content containers, and subtabs, and apply fire partial action for fast tab updates.