U of A University of Arkansas Division of Agriculture

Pictures of chickens, flowers, wheat, a boy looking through a magnifying glass, irrigation pipe, soybean pods, and fruits and vegetables.

Cooperative Extension Service

Cooperative Extension Service

 Agricultural Experiment Station


Search | Publications | Jobs | Personnel Directory | Links

BannerAPEX - Oracle Application Express Notes and Projects for Banner

Book Dragon copyright 2006 J. Wilson Spence


Banner Solutions - APEX

Another Tool for use with Banner  

by Bruce Knox  bknox @t uaex.edu    Oracle Database Programmer/Analyst          date last updated 02/14/08

Oracle Application Express or APEX, is a web based rapid application development tool for the Oracle database.  APEX, formerly called HTML DB, is being increasingly adopted by SunGardHE Banner clients for handling stand-a-lone tasks, providing conversions from MS Access applications, or providing Front-End applications for generating input data for Banner.

Please share your APEX applications with other APEX Banner developers via the Banner_ApplicationExpress Listserv that was set up by Joe Manok.  The Listserv address is Banner_ApplicationExpress @t yahoogroups.com 

The Listserv can be joined with your existing email address:

Subscribe to Banner_ApplicationExpress (This is not an endorsement of Yahoo Groups . . .)
                                                                                       

Please use your real name and uni to help us with the SPAM filtering effort.  Alternate join via: http://groups.yahoo.com/group/Banner_ApplicationExpress/join

The Banner ApplicationExpress Home Page is: http://groups.yahoo.com/group/Banner_ApplicationExpress/

Or, let me know about your APEX applications and I will share the information from this site. (of course, no endorsements are implied, see declaimer below).

I had submitted a proposed class for Summit 2008: APEX + Argos = Rapid Development + Great Banner Ad Hoc Reporting!  (details)  But, they did not accept it.  Maybe I will give it at the Argos Pre-Summit.

Let me know if you have made an APEX related proposal and I will post it here.  These I have located:

Monday, April 14, 2008 3:30 PM 4:30 PM
APEX: Fast, Integrated Web Development
Chemeketa Community College uses Oracle Application Express (APEX, formerly HTML DB) as a Rapid Application Development tool to build Self Service applications for students and staff. We've integrated APEX-based applications into the WebTailor security model, so a single sign on lets users access both Banner Self Service pages and APEX-delivered applications; our APEX-delivered applications appear on the Self Service menus. APEX could be used as a reporting tool, but that's not how it shines -- it's designed to facilitate the rapid development of interactive, web-based applications that can manipulate data in your database. We won't teach you everything you need to know to program in APEX -- any Oracle training can do that. We'll focus on how to integrate APEX-developed applications into Banner Self Service. You'll see how to implement a single login to let users access both Self Service and an APEX application, and how WebTailor manages permissions for them. We'll show the database packages and WebTailor entries we use to implement the integration. We'll demonstrate the power of APEX and our WebTailor integration by building a simple APEX-based report. We'll also demonstrate mature APEX-based applications used at Chemeketa, including advanced techniques such as AJAX.


Tuesday, April 15, 2008 8:30 AM 9:30 AM
Student Assessment by Non-Employee Supervisors

Debra J. Miller
DBA, OCP
Athens State University

Athens State College of Education has driven a project for non-employee supervisors to enter assessment data into the production database. The discussion of this system should be of interest to technical as well as functional users concerned with getting assessment data into a database and using this in conjunction with an assessment management system. This is an add-on to Banner and developed this year primarily in APEX, Oracle's web-based application developer, with additional forms created in Oracle Forms. What this software does is allow non-employees to log on to a web application and enter assessments for student teachers. These assessments are based on rules (also used for faculty assessments in Banner's Self-Service product).This session will discuss the software elements, end user administration (staff responsibilities) and logic as well as the problems encountered. It will also give an overview of how this software fits into our entire Assessment Management System-- a web-based system that pulls the results from the assessment entries (faculty and non-faculty) and evaluates success or failure of objectives and goals.

Wednesday, April 16, 2008 9:30 AM 10:30 AM
APEX Applications for the Banner Student User
Looking for an easy way to roll that schedule and apply prereqs, coreqs and attributes? Rolled a grade that shouldn't have been and now you need to remove it? Want to change a section code without dropping the students from the course? What about those other pesky little things that require IT to go "behind the scenes" to fix? What used to take a phone call or email to Banner Support is now in the hands of the user. Working from Banner Student 7.4, Lehigh Carbon Community College has developed a plethora of "Do it Yourself" tools for the user. During the past year, our tool of choice has become Oracle's Application Express. Let us show you how we have used APEX to make life simpler.
 

My first experience with APEX was with HTML DB 2.0 and Oracle Express in a stand-a-lone installation.  I saw great promise in it at that time (early 2006).  Now, we are trying APEX for non-Banner development.  Plus, I hope to use APEX to automate the maintenance I currently perform on a number of Oracle Tables I use in my Banner SQL*Plus programming and Argos Reporting.

I already know of Banner Sites using APEX.  There was a Summit 2006 session on HTML DB, but I saw nothing on APEX for Summit 2007? 

Searching the Summit 2007 CD (finally got here) turns up these classes with APEX content:

Banner Finance and AR Kick-Off
Presented by: Elsa Everling, Product Manager
SunGard Higher Education
March 19, 2007
Course ID 1108
page 44 only

ODS Self Service Reporting
Presented by: David Killip
Banner Reporting and Analytics,
SunGard Higher Education
March 21, 2007
Course ID 1174

Extending ODS SSR  (basically, the HowTo behind "ODS Self Service Reporting" above)
Presented by: Lloyd Lunham
SunGard Higher Education
March 21, 2007
Course ID 402

 

I do need links and OKs to reference your uses of APEX!  Contact me via Banner_ApplicationExpress or directly bknox @t uaex.edu

Hit Counter

Banner Related APEX Applications:

Billing system for our Promotions and Publications - for reproduction/postage expenses entered independently of Banner.
Debra J. Miller Debra.Miller @t athens.edu
Athens State University

Catering Event Request/Reservation System - used by Dining Services Department.
Charles Schroeder charles.e.schroeder @t lawrence.edu
Lawrence University

Tailor Your Own Web Using HTMLDB - Summit 2006 Session ppt includes references to Campus Directory, Annual Giving Volunteers Tools, . . .
Indira Persand and Amy Michelson
Wellesley College

Installation Instructions for APEX 3.0 and its prerequisites required for it, as was done for our web applications development server.  This is a non-Banner Oracle server, but we do have some database links to our Banner server from this machine.
Steve Rea 
Configuration information will follow soon.

Banner Upgrades, Banner Upgrade Tracking
Marianne Gillfillan Marianne.Gillfillan @t cais.cus.edu
Concordia Administrative Information System

Mailmerge - Admissions Communication Plan generated materials.
Cy Ball cy.ball @t du.edu
University of Denver

Project - A project control system with project requests, test dates, completion dates.
Cy Ball cy.ball @t du.edu
University of Denver

Population Selection - We have many requests to fill a Pop-Sel. Usually a spreadsheet with one of the columns being a list of pidms. This application allows the requestors to copy the spreadsheet pidm column and paste it into a Text area in this application. Then load a temporary "pidm" table from the pasted pidms. Finally, select the Application, Selection, Creator, enter a user and load the Pop-Sel.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

TIAA-CREF Export  - Extract Payroll data and creates interface file for tiaa-cref, requires custom table in APEX database.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

Pennsylvania Secure ID - Reports students' Pennsylvania Secure ID numbers and displays students who need the ID numbers.  requires custom table in APEX database.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

Duplicate PIDM Utility - Accepts good and bad spriden_id as input. Lists the tables and row counts where they exist side by side. Listed by owner (SATURN, GENERAL, etc). Each Owner has a radio button you select to list the tables. provides the ability to copy table rows from bad pidm to good pidm (except for TBRAPPL and TBRACCD - still being worked on).

Looks for parent/child relationships before attempting to copy and pops up Javascript warnings before and copying or removing of rows.  Shows unique constraints so decisions can be made for removing or copying bad pidm rows.  Uses dynamic SQL and APEX collections.  Uses materialized views of people and table data to speed searching.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

State Unemployment Compensation Processing - Combined a series of SQL statements (normally run manually) into a Tab driven application.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

Email Lookup - Takes spriden_id, looks in GOREMAL, and checks a custom table that contains last access.  Custom email usage tables are update via UNIX cron from data received from our student email system.  If email does not exist in GOREMAL, a "Create Email" button will create an entry in GOREMAL that will automatically create and ftp a file to our student email system.  Used in Enrollment Services.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

LNumber Search (PIDM) - Lnumber is our spriden_id, enter pidm, provides Lnumber.  Handy for people who have a pidm, but need the ID for a Banner screen.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

LNumber Search (SSN) - Same as above, but uses SSN.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

Midterm "T" Grade Management - Terms in selection boxes (selected from SFRSTCR).  Move "T" Grades From Final To Midterm.  Move "T" Grades From Midterm To Final.  Above two also works with TERM + Part Of Term selection.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

Part-of-Term Date Change - Changes the Begin and End dates for classes based on Term, Part-of-Term, CRN.  In selection Part-of-term depends on Term, and CRN depends on Part-of-term.  Changes SSBSECT and SSRMEET.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

Pin Lookup - Enter spriden_id and retrieves GOBTPAC pin.
Wayne Youngblood wyoungblood @t lccc.edu
Lehigh Carbon Community College

GASB Reporting
Jeana Henley
Montana State University

Training Calendar, Scheduling and Registration Tracking - application for staff Banner and other related training.
Jeana Henley
Montana State University



APEX + Argos - Rapid Development + Ad Hoc Reports

Please share your development work with the Banner APEX community!

University APEX sites:

Case Western Reserve University  announces Oracle APEX and APEX for Researchers site

George Washington University

Plymouth State University BLOG includes How To Link to another Oracle Database, such as Banner!

Stanford University School of Medicine   -  A Strategic Planning tool application

Medical College of Georgia

Indiana University - Purdue University Fort Wayne

Cornell University Project List APEX Application

Non-Banner APEX References:

Oracle APEX (Oracle's Application Express site)   Forum

Converting MS Access to APEX  (Oracle Application Express Application Migration Workshop now handles more of the conversion task)

ApexLib - The Oracle APEX Framework to enhance Oracle APEX (Oracle Application Express)

The Power of the Oracle APEX Repository by Patrick Wolf  (ppt file download)

askTom a very large and busy Oracle site that was developed with HTML DB (APEX).

Advanced Application Express Tips & Techniques by Brad Brown,TUSC  56+ minute WebEx recorded presentation
includes: adding pop-up windows, bubble-Help, email, custom login, http links, ...


This is a personal site maintained by Bruce Knox ( bknox @t uaex.edu ) documenting University of Arkansas, Division of Agriculture, Cooperative Extension Service IT projects. 

Disclaimer
Use this information and these scripts at your own risk. As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences.  The scripts and information are provided "as is" without warranty, implied or otherwise.  Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:)

Any University of Arkansas Division of Agriculture website Disclaimer terms found in conflict with terms of this disclaimer shall over ride and replace the conflicting terms found herein.

Other personal pages/sites that I maintain:
http://www.openMosix.org the website for the openMosix (Open Source) Project hosted on SourceForge.net Logo.

Most of the works of art on my pages other than the Extension banner
Book Dragon copyright 2006 J. Wilson Spenceare used by permission of J. Wilson Spence.

http://www.uaex.edu/bknox/ is my primary personal work related site.  It is oriented to Oracle Reporting Solutions in the context of generating bespoken reports from SunGard Higher Education's Banner product. 
(I maintain a number of special topic pages with links from this primary site.)

 

  
 

© 2006
University of Arkansas
Division of Agriculture
All rights reserved.
Last Date Modified 08/22/2007
Webmaster

University of Arkansas • Division of Agriculture
Cooperative Extension Service
2301 South University Avenue
Little Rock, Arkansas 72204 • USA
Phone (501) 671-2000 • Fax (501) 671-2209
 

Mission • Disclaimer • EEO •
Privacy • FOI