Aria is used globally within Oracle to look up phone numbers, email addresses and other information about employees.  Each employee can update his or her preferred contact information and upload an image for the employee profile page.

This version has been updated to include Web 2.0 elements that are outlined in Oracle Magazine, September/October 2007 - Express Web 2.0. If you would like the previous, 2.2 compatible version, you can download it here (aria_people_search-0.91.zip).

Minimum Release:  3.0
Version:  0.92
Last Updated:  17-Aug-2007

Links:  screensnap, preview
Download:  aria_people_search-0.92.zip

An application that manages artwork.  It is loaded with pointers to many of the icons that we use with Application Express and you can load your own.  You can also repurpose the application all together.

Minimum Release:  3.0
Version:  1.0
Posted On:  Coming Soon

Links:  screensnap, preview

Ask the Expert is an application based on Ask Tom (http://asktom.oracle.com).  Using this application, users can post questions to an expert and the expert can answer.  The application is powered by interMedia for text search.  The expert has the full power to control the application, by limiting the number of questions allowed, blocking new questions completely, and easily managing the other content on the site.  The expert can also request additional information on questions, and choose when to publish a question.

Minimum Release:  3.0
Version:  0.9
Update On:  28-Jan-2008

Links:  screensnap
Download 3.0:  ask_the_expert_0.9.zip (2.2 version)

This is basic Asset Manager used for managing Asset Details and an inventory history.  Users can create new Assets, modify the details of existing Assets, view inventory details and track missing assets.  In addition to a few built-in report, users can use the custom report.

Minimum Release:  3.1
Version:  1.1
Posted On:  19-Sep-2008

Links:  preview
Download:  asset_manager_1.1.zip

(3.0 compatible, 1.0 version:  asset_manager_1.0.zip)

Bug Tracker is a software bug tracking application.  It is used to file bugs and monitor the bug status for multiple products.  It allows you to search and run reports.  Many of the bug attributes are customizable to suit your business needs.

Minimum Release:  3.0
Version:  1.0
Last Updated:  03-Mar-2009

Links:  screensnap, preview
Download:  bug_tracker_1.0.zip

The Checklist Manager is an application that can be used to track the progress of completing things.  You create a checklist and define the columns and rows - essentially, a matrix.  You then 'check off' your accomplishments and can track your progress both visually, and with percent complete.

Minimum Release:  3.0
Version:  1.0
Posted On:  28-Jan-2008

Links:  screensnap, preview
Download:  checklist_manager_1.0.zip

This is a basic Customer Tracking Application.  It can manage Customers, Contacts and Activity details.

Minimum Release:  3.1
Version:  1.1
Posted On:  3-Mar-2009

Links:  screensnap, preview
Download:  customer_tracker_1.1.zip

(3.0 compatible, 1.0 version:  customer_tracker_1.0.zip)

This demo contains two Application Express applications that demonstrate DICOM support in Oracle 11g Database.

In the DICOM Image Archive Demo application, users can import and export DICOM images; retrieve the full (original) size DICOM image in JPEG format, the JPEG thumbnail image, and the metadata for each DICOM image; edit the attributes of each DICOM image; process the content of the DICOM images; validate each DICOM image based on the constraint rules, and make the selected DICOM images anonymous. The application also provides keyword searching, field searching, and semantic searching capabilities to search within the DICOM image archive.

In the DICOM Image Archive Admin application, administrators can insert, delete, and export DICOM repository documents.

Minimum Release:  3.2
Version:  1.1
Posted On:  13-Aug-2009

Links:  screensnap ,  preview Image Archive ,  preview Administration
Download:  dicom_1.1.zip

The Discussion Forum is a powerful and fully customizable message board solution.  Based on Oracle Application Express and the Oracle Database, the Discussion Forum offers threaded discussions organized by different topics, built-in user and forum management, mailing-list-style forum watching and a message search feature based on Oracle Text.  Taking advantage of the new Oracle Application Express Supporting Objects utility, the Discussion Forum application is very easy to deploy by having the application export, its corresponding images, database object creation scripts, and seed data all packaged into a single file.

Minimum Release:  2.2
Version:  0.92
Last Updated:  28-May-2007

Links:  screensnap
Download:  discussion_forum_0.92.zip

The Document Library is an application centered around collaborating on one or more documents.  Members work on documents in the document library, assign each other tasks, and share links pertaining to research for the documents.

All direct reference in the application to calling the procedure get_doc have been replaced with a link to page 2 of the application which in turn redirects to the get_doc procedure.  This was done for compatibility with the embedded PL/SQL gateway in Oracle Database 11g.  Details are contained in the readme.

Minimum Release:  3.0
Version:  0.92
Last Updated:  03-Dec-2007

Links:  screensnap, preview
Download:  doc_library_0.92.zip

(2.2.1 compatible, old version:  doc_library_0.91.zip)

Events is an application used to publicize events.  Users can view events via a report or calendar and can register for events and ask for reminders of their registrations.

Minimum Release:  3.0
Version:  1.0
Posted On:  03-Dec-2007

Links:  screensnap, preview
Download:  events_1.0.zip

The Issue Tracker is a simple application that allows the definition, assignment, status and progress of issues as they relate to projects.  The code contained in this file is the result of the Oracle Application Express Advanced Tutorial, How to Build and Deploy an Issue Tracking System.

Minimum Release:  3.2
Version:  1.0
Posted On:  3-Mar-2009

Links:  screensnap, preview
Download:  issue_tracker_1.0.zip

(2.2 compatible, old version:  issue_tracker_0.9.zip)

This application can be used to test knowledge.  It comes pre-loaded with tests for Animals, APEX General Knowledge and US National Parks.

When you take a test, you progress through a serious of questions.  The answers can be text or images.  Your test is timed and your score is presented upon completion of if you [Quit].  All your test results are available under My Results.

There is an Administration tab that allows you to define tests as well as export tests.

Minimum Release:  3.0
Version:  1.0
Posted On:  06-Aug-2007

Links:  preview
Download:  knowledge_testing_1.0.zip

This is a basic Loan Calculator application.  It can be used to calculate monthly payments for various loans.  Users can enter the loan details (loan term, interest rate, loan amount, down payment) to view the loan schedule.  The Loan Schedule can be viewed as a report or a chart.  Users can also save their loan information to view/analyze at a later time.  In addition to payments and payment schedules, users can calculate how long it would it take to pay off a loan.  Users can also calculate an amount that can be borrowed based upon the monthly payment that can be afforded along with loan term and interest rate.

Minimum Release:  3.1
Version:  1.1
Posted On:  19-Sep-2008

Links:  preview
Download:  loan_calculator_1.1.zip

(3.0 compatible, 1.0 version:  loan_calculator_1.0.zip)

Online Store illustrates purchasing products online.  There is no need to pre-register.  When you place your first order, an account is created for you.

Please note that this packaged application is completely different from the Oracle Store application.

Minimum Release:  3.0
Version:  1.0
Last Updated:  21-Dec-2007

Links:  preview, screensnap
Download:  online_store_1.0.zip

Sales Forecasting allows you to track sales opportunities, with the ability to guide opportunities through the sales cycle using a customizable progression of steps to close.

Minimum Release:  3.0
Version:  1.0
Posted On:  07-Sep-2007

Links:  preview
Download:  sales_forecasting_1.0.zip

The Software Projects Application is a basic Project / Task tracker.  You can manage multiple projects along with their associated releases, tasks, milestones, and features.  The Application Express Team uses a version of this application to track its activities.
The current download has a few new features.  They are detailed in the readme.

Minimum Release:  2.2
Version:  0.93
Last Updated:  21-Dec-2006

Links:  screensnap
Download:  sw_projects_0.93.zip

This application is a generic version of the application used by Oracle to list our Oracle ACEs.  Oracle ACEs and Oracle ACE Directors are known for their strong credentials as Oracle community evangelists and technical educators, with candidates nominated by anyone in the Oracle technical community.

This version of the application uses more generic terminology (Subject Matter Expert), and uses a generic theme (rather than the one customized for OTN).

Minimum Release:  3.0
Version:  1.0
Posted On:  06-Aug-2007

Links:  preview
Download:  subject_matter_experts_1.0.zip

This application is a web based task tracking system.  Each user assigns and/or creates their own tasks.  Tasks are assigned to projects that are created by administrators.  When creating a task, a user can either define a new task or select from the list of predefined tasks.

Minimum Release:  3.1
Version:  1.1
Posted On:  19-Sep-2008

Links:  screensnap, preview
Download:  task_manager_1.1.zip

(3.0 compatible, 1.0 version:  task_manager_1.0.zip)

This application is a web-based time tracking system.  Each user enters their timesheet details on a weekly basis (either a 5-day or 7-day week can be chosen).  Time is allocated to time codes that are set up by administrators.  In addition to entering new ones, a user can view their past timesheets but may not edit them.  Only administrators can edit timesheets.

Minimum Release:  3.0
Version:  1.0
Posted On:  06-Aug-2007

Links:  preview
Download:  timesheets_1.0.zip

Visit our Web Services Integration page for sample code and whitepapers about how to integrate common Web Services, such as Google Maps, PayPal Pro, etc., with Oracle Application Express applciations.

This application is a simple example of creating an External Table on a flat file, then loading that data into a traditional (heap) table.

The installation requires a 10g database, Oracle APEX 2.2 or greater, SQL*Plus access as a dba, and access to the host file system.  SQL*Plus access is required to create the directory and grant read / write permissions to the parsing schema.  File system access is required to place the employees.txt file in the directory created.

Minimum Release:  2.2
Version:  0.9
Posted On:  04-Oct-2006

Links:  screensnap
Download:  External_Table_Simple_0.9.zip

This application is used by the How-To Create a Master-Detail PDF Report.  It serves to showcase Advanced PDF printing in Application Express 3.0.  You can preview the application on apex.oracle.com.

The installation requires Oracle APEX 3.0 or greater with Advanced PDF Printing (meaning, PDF Printing configured using Oracle BI Publisher).

Minimum Release:  3.0
Version:  1.0
Posted On:  16-May-2007

Links:  preview
Download:  md_pdf_howto.zip

This sample application illustrates how Oracle Application Express can be used to manage customers and orders using a matrix order entry screen. It functions as if the end user is a wholesaler, selling commodities. It highlights the use of APEX collections and PL/SQL processes that implement custom logic.

Minimum Release:  2.2
Version:  1.0
Posted On:  22-Oct-2006

Links:  preview
Download:  matrix_order_1.0.zip

The OEHR Sample Objects are used by the Application Express 2 Day + Guide and Advanced Tutorials Guides.

Minimum Release:  2.2
Version:  1.0
Posted On:  31-Jan-2007

Download:  oehr_sample_objects.zip

 

One recurring issue with Application Express applications is the lack of the ability to save item values over 32k. This application is an example of using AJAX to save and edit over 32k of text from a textarea.

Minimum Release:  2.2
Version:  0.9
Posted On:  04-Oct-2006

Links:  preview
Download:  Save_Large_Value_0.9.zip

The Oracle Application Express v3.0 Showcase Application highlights some of the new features of Application Express.  Features highlighted include:

• PDF Printing
• Calendar Enhancement
• Web Services Enhancement
• Flash Charts
• New Item Types

Minimum Release:  3.0
Version:  1.0
Posted On:  23-Apr-2007

Links:  preview
Download:  showcase_v3.0.zip

A shuttle is a combination of two multiselect lists where values can be moved between the two it is useful for quickly moving and sorting multiple values between two lists and saving the changes.  The shuttle in this example also has the option to turn on and off sorting on each list individually and the option to enforce copying items instead of moving items.

Minimum Release:  2.2
Version:  0.9
Posted On:  02-Aug-2006

Links:  preview
Download:  shuttle_demo_0.9.zip

The Southwind Wholesalers application is the result of the Access Migration Tutorial.  You can preview the application on apex.oracle.com.

Minimum Release:  3.0
Version:  1.0
Posted On:  31-May-2007

Links:  preview
Download:  southwind_wholesalers_1.0.zip

One of the standard region templates is a Hide and Show Region template.  It is a very simple dhtml construct that is efficient because it does not re-fetch the page from the server.  The only real limitation with Hide and Show regions is that their state is not saved in session state.  This means that if you expand a Hide and Show region, leave the page and then return, the region will be in the default state of Hide, rather than the state in which you left it, which was Show.   This code example illustrates how to use AJAX and Application Express Collections to save the state of a Hide and Show region between page navigation.

Minimum Release:  2.2
Version:  0.9
Posted On:  01-Dec-2006

Links:  preview
Download:  sticky_hide_show-0.9.zip