XML Publisher/Oracle Applications Framework Technology Update 11.5.10

1. XML Publisher/Oracle Applications FrameworkTechnology Update 11.5.10

2. Introductions • Brent Mosher, Senior Sales Consultant, Applications Technology, Rocky Mountain Regionbrent.mosher@oracle.com • Jason Reedy, Senior Sales Consultant, Applications Technology, Northern California Regionjason.reedy@oracle.com

3. Topics • XML Publisher • Oracle Applications Framework • Q & A

4. XML Publisher

5. Checks Invoices XML Publisher Reports Labels Destinations XML / EFT / EDI Overview • Oracle XML Publisher is a new java-based product available within the technology stack of the Oracle E-Business Suiteand offers a template-based, easy-to-use publishing solution, based on standard,well-known technologiesand tools so customers cantake advantage of it easilyand to rapidly develop and • maintain report formats.

6. Product Features in 11.5.10 • Data Source Registration • Template Registration • XML Report Publisher Program

7. Benefits • Authoring - Application developers can focus on extracting the data. • Managing - Business consultants can create templates using familiar tools such as Acrobat, Word, Excel and others. • Delivering - End users can publish documents in multiple output formats, multiple languages, and multiple delivery options.

8. The Way Things Work

9. XSL Design Templates Design the Template using desktop applications. Your template files can be either in Rich Text Format (RTF) or Portable Document Format (PDF).

10. XSL Design Templates Generate XML Set the E-Business Suite report to generate XML. Run the E-Business Suite Report using standard request submission to obtain the XML output.

11. XSL Design Templates Publish Report XML EFT Generate XML XML Publisher merges your design template with the XML data to generate your customized report.

12. HRMS DBI/PMV Purchasing Contracts Sourcing Quoting FSG eRecords Loans Apps Products UtilizingXML Publisher • Order Management • iStore • Project Contracts • Marketing • Student Services • Discrete Manufacturing • Process Manufacturing • Bill Presentment • Internal Controls Manager

13. Product Dependencies • The two layers of XML Publisher and the Core Components have separate dependencies: • XML Publisher • Requires OA Framework 5.7 and up • XML Publisher core components • Core Components • Oracle XML Parser 8.1.7

14. Third Party Integration Points • Microsoft Word – used to create RTF report templatesVersion: MS Word 2000 and up • Adobe Acrobat – used to create PDF document templates.Version: Acrobat 5.x and up

15. For Additional Information • Oracle University Training and Enrolment: • http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?redir_type=3 • Oracle Product Information: • Oracle.com - http://oracle.com/ • AppsNet - http://oracle.com/appsnet/content.html • MetaLink - http://metalink.oracle.com • Oracle Product Documentation: • AppsNet - http://www.oracle.com/appsnet/products/documentation/content.html • About Document: MetaLink Note: 269605.1 • Oracle Product Software (on Metalink): • XDO Core 4.5.0 - Note: 3554612 • XDO OA 4.5.0 (Apps Layer) - Note: 3554613

16. Oracle Applications Framework

17. Oracle Applications Framework • The development and deployment platform for HTML-based Oracle E-Business Suite Applications • 100% Java & XML J2EE based, middle-tier application framework and services for the rapid development & deployment of HTML based applications

18. Meta-data Flows UI Objects DB Objects Model-View-Controller (MVC) Architecture A component-based design with clean interfaces among model, view, and controller objects The controller responds to user actions and directs application flow Controller Model View The model encapsulates underlying data and business logic of the application The view formats and presents data from a model to the user

19. The Model:Business Components for Java • Java/XML based J2EE framework • Utilizes and adds value to the J2EE platform • Takes care of application plumbing • Key Benefits: • Reusable and maintainable code • Productive development • Easy client binding • Implements J2EE best practices • Multiple deployment options

20. The Model:Business Components for Java • Entity object – encapsulates business logic for database table, view, or synonym. Accessed through a • View object – filtered subsets of entity objects. Clients navigate through result sets, getting and setting attribute values. • Application module – a logical container for instances of view objects.

21. OA Framework-Based Page: The View

22. The View – Under the Surface A Hierarchy of Regionsand Items

23. The View - Design Time • Developers use Oracle JDeveloper OA Extension to create pages declaratively. • Pages are made up of a hierarchy of regions and items. • The order of the items determines their position within a page or region UI at runtime.

24. The View - How It Works OA Framework Design time OA Framework Runtime Page Hierarchy UIX Bean Hierarchy UIX Renderers JSP/HTML Browser Cache .XML Metadata

25. The Controller – User Interaction Controller Browsersendsrequest toController User takes an action Metadata Workflow Model Apply 1. Controller delegates data processing to Model 2. Determines next page 3. Invokes View to present the next page to user View

26. The Model – Data Processing BC4J OBJECTS View Side Entity Objects (EO) UIX Bean Hierarchy View Objects (VO) Application Module (AM) DML Validations Defaulting .XML Application Module (AM) Database Tables,Views PL/SQL

27. dataflow up stack (pull) dataflow down stack (push) Architecture: Layering Promotes Reuse • Each layer only “knows” about the layers below it. • This provides for easier reuse at any of the layer boundaries. OA Controllers Application Modules View Objects Entity Objects DB

28. Key Benefits • High end-user productivity • Enterprise-grade Performance and Scalability • Low cost applications customizability • Rapid development environment • Standards based development and deployment platform

29. Architecture: Performance & Scalability • Multi-tier scalable architecture • No code on the client, minimal Javascript • Middle-Tier caching • Resource pooling • Passivation capabilities • Proven scalability with several large deployments

30. Key Features • Consistent and Compelling User Interface • User Interface Interactivity • Durable Personalizations and Extensibility • Built-in Security • A2A and B2B Interoperability • Integrated Development Environment • Mobile • Functional Administration Tool

31. User Interface Interactivity • Interactivity of the user interface is necessary for end-user productivity. The OA Framework offers a set of competitive interactivity features: • Partial Page Rendering • Hot keys • Save Model • Smart Choice List • LOV Auto Completion

32. Partial Page Rendering (PPR) • PPR technology allows only the changed portion of a page to be redrawn rather than the full page. • Partial Page Rendering Examples: • Table record-set navigation / Add a row • Hide/Show • Sub tabs can be configured to use PPR • Gantt charts can be refreshed with PPR based on changes to associated data • Descriptive Flexfields context switching User Interface Interactivity

33. Accelerator (Hot) Keys • Support alphabetic hot keys for common UI navigation and user actions • Support numeric hot keys for application- specific UI navigation and user actions • Hot keys can be added and personalized at the customer site using Admin Personalization User Interface Interactivity

34. Smart Choice List • Smart choice list is an LOV with a choice list that includes the commonly-used values. • 11.5.10 provides enhanced personalization capabilities for the smart choice list to allow users to delete, reorder, and add values to the choice list. User Interface Interactivity

35. LOV Auto Completion • When the user enters a partial value in a field that is associated with an LOV, the OA Framework determines if the partial value leads to a unique record. • If so, the OA Framework automatically populates the mapped values between the LOV and the page fields. • The end-user saves time that would been wasted in bringing up the LOV popup, conducting a search and selecting the same record. User Interface Interactivity

36. Personalization vs. Extensibility • Personalization • Declaratively tailoring UI look-and-feel, layout or visibility of built-in content to suit a business need or a user preference • Use the Personalization Framework • Extensibility • Extending the functionality of an application: • Adding new content or business logic • Extending/overriding existing business logic • Use JDeveloper

37. Personalization vs. Extensibility • Personalization • Declaratively tailoring UI look-and-feel, layout or visibility of built-in content to suit a business need or a user preference • Use the Personalization Framework • Extensibility • Extending the functionality of an application: • Adding new content or business logic • Extending/overriding existing business logic • Use JDeveloper

38. Personalization vs. Extensibility • Personalization

39. Personalization vs. Extensibility • Personalization

40. Personalization vs. Extensibility • Personalization

42. Personalization vs. Extensibility • Personalization • Declaratively tailoring UI look-and-feel, layout or visibility of built-in content to suit a business need or a user preference • Use the Personalization Framework • Extensibility • Extending the functionality of an application: • Adding new content or business logic • Extending/overriding existing business logic • Use JDeveloper

43. Integrated Development Environment • Oracle JDeveloper OA Extension comes with a number of resources including: • A Developer’s Guide • Development Standards • A set of Tutorials • Javadoc • A Samples Library • Online Help

44. Integrated Development Environment • Create BC4J Components • Create OA Framework Pages • Add OA Framework Regions

46. Questions & Answers Q & Q U E S T I O N S A N S W E R S A

47. Thank You.

48. Template Design

49. XML

50. Reports