www.chain-sys.com
How to migrate Forms based custom.pll to Oracle
Application Framework (OAF) Pages in R12?
Presented By:
Sundu Rathinam | President
Chain-Sys Corporation | Chain-Sys (India) P Ltd
USA, India, UAE, UK, Canada, Singapore.
[email protected] | www.CHAIN-SYS.com
www.chain-sys.com
Agenda
Introduction
OA Framework Overview
Java Augmenter Framework Overview
Types of Augmentations
Key Benefits
Product Demo
Questions
www.chain-sys.com
Agenda
Introduction
OA Framework Overview
Java Augmenter Framework Overview
Types of Augmentations
Key Benefits
Product Demo
Questions
www.chain-sys.com
Company Profile
CHAIN•SYS is a fast growing management consulting/
product development company.
Strong Partnership with Oracle Corporation.
Oracle EBS, Database and Middleware products Reseller.
Oracle Certified Partner
Oracle EBS Mobility Solution Provider.
Oracle University Authorized Education provider and Center.
Oracle Consulting Services (ORS/NAC/NAIO/SSI) Partner.
Makers of e-chain™ SCM/ERP e-business Product suite,
appLOAD™ family of productivity tools for EBS and C3
JavaAUGMENTER™
Makers of Gopster Network Test Tools.
Experts in J2EE Architecture and Development and
Oracle’s OAF, SOA, BPEL, ADF, BI.
www.chain-sys.com
Productivity tools for Oracle EBS 11i/ R12
www.chain-sys.com
Introduction
• Java Augmenter is an application to
customize OAF pages of Oracle EBS
• Built on OA Framework
• All OAF pages can be augmented from a
single interface
• Developed as per OA Framework
standards and guidelines
www.chain-sys.com
Agenda
Introduction
OA Framework Overview
Java Augmenter Framework Overview
Types of Augmentations
Key Benefits
www.chain-sys.com
OA Framework Overview
Desktop
Web Server
Data Server
Oracle iAS
Servlet Engine
Web Listener
Oracle DB
Java
Controller
OA Extension
MDS
Programmatic
UI Definition
UIX
HTML UI Generator
AOL/J
Menus,Security,
Messages, etc
Portal
UI
MDS
Repository
SSO
BC4J
Application
Business
Logic
LDAP
Applications
Schema
J2EE
www.chain-sys.com
OA Framework overview
• OAF is the Oracle Applications self-service development and
deployment platform
• 100% Java & XML, middle-tier application framework and services
for the rapid development & deployment of HTML based
applications.
• Follows the Model-View-Controller (MVC) design pattern.
• OA Framework is built on a flexible architecture.
• Metadata-driven UI components, flows and business logic.
• Extensible UI and business logic.
www.chain-sys.com
OA Framework Runtime
View
Model
UIX Bean Hierarchy
UIX
Renderers
JSP/HTML
Page OA Controller
Yes
Metadata
in cache?
Request
From
Client
No
Fetch metadata
Response
To
Client/Browser
MDS
Repository
.XML
www.chain-sys.com
OA Framework Runtime – Contd.
•
When a user makes a request from the browser:
–
–
–
•
OAF Controller
–
–
–
–
•
Request is received by the JSP (OA.jsp)
JSP invokes OAPageBean
OAPageBean creates OAPageContext
• Provides access to the state of the page
• Provides hooks into OA Framework services
• The OAPageContext instance is passed to the controller
Delegates some events to the Model
Performs some data binding
Determines next page
Invokes View to present next page
The view is basically a HTML page.
–
–
–
A page would contain one or more region
A region can contain normal HTML components and other regions.
The JSP/HTML page is rendered from an UIX.
•
UIX is formed from Meta Data Service (MDS = Metadata Repository + Metadata
cache).
•
MDS is a dictionary containing data about the UI components to be displayed in a
page.
•
MDS has utilities to convert the metadata into XML documents with each
components as nodes
www.chain-sys.com
Agenda
Introduction
OA Framework Overview
Java Augmenter Framework Overview
Types of Augmentations
Key Benefits
www.chain-sys.com
Java Augmenter Framework
Overview
Java Augmenter Framework
Java Augmenter Application
OA Extension
MDS
Java
OA Controller
Programmatic
UI Definition
Generates
Java
Augmenter Controller
Java Augmenter
Engine
UIX
Binding augmentations
in MDS
as Extension
HTML UI Generator
Notify the
cache about
augmentations
AOL/J
Menus,Security,
Messages, etc
MDS
Repository
.XML
Cache
BC4J
Application Logic
www.chain-sys.com
Java Augmenter Framework – contd.
• Collects information about the components and its attributes of the
page to be augmented from MDS
• Stores the augmentations in a java augmenter data schema.
• Creates dynamic controller classes by extending the Controller of
the page to be augmented.
• Binds this controller information into MDS as OA Extension.
• Notifies the application cache about the state of the page has been
modified.
www.chain-sys.com
Java Augmenter Runtime
Model
Apply Augmentations
View
UIX Bean Hierarchy
Java
Augmenter
Engine
UIX
Renderers
Java
Augmenter
Controller
JSP/HTML
extends
Page
Controller
Yes
Metadata
in cache?
Request
From
Client
No
Fetch metadata
Response
To
Client/Browser
MDS
Repository
.XML
www.chain-sys.com
Java Augmenter Runtime – Contd.
• When a user invokes augmented OAF page, OA
Page context invokes Java Augmenter
Controller from MDS
• Invokes Parent Controller followed by Java
Augmenter engine to fetch augmented data
• Java Augmenter Engine evaluates the
augmentations to the page based on the events
and conditions
•
Other steps would be handled by the OAF to
reflect the augmentations
www.chain-sys.com
Agenda
Introduction
OA Framework Overview
Java Augmenter Framework Overview
Types of Augmentations
Augmentations
Key Benefits
www.chain-sys.com
Types of Augmentations
•
Rules
– To change the UI behavior
•
Zoom
– To zoom from OAF page to any OAF Page or Form
•
List of Values
– To change an input field to LOV field or Combo Box
– To restrict the List of Values in a Combo Box
•
Table Region
– To add a tooltip to a column of table
– To sort a column of the table
•
Advanced
– Add actions
•
•
•
•
All above augmentations type can be done on a condition basis
Search all the augmentations done on the instance
Export and Import all (or) any augmentations
Global Zoom
– To zoom other application page
www.chain-sys.com
Rules Augmentation
• Display Option to hide or show the component
with True (or) False values
• Not Editable option to make the component to
Not Editable or Editable with True (or) False
values
• Required option to make the component
mandatory or not with values Yes (or) No
• Title Option to change Label of the component
• Change Case Option to change the case of input
value of the component with values Uppercase
(or) Lower Case
www.chain-sys.com
Zoom Augmentation
• To Zoom any Java Form (OAF Pages) or
Core Form
• Pass Parameters from components of
source document to components of target
document
www.chain-sys.com
List of Values Augmentation
• List of Value Option to convert an editable component to
LOV component (or) to restrict existing list of values
• Combo Box Option to an editable component to to
Message choice component
• Invokes augmentations on an Event
–
–
–
–
On Page Load
On Change of a component
On Focus of a component
On Exit of a component
• Define the above options
–
–
–
–
Static Value to constant values list
Query to have a list
Table Validation Value Set
Independent Value Set
www.chain-sys.com
Table Region Augmentation
• Set a tool tip to a selected column of a
selected table of the page
• Sort a selected column of a selected table
of the page
• Invokes augmentations on an Event
– On Page Load
– On Change of a component
– On Focus of a component
– On Exit of a component
www.chain-sys.com
Advanced Actions
• Set Item Value action
to default value to a
editable component
• Display a Message to
User
• Execute SQL
• Open a web page for
a given URL
• Open a Core Form
• Open a Java Form
• Navigate to an Item
on the Form
• Set Item Property to
change UI behavior
• Set Profile Value
• Send Email
www.chain-sys.com
Augmentation Conditions
• Conditions to augmentations can be done
in all types of augmentation
– Sequence Number in order which condition to
be evaluated
– Left type
– Right type
– Join Type
www.chain-sys.com
Left Types of Conditions
•
•
•
•
•
•
•
Field
Query
Profile
Application
Responsibility
User
Organization
www.chain-sys.com
Right Types of Conditions
•
•
•
•
Constant
Query
Field
Profile
www.chain-sys.com
Join Types of conditions
•
•
•
•
•
=
<>
<
>
LIKE
•
•
•
•
•
NOT LIKE
IS NULL
IS NOT NULL
IN
NOT IN
www.chain-sys.com
Sequence Number of Condition
• Same Sequence number for OR Condition
• Different Sequence number for AND
Condition
www.chain-sys.com
Search Augmentations
•
•
•
•
To search all augmentations done on the instance
Audit information with creation and updation details
Option to show all/Hide all details
Criteria
–
–
–
–
Created by
Created between From and To
Augmentation Type
Document Name
• Enable / Disable all the augmentations of the selected
pages to delete all the augmentations from MDS as well
as Java Augmenter meta data
www.chain-sys.com
Export and Import Augmentations
• To Export all (or) restricted augmentations with criteria
–
–
–
–
–
–
Document Path
Document Title
Type
Create by
Created on
Event
• Import the augmentations into an instance with following
options
– Do nothing when an augmentation already exists
– Duplicate the augmentation when it exists already
– Overwrite the augmentation when it exists already
www.chain-sys.com
Global Zoom
• Global zoom link will be available across
all the OAF pages of an Instance
• To zoom a web pages of other application
• Zoom can be invoked on a basis of
conditions too.
www.chain-sys.com
Agenda
Introduction
OA Framework Overview
Java Augmenter Framework Overview
Types of Augmentations
Key Features
Benefits
Product Demo
Questions
www.chain-sys.com
Key Benefits
• Reduce Cost and Time on OAF Extensions
• Rapid Augmentation tool to customize Oracle EBS OAF
pages for once own business needs / user preferences
• Works seamless with Oracle EBS
• Condition based Augmentations
• Durable: Augmentations survive upgrades and patches
• All augmentations can be turned off/removed from
Instance any time
• Can Implement on test system, export and import to
production system
www.chain-sys.com
Java Augmenter Demo
www.chain-sys.com
Questions??
www.chain-sys.com
Thank You!!
www.chain-sys.com
[email protected]
Chain●Sys Corporation
325 S Clinton St, Suite 205
Grand Ledge MI 48837
Tel: 517-627-1173 ext 203
Chain●Sys (India) Pvt. Ltd. – World HQ – Development Center
3rd Floor “Sarovar”, 670 SBOA School Rd,
Anna Nagar (West),
Chennai 600 101
Tel: (91)-(44)-2615 5580/81/82/83
Other office locations: UK, UAE, and Singapore.