1 / 39

Oracle Application Customizations Using JDeveloper and OA Extension

Learn how to create custom functionality using JDeveloper with OA Extension to meet business needs and add to standard functionality.

joek
Download Presentation

Oracle Application Customizations Using JDeveloper and OA Extension

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Application Customizations Using JDeveloper and OA Extension Dan Roth Intermountain Healthcare Salt Lake City September 14, 2011 Utah Oracle Users Group - UTOUG Fall Symposium

  2. About this Session • Most out-of-the-box applications do not fulfill all business needs. Most end-users will want to add to the standard functionality. • JDeveloper with OA Extension allows us to create custom functionality that uses Oracle Application standards. • We will see how to install and configure JDeveloper with the OA Framework for customizations. • We will show how to use create simple page form for accepting input and updating records in the database.

  3. Disclaimers • The session is not a Demo – we will not be making actual changes to applications. • The slides will walk through the steps required to create a sample page, but ad-hoc questions cannot be demonstrated. • Oracle Metalink: • Oracle Application Framework Developer's Guide - 1315485.1 • Find the correct version of JDeveloper - 416708.1

  4. Who am I? • Dan Roth • Applications Programmer/Developer • Intermountain Healthcare • Oracle EBusiness Suite – HR/Payroll • Started in Release 10 • Working with Oracle Apps since 1999 • Hired first in Operations for the implementation • Transferred to IT Support for the system in 2006 • Brigham Young University • MS in Accounting • emphasis in Information Technology

  5. Intermountain Healthcare • 23 Hospitals located in Utah and Idaho • Non-profit integrated healthcare system • 30,000+ employees • The largest non-government employer in Utah • Payroll processed every two weeks • Operations run 24/7 with many different employee types

  6. Why did I choose to do this? • Still a Newbie • This is my firstsecond presentation • Volunteer • Have assisted with UTOUG • Knew that they were looking for presentations • Experience • I have learned some things • I’d like to learn more • Have worked on a recent project – still curious

  7. My Expectations – of You • Interrupt • If you have a question, ask it. • If I am wrong, let me know. • If you have done something similar, let’s talk about it. • Cell Phone • If it rings, go ahead and answer it.

  8. Agenda • Java works • Customization Options and Issues • JDeveloper Setup – with OA Extension • Sample Self Service Page • Q & A

  9. Java Works • Across platforms • Many kinds of editors • Lots of freeware/pre-coded functions • Similar to other languages

  10. Customization Options and Issues – How we actually started with java development • Text Editors – Notepad, MultiEdit, etc. • Internet searches to find examples or pre-written code. • In-house development for features and functionality. • Employee self-service triggered the need and we continued with what we started with.

  11. Customization Options and Issues – Cont. • Application upgrades would introduce issues that would require research and possible re-coding. • Application upgrades would nullify some of the custom code that had been working. • Custom code had to be written for security, database access, default screen look and feel, etc.

  12. JDeveloper Setup with OA Extension • Get the right version – Metalink - Article ID 416708.1 Find the correct version of JDeveloper. • 1. Set the parameters to see the About this Page link. • 2. Open the application as sysadmin. • 3. Click on the About this Page link • 4. Move to the Technology Components tab to see the application OA Framework version. • Download the correct JDeveloper version from Metalink and unzip to install.

  13. Detail from Article ID 416708.1 – Rel. 11

  14. Detail from Article ID 416708.1 – Rel. 12

  15. JDeveloper Setup with OA Extension – Cont.

  16. JDeveloper Setup with OA Extension – Cont. • Set the system environment variable for JDeveloper – JDEV_USER_HOME set to the location where you have unzipped the JDeveloper program. • Get the dbc security file from the database instance that you want to connect to, usually a development environment, and copy it to the security folder of the JDeveloper desktop environment.

  17. JDeveloper Setup with OA Extension – Cont.

  18. JDeveloper Setup with OA Extension – Cont. • Copy the necessary OA files from the application server to the JDeveloper environment.

  19. JDeveloper Setup with OA Extension – Cont.

  20. JDeveloper Setup with OA Extension – Cont. • Set your folder structure in the JDeveloper environment to match the file structure on the application server.

  21. JDeveloper Setup with OA Extension – Cont.

  22. Messages for JSP use

  23. Example: Employee Self-Service Workflow

  24. Example: Employee Self-Service Workflow – Cont.

  25. Example: Employee Self-Service Workflow – Cont.

  26. Example: Employee Self-Service Workflow – Cont.

  27. JSP Application Structure

  28. Application Module XML File

  29. Application Module Implementation File Let’s look at the file…. Sample file: CashOutAMImpl.java

  30. How will we connect to the database?

  31. Application Module Implementation File – Extension for the Controller Let’s look at the file…. Sample file: CashOutCO.java

  32. CashOutPG – Page Layout

  33. Main Message Item

  34. Instruction Item

  35. Button Item

  36. Q / A

More Related