File Library


Oracle APEX Invalidates the Project Management’s “Triple Constraint”
Topic: Application Express
Owner: Bharat Pappu
Date: 2013-05-28
Subtopic: Solutions

Triple Constraint, per wiki "You are given the options of Fast, Good and Cheap, and told to pick any two. Fast refers to the time required to deliver the product, Good is the quality of the final product, and Cheap refers to the total cost of designing and building the product. This triangle reflects the fact that the three properties of a project are interrelated, and it is not possible to optimize all three – one will always suffer. In other words you have three options:

• Design something quickly and to a high standard, but then it will not be cheap.
• Design something quickly and cheaply, but it will not be of high quality.
• Design something with high quality and cheaply, but it will take a long time."

All of the above statements have been proved otherwise, we at the DC Courts have designed and developed around 15 division/departmental applications with a custom theme details listed below:

1. The Family Court Self-Help Center is a free walk-in service that provides unrepresented people with general legal information in a variety of family law matters (such as divorce, custody, visitation and child support). The Self-Help application provides the family Self-Help customers with a Customer Agreement form that outlines the terms and conditions of the service. Once the customer understands their right and sign the customer agreement form then they will prompted to complete the Self-Help Center Intake Form (Topaz signature Pad are integrated to tie the signature using a JavaScript API). The system provides detail and summary analysis reports.

2. Parenting coordination is a non-adversarial process that aims to minimize the impact of high-conflict custody disputes through parent education, mediation, conflict resolution, and intensive case management. Currently the process is manual. The system provides easy to use data entry screen to capture demographical data. The system also provides detailed and summary reports specifically designed to fulfill the monthly reporting requirements.

3. The Fathering Court System was created for DC Fathering Court program. The system provides intuitive data entry screens and various analysis and performance measurement reports. It also includes summary and detailed reports specifically designed to fulfill grant reporting requirements of Bureau of Justice Assistance (BJA).

4. Family Adoptions document digitizing is a project to scan and index approximately 10,000 case files (300,000 pages) from adoption records dated 1956 – 2001. The project eliminates the need to store and maintain paper documents on site and allows efficient searching and retrieval of historical adoptions documents. A Search and Retrieval system was developed to provide users the ability to quickly search and display various adoption documents using the criteria like: case no, case file date, adoptee name, adoptive parents’ name and natural parents’ name.

5. The Probate Elobby system is an electronic sign-in application for the general public who are making a filing with the Probate Division via the Probate Division Legal Branch.

6. The Probate Mail Log system is used to document the Probate mail received from the public, and to assign the mail to the appropriate personnel for processing.

7. Child Care system was modernized to provide a more accurate reporting capability and thereby help collect and report children registration/checkin and checkout statistics.

8. The ACO (Appeals Coordinators Office) Application was developed to enable ACO staff to intake, process, certify and track the history of appeal cases which aids with the District of Columbia Court’ mission to employ technology to support efficient operations and informed judicial decision-making. An upgrade was recently deployed which included enhancements like streamlined data entry and processing, clean and robust User Interface, system and user administration, Court view search and retrieval, work assignment monitoring, and more.

9. The cert list program is going to allow the superior court to more efficiently manage our caseload as a whole. Currently the cert list is used to ensure that judges who are over-booked for their trial calendars have a way to find other judges who might have a lighter schedule, and it allows those judges with a lighter schedule to take on cases from busier judges. Currently, this program is done entirely over email, and as a result it is fairly inefficient. Judges have a difficult time looking over a long list of emails and determining what cases need to be handled on any given day. This program would allow judges to view the cases that need to be handled in a user-friendly, simple manner. This program would also significantly increase the accuracy of record-keeping. Cert list records are kept to determine how many judges the superior court needs, and on what types of calendars those judges would be best used. Essentially, the cert list records give the judges an idea of how to most-efficiently use resources. Currently, the records are kept by one law clerk, who does the record-keeping by manually plugging in the statistics into a variety of spreadsheets. This program would allow the statistics to be kept automatically, eliminating human error and allowing the law clerk(s) who work on the cert list to use their time more efficiently. (Ready for deployment June 2012)

10. DC Courts IT Security Awareness Questionnaire was designed to gauge the level of user knowledge with regard to computing security to help ensure that individuals who have access to DC Courts computing resources are aware, and as appropriate, trained in the application of any relevant security policies and procedures. The questionnaire requires the users to answer 14 out of 20 questions correctly. Users must retake the quiz until 14 or more questions are answered correctly. A certificate is issued on successful completion of the questionnaire. Application was designed, developed and deployed in a record two week timeframe to help the IT security team to take employee quiz online.

I will be demonstrating all of these applications if time permits..


Download File   bpappu.OracleAPEX.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database