Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

You're reading from   Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook A practical step-by-step guide to develop end-to-end extensions to Oracle E-Business Suite Release 12, with detailed illustrations and explanations

Arrow left icon
Product type Paperback
Published in Mar 2013
Publisher Packt
ISBN-13 9781849687126
Length 398 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Andy Penver Andy Penver
Author Profile Icon Andy Penver
Andy Penver
Arrow right icon
View More author details
Toc

Table of Contents (15) Chapters Close

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Personalizing OA Framework Pages FREE CHAPTER 2. Getting Started with OA Framework Pages 3. Creating a Master Detail Page in OA Framework 4. Adding a Creation Page and LOV Region in OA Framework 5. Advanced OA Framework 6. BI Publisher 7. Desktop Integration 8. Utilities Index

Index

A

  • adautocfg.sh
    • about / Running AutoConfig (adautocfg.sh)
  • Apache
    • about / Bouncing apache
  • application module (AM)
    • about / Getting started with personalizations, Application module (AM), Deploying a page to EBS
  • application module class
    • editing / Editing the application module class, How to do it...
  • Applications Development Framework (ADF)
    • about / Getting started with OA Framework
  • Applications Technology Group (ATG)
    • about / Getting started with OA Framework
  • APPS tier prompt / How to do it...
  • AutoConfig
    • about / Making a new environment parameter, Running AutoConfig (adautocfg.sh)
    • running / Running AutoConfig (adautocfg.sh), How to do it...

B

  • BI Publisher
    • about / Introduction
  • BI Publisher Bursting (e-mail)
    • implementing / Implementing BI Publisher Bursting (e-mail)
    • bursting file, creating / Creating the bursting file, How to do it..., How it works...
    • Bursting concurrent program, running / Running the Bursting concurrent program, How to do it...
  • BI Publisher Bursting (file system)
    • implementing / Implementing BI Publisher Bursting (file system), How to do it...
    • working / How it works...
  • BI Publisher report
    • running / Running a BI Publisher report, How to do it...
  • BI Publisher Template
    • creating / Defining a template, How to do it..., How it works...
  • bursting
    • about / Implementing BI Publisher Bursting (e-mail)
  • Bursting concurrent program
    • running / Running the Bursting concurrent program, How to do it...
  • button, personalizations
    • adding, to page / Adding a button to a page, How to do it...
    • hiding, on page / Hiding a button on a page, How to do it..., How it works...

C

  • cache, personalizations
    • clearing / Clearing the cache, How to do it..., How it works...
  • concurrent program
    • configuring / Getting ready, Configure a concurrent program, How to do it...
    • database package, creating / Create and compile a database package, How to do it..., How to do it...
    • executable, creating / Create and run an executable, How to do it...
    • making available to user / Making a concurrent program available to a user
    • menu, configuring / Configure a menu, How it works...
    • request group, creating / Create a new request group, How to do it...
    • responsibility, creating / Create a new responsibility, How it works...
    • responsibility, assigning to user / Assign the responsibility to a user
    • running / Run the concurrent program
    • request, viewing / View the request, How it works...
  • controller
    • about / Getting started with personalizations
  • Controller (CO)
    • about / Deploying a page to EBS
  • create item event
    • capturing / How to do it..., How it works...
  • createNewSociety method
    • about / Adding code to the destination page to capture the parameters passed
  • custom integrator, desktop integration
    • creating / Creating a custom integrator
    • configuring / Configure the integrator
    • interface, configuring / Configure the interface, How to do it...
    • layout, creating / Create a layout for the integrator, How to do it..., How it works…
    • generating / Generate an integrator, How to do it…, How it works…
    • attributes, adding / Edit the attributes, How to do it…, How it works…
    • lists of values, adding / Add the lists of values, How to do it…, How it works…
    • function, creating / Creating a function for an integrator, How to do it…, How it works…
    • adding, to menu / Adding an integrator to a menu
    • advanced features, adding / Adding advanced features to an integrator, How to do it…, How it works…
  • custom pages, OA Framework files
    • UIX and CO / UIX and COcustom pages, OA Framework filesUIX and CO
    • VO and AM / VO and AMcustom pages, OA Framework filesVO and AM
    • EO / EOcustom pages, OA Framework filesEO
  • custom responsibility, personalizations
    • creating / Creating a custom responsibility, How to do it...
  • custom schema
    • creating / Creating a custom schema
    • environment parameter, creating / Making a new environment parameter, How to do it...
    • AutoConfig, running / Running AutoConfig (adautocfg.sh), How it works
    • directory structure, creating / Creating a CUSTOM schema directory structure, How to do it...
    • tablespace, creating / Creating a new tablespace
    • database user, creating / Creating a database user, How it works
    • Oracle schema, registering / Registering an Oracle schema, How it works
    • Oracle user, registering / Registering an Oracle user, How it works
  • CUSTOM TOP directory structure
    • creating / How to do it..., How it works

D

  • database objects
    • installing / Installing the database objects, How to do it..., How it works...
  • data definition, BI Publisher
    • creating / How to do it..., How it works...
  • DBC file
    • transfering, from application server / Transferring the DBC file from the application server, How to do it...
  • debug mode
    • page, running in / How to do it...
  • decision message
    • adding / Adding a decision message, How to do it..., How it works...
  • desktop integration
    • database objects, installing / Installing the database objects
    • about / Getting started with desktop integration
    • menu, configuring / Configure a menu, How it works...
    • request group, creating / Create a new request group, How to do it...
    • responsibility, creating / Create a new responsibility, How to do it..., How it works...
    • responsibilities, assigning to user / Assign the desktop integration responsibilities to a user, How it works...
    • bowser, configuring / Configuring the browser and MS Office settings, How to do it..., How it works...
    • MS Office security settings, configuring / Configure MS Office security settings, How to do it...
    • table, registering within Oracle e-business suite / Registering a table and its columns within Oracle E-Business Suite
    • custom integrator, creating / Creating a custom integrator
    • function, creating / Creating a function for an integrator, How to do it…, How it works…
    • integrator, adding to menu / Adding an integrator to a menu
    • advanced features, adding to menu / Adding advanced features to an integrator
    • importer, defining / Defining the importer
  • detail region (RN) items
    • creating / Creating the detail region (RN) items
    • columns, creating / Creating columns
    • column items, creating / Creating column items
    • column headers, creating / Creating column headers, How it works...
  • detail region, master detail page
    • creating / Creating a detail region
    • detail region (RN), adding / Adding a detail region (RN), How to do it...
    • detail region (RN) items, creating / Creating the detail region (RN) items
    • show/hide attribute, adding / Adding a show/hide attribute, How to do it...
    • sortable headers, adding / Adding sortable headers, How to do it..., How it works...
  • development environment, OA Framework
    • setting up / Setting up our development environment
    • JDeveloper, downloading / How to do it...
    • JDeveloper, installing / How to do it...
    • JDeveloper with OA Extension, downloading / How to do it...
    • JDeveloper with OA Extension, installing / How to do it...
  • dictionary message
    • creating / Creating a dictionary message
    • logic, adding / Adding logic and calling a dictionary message

E

  • e-business Suite (EBS) / Downloading and installing JDeveloper with OA extension
  • EBS
    • page, viewing from / Viewing a page from EBS, How to do it...
  • EBS user
    • creating / Creating an EBS user and assigning responsibilities, How to do it...
    • responsibilities, assigning / Creating an EBS user and assigning responsibilities, How it works...
  • Edition (J2EE)
    • about / Getting started with OA Framework
  • employee, personalizations
    • attaching, to user record / Attaching an employee to a user record, How it works...
  • employee record, personalizations
    • creating / Creating an employee record, How to do it...
  • EmpSearchAMImpl class / How to do it…
  • entity object (EO)
    • about / Getting started with personalizations, Entity object (EO), Deploying a page to EBS
  • entity object class
    • editing / Editing the entity object class, How to do it..., How it works...
  • environment
    • starting / Starting an environment, How to do it..., How it works
    • stopping / Stopping an environment, How to do it...
  • environment variables
    • setting, for JDeveloper / Setting the environment variables, How it works...
    • setting / Setting the environment variables
    • setting, on application server / Setting the environment on the application server
    • setting, on database server / Setting the environment on the database server
  • event
    • capturing / Capturing an event

F

  • field required, personalizations
    • creating / Making a field required, How to do it...
  • file locations, OA Framework
    • standard files / Standard files
    • custom files / Custom files
    • MDS repository / MDS repository
    • Apache / Bouncing apache
  • files
    • transferring / Transferring the files, How to do it..., How it works..., There's more...
  • flexfield, personalizations
    • adding, to page / Adding a flexfield to a page, How to do it...
    • descriptive flexfield segment, adding / Getting the title of a descriptive flexfield
    • DFF segment, adding / Adding a DFF segment
    • enabling,on self-service page / Enabling a flexfield on a self-service page, How it works...
  • form functions, desktop integration
    • adding, to menu / Adding form functions to menu, How to do it…

H

  • HashMap
    • about / How it works...

I

  • importer, desktop integration
    • defining / Defining the importer, How to do it…, How it works…
  • Integrated Development Environment (IDE)
    • about / Getting started with OA Framework
  • Internet Explorer browser settings, desktop integration
    • configuring / Configure the browser, How to do it...
  • items, personalizations
    • creating / Creating an item, How to do it...
    • re-ordering, on page / Re-ordering items on a page, How to do it..., How it works...

J

  • JAD / Viewing a page from EBS
  • JDeveloper
    • database connections, adding / Adding database connections in JDeveloper, How to do it..., How it works...
  • JDeveloper 9i
    • about / Getting started with OA Framework
  • JDeveloper 10g
    • about / Getting started with OA Framework
  • JDeveloper shortcut
    • creating / Creating a shortcut to JDeveloper, How to do it...
  • JDeveloper with OA extension
    • downloading / How to do it...
    • installing / How to do it...

L

  • link item
    • creating / Creating a link item, How to do it...
  • LOV
    • creating / Creating a list of values
    • application module, creating / Creating the application module, How it works...
    • view object, creating / Creating the view object, How to do it..., How it works...
    • application module, linking to view object / Linking the application module to the view object, How to do it...
    • region, creating / Creating the region for the list of values, How to do it...
    • region, linking to item / Linking the LOV region to an item, How it works...

M

  • manager, personalizations
    • assigning / Assigning a manager, How to do it...
  • master detail page
    • creating / Introduction
    • model layer, creating / Creating the model layer for a master detail page
    • master region, creating / Creating a master region
    • detail region, creating / Creating a detail region
  • master region (RN) items
    • columns, creating / Creating columns
    • column items, creating / Creating column items
    • column headers, creating / Creating column headers, How it works...
  • master region, master detail page
    • creating / Creating a master region
    • master region (RN), adding / Adding a master region (RN), How to do it..., How it works...
    • master region (RN) items, creating / Creating the master region (RN) items, How to do it...
    • Controller (CO), creating / Creating the controller (CO), How to do it...
    • page, testing / Testing the page
  • MDS repository
    • about / MDS repository
  • Meta Data Services (MDS)
    • about / MDS repository
  • model
    • about / Getting started with personalizations
  • model layer, for query page
    • creating / Creating the model layer for a query page
    • application module (AM), creating / Creating the application module (AM), How to do it..., How it works...
    • view object (VO), creating / Creating a view object (VO), How to do it...
    • view object, linking to application module (VO to AM) / Linking the view object to the application module (VO to AM), How it works...
    • application module (AM), testing / Testing the application module (AM), How to do it..., How it works...
  • model layer, master detail page
    • creating / Creating the model layer for a master detail page
    • entity object (EO), creating / Creating the entity object (EO), How to do it...
    • application module (AM), creating / Creating the application module (AM), How it works...
    • view object (VO), creating / Creating the view object (VO), How to do it..., How it works...
    • view object (VO), editing / Editing the view object (VO), How to do it...
    • view object, linking to appilcation module (VO to AM) / Linking the view object (VO) to the application module (AM), How it works...
    • application module (AM), testing / Testing the application module (AM), How to do it..., How it works..., Testing the application module (AM), How to do it..., How it works...
    • view link (VL), creating / Creating the view link (VL), How to do it..., How it works...
    • view link (VL), adding to application module (AM) / Adding the view link (VL) to the application module (AM), How to do it...
  • Model View Controller (MVC)
    • about / Getting started with OA Framework
  • MS Office security settings, desktop integration
    • configuring / Configure MS Office security settings, How to do it..., How it works...
  • MVC architecture, OA Framework
    • model / Getting started with personalizations
    • view / Getting started with personalizations
    • controller / Getting started with personalizations
  • MVC design pattern
    • about / OAF Architecture
    • model / OAF Architecture
    • View / OAF Architecture
    • Controller / OAF Architecture
    • advantages / OAF Architecture

O

  • OA Controller (CO)
    • about / OA Controller (CO)
  • OAF
    • about / Getting started with OA Framework
  • OAF architecture
    • about / OAF Architecture
    • MVC / OAF Architecture
    • layers / OAF Architecture
    • User interface XML (UIX) / User interface XML (UIX)
    • OA Controller (CO) / OA Controller (CO)
    • application module (AM) / Application module (AM)
    • view object (VO) / View object (VO)
    • entity object (EO) / Entity object (EO)
  • OA Framework
    • about / Getting started with personalizations, Getting started with OA Framework
    • MVC architecture / Getting started with personalizations
    • file locations / File locations
    • project, creating / Creating a new project
    • master detail page, creating / Introduction
    • page, creating / Creating a page to insert and update records
    • utilities / Introduction
  • OA Framework page
    • running / Running a page, How to do it...
    • link, adding to region / Adding a link to a region
    • running, in debug mode / Running a page in the debug mode, How to do it..., How it works...
    • PL/SQL, calling from / Calling PL/SQL from the OAF page
    • viewing, from EBS / Viewing a page from EBS, How to do it..., How it works...
  • OA Framework page, building
    • view object, creating / Creating a view object, How to do it...
    • view object, linking to application module / Linking the view object to an application module, How to do it...
    • page, creating for inserting data / Creating a page to insert data, How to do it..., How it works...
    • page status region, adding / Adding a page status region, How to do it..., How it works...
    • page buttons region, adding / Creating a page buttons region, How to do it...
    • page controller, creating / How to do it...
    • page controller, editing / How to do it..., How it works...
    • event, capturing / Capturing an event, How to do it..., How it works...
    • application module class, editing / Editing the application module class, How to do it...
    • entity object class, editing / Editing the entity object class, How to do it..., How it works...
  • OA Framework page navigation
    • about / Navigating between OA Framework pages
    • logic, adding / Adding logic to navigate between pages and pass parameters, How to do it..., How it works...
    • parameters and code logic, capturing / How to do it..., How it works...
    • dictionary message, creating / Creating a dictionary message, How to do it...
    • logic, adding to buttons / Adding logic and calling a dictionary message
    • logic, adding for cancel button / Adding logic for a Cancel button
    • method, adding to roll back transaction / Adding a method to roll back a transaction, How it works...
  • OA Framework pages
    • about / Introduction
    • personalizations / Introduction
  • OC4J
    • about / Setting the OC4J settings and project properties
  • OC4J settings
    • configuring / Setting the OC4J settings and project properties, How to do it...
    • project properties, configuring / How to do it...
  • Oracle BI (Business Intelligence)
    • about / Introduction
  • Oracle BI Publisher Desktop software
    • downloading / Download and install Oracle BI Publisher Desktop software
    • installing / How to do it..., How it works...
    • RTF template, creating / Create an RTF template, How to do it...
    • XDO field codes, removing / Remove XDO field codes, How to do it...
    • RTF document, saving as template / Save the template as an RTF document, How it works...
    • RTF template, previewing / Preview the RTF template, How to do it...
  • Oracle Business Components for Java (BC4J)
    • entity object (EO) / Getting started with personalizations
    • view object (VO) / Getting started with personalizations
    • application module (AM) / Getting started with personalizations
  • Oracle schema
    • registering / Registering an Oracle schema, How it works
  • Oracle user
    • registering / Registering an Oracle user, How it works

P

  • page, deploying to EBS
    • about / Deploying a page to EBS
    • files, copying to application server / Copy the files to the application server, How to do it...
    • .class files permissions, setting on application server / Set the permissions of the .class files on the application server, How to do it...
    • page definition, importing / Importing the page definition, How it works...
    • function, creating / Creating a function, How to do it...
    • menu, configuring / Configure a menu, How to do it...
    • custom responsibility, creating / Creating a custom responsibility, How to do it...
    • responsibility, adding to user / Adding our responsibility to a user
    • OAF page, running / How to do it...
  • page buttons region
    • adding / How to do it...
  • page controller
    • creating / How to do it...
  • page info, personalizations
    • discovering / Discovering information about a page, How to do it...
  • page status region
    • adding / Adding a page status region, How to do it...
  • parameters
    • passing / Passing the parameters, How to do it..., How it works...
  • PDF and Excel output
    • generating, RTF template used / Generating PDF and Excel output using an RTF template, How to do it..., How it works...
  • personalizations
    • creating / Introduction
    • custom responsibility, creating / Creating a custom responsibility, How to do it...
    • user, creating / Creating a new user, How it works...
    • employee record, creating / Creating an employee record, How to do it..., How it works...
    • manager, assigning / Assigning a manager, How it works...
    • employee, attaching to user record / Attaching an employee to a user record, How it works...
    • profile options, setting / Setting the personalization profile options, How to do it..., How it works...
    • page info, discovering / Discovering information about a page, How to do it..., How it works...
    • cache, clearing / Clearing the cache, How to do it..., How it works...
    • user-level personalization, creating / Creating a user-level personalization, How to do it...
    • tool tips, adding / Adding tool tips
    • item, creating / Creating an item, How to do it..., How it works...
    • items, re-ordeing / Re-ordering items on a page, How to do it..., How it works...
    • button, adding to page / Adding a button to a page, How to do it..., There's more...
    • button, hiding on page / Hiding a button on a page, How to do it..., How it works...
    • field required, creating / How to do it...
    • flexfield, adding to page / Adding a flexfield to a page, How to do it...
    • triggering, SPEL used / Using SPEL to trigger personalizations
    • deactivating / Deactivating personalizations, How to do it..., How it works...
    • deleting / Deleting personalizations, How to do it...
  • PL/SQL, calling from OAF page
    • about / Calling PL/SQL from the OAF page
    • button, adding for executing SQL statement / Adding a button to execute the SQL statement, How it works…
    • method, creating in application module / Creating a method in the application module, How to do it…, How it works...
    • method, calling from controller class / Calling the method from the controller class, How it works…
  • PPR
    • about / Partial Page Rendering
    • implementing / Partial Page Rendering
  • processFormRequest method / How to do it..., How to do it…
  • PRODUCT TOP / Creating a CUSTOM schema directory structure
  • profile options, personalizations
    • setting / Setting the personalization profile options, How to do it...
  • project, OA Framework
    • creating / Creating a new project, How to do it...
    • workspace, creating / How to do it...
    • project runtime parameters, setting / Setting the project runtime parameters
  • prologue
    • about / Getting ready
  • PuTTY
    • about / How to do it...
    • URL / How to do it...
  • PVO
    • about / Partial Page Rendering

R

  • records, updating
    • update icon, adding / Adding an update icon, How to do it..., How it works...
    • logic, adding when update icon clicked / Adding the logic when the update icon is clicked on, How it works...
    • code, adding for processing update in createSocietyPG page / Adding the code to process the update in the createSocietyPG page, How to do it...
    • updateSociety method, adding / Adding the updateSociety method, How to do it...
  • rollbackSociety method / How to do it...
  • RTF template
    • creating / Create an RTF template
    • previewing / Preview the RTF template, How to do it...
    • used, for generating PDF and Excel output / Generating PDF and Excel output using an RTF template, How to do it..., How it works...

S

  • setForwardURL method / How it works..., How to do it…
  • SPEL
    • about / Using SPEL to trigger personalizations
    • used, for triggering personalizations / Using SPEL to trigger personalizations
  • SPEL statement
    • adding / Adding a SPEL statement, How to do it...
    • function, creating / Creating a function
    • function, adding to menu / Adding a function to a menu
  • standard OA Framework files
    • UIX and CO / UIX and COstandard OA Framework filesUIX and CO
    • VO and AM / VO and AMstandard OA Framework filesVO and AM
    • EO / EOstandard OA Framework filesEO

T

  • tool tips
    • adding, to page / Adding a tool tip to a page, How to do it...
    • messages, creating / Creating new messages, How to do it..., How it works...
    • short tip type, adding / Adding a short tip type, How to do it..., How it works...
    • long message tip type, adding / Adding a long message tip type, How to do it...

U

  • updateSociety method / How to do it...
  • user, personalizations
    • creating / Creating a new user, How it works...
  • user-level personalization
    • creating / Creating a user-level personalization, How to do it...
  • User interface XML (UIX)
    • about / User interface XML (UIX)
  • user interface XML (UIX)
    • about / Getting started with personalizations, Deploying a page to EBS
  • utilities
    • about / Introduction
    • environment variables, setting / Setting the environment variables
    • environment, starting / Starting an environment, How to do it..., How it works
    • environment, stopping / Stopping an environment, How to do it..., How it works
    • custom schema, creating / Creating a custom schema

V

  • validation
    • adding, to page / Adding a validation to the page, How to do it..., How it works...
  • view
    • about / Getting started with personalizations
  • view layer, for query page
    • creating / Creating the view layer for a query page
    • page (PG), adding / Adding a page (PG), How to do it...
    • default region (PG, renaming / Renaming the default region (PG), How it works...
    • query region (RG), adding / Adding a query region (RG), How it works...
    • results region (RG), adding / Adding a results region (RG) using a wizard, How to do it...
    • item properties, setting / Setting item properties, How to do it...
    • page (PG), testing / Testing the page, How it works...
  • view object (VO)
    • about / Getting started with personalizations, View object (VO), Deploying a page to EBS
  • Visual Basic for Applications (VBA) code / Using Oracle BI Publisher Desktop software to create a rich text format (RTF) template

W

  • Web ADI
    • about / Introduction

X

  • XDO tags
    • replacing / How to do it...
  • XML
    • about / Getting ready
  • XML file
    • markup and content / Getting ready
  • XML markup
    • elements / Getting ready
    • attributes / Getting ready
    • entities / Getting ready
  • XML output
    • generating, concurrent program used / Generating XML output using a concurrent program, Getting ready
  • XML Publisher
    • about / Introduction
  • XX
    • about / Creating a custom schema
  • XXHR
    • about / Creating a custom schema
  • XXHR BI Publisher Roster Example / How to do it...
  • XXHR Duty Roster report
    • bursting / Implementing BI Publisher Bursting (file system)
  • XXHR_PARTY_UPLOAD table
    • registering / Registering a table and its columns within Oracle E-Business Suite, How to do it..., How it works...
    • registeration, checking / Checking the table has been registered in Oracle, How to do it...
  • XXUSER / Adding our responsibility to a user
lock icon The rest of the chapter is locked
arrow left Previous Section
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image