Oracle E-Business Suite R12 Core Development and Extension Cookbook

Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in this book. Whether novice or pro, this is a great tutorial with over 60 recipes and stacks of screenshots.

Oracle E-Business Suite R12 Core Development and Extension Cookbook

Cookbook
Andy Penver

Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in this book. Whether novice or pro, this is a great tutorial with over 60 recipes and stacks of screenshots.
$35.99
$59.99
RRP $35.99
RRP $59.99
eBook
Print + eBook
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
+ Collection
Free Sample

Book Details

ISBN 139781849684842
Paperback480 pages

About This Book

  • Gain key skills to extend Oracle E-Business Suite Release 12.
  • Build forms with advanced features and deploy them in the application
  • Create personalizations and understand how to modify functionality through them
  • Step by step examples guiding you through the development process

Who This Book Is For

This book is written for individuals who want to learn how to develop extensions in Oracle E-Business suite. If you are involved in development or supporting an e-business suite implementation you should find this book very useful. The book is detailed so minimal technical expertise is required. It is suitable for beginners who have little experience or developers who may want to use the book to brush up on their skills.

Table of Contents

Chapter 1: Creating Concurrent Programs
Introduction
Defining a concurrent program
Making a concurrent program available to a user
Adding a concurrent program parameter
Creating a value set
Creating dependent parameters
Adding messages to the concurrent program log file
Reporting to the concurrent program output file
Scheduling a concurrent program
Creating multiple concurrent programs
Creating request sets
Installing the database objects
Creating a HOST concurrent program
Chapter 2: Oracle Forms
Introduction
Using forms builder for E-Business Suite
Installing the database objects
Getting started with forms
Creating a master block and container objects
Modifying the template code
Adding a detail block to a form
Adding insert, update, and delete events
Deploying forms
Adding buttons, list, and checkbox items
Adding a query screen to a form
Passing parameters to a form
Chapter 3: Advanced Oracle Forms
Introduction
Installing the database objects
Using messages from the message dictionary
Creating tabs within a form
Creating program units
Adding lookups, date fields, and lists
Controlling menu items
Creating pop-up menu items
Adding flexfields to forms
Creating triggers for flexfield events
Adding a zoom using the CUSTOM library
Adding a spreadtable to a form
Capturing events for a spreadtable
Chapter 4: Forms Personalization
Introduction
Opening the personalization screen
Installing the database objects
Changing properties
Adding a menu item to a form
Performing a simple validation and displaying a message
Launching a form
Adding a toolbar icon to a form
Performing complex validation
Altering an LOV's record group
Chapter 5: Workflow
Introduction
Introducing Workflow Builder
Installing the database objects
Creating an advanced queue
Building a workflow
Creating a business event
Viewing a workflow status and monitoring progress
Adding a function
Creating a lookup
Creating a subprocess
Creating messages
Sending notifications and processing responses
Calling an API
Chapter 6: Utilities
Introduction
Setting the environment variables
Starting and stopping an environment
Creating a custom schema
Extracting data using FNDLOAD
Uploading using FNDLOAD
Using a script for FNDLOAD
Using a script for migrating objects

What You Will Learn

  • Get an overview of the architecture of Release 12; learn about the file system and where files need to go.
  • Configure concurrent programs which launch executable programs such as a database package or a host program.
  • Understand how to write to a concurrent program log, and output files.
  • Add a query screen to forms and learn how to pass parameters.
  • Configure forms in E-Business Suite, create functions and add them to menus.
  • Create tabs and add code to control them. Create items with lookups, use widgets for date fields and add drop down lists.
  • Build a fully working form with most of the components you are ever likely to utilize.
  • Understand the personalization screen. Change properties to hide fields and move them around. Change labels and even alter a list of values.
  • Create personalizations to perform validation and display a message. Perform actions such as launching a form, adding items to menus or icons to toolbars.
  • Understand Oracle workflow and create a workflow that is triggered by a business event from an XML message on an advanced queue.
  • Build a workflow with functions, lookups, sub-processes and notifications.
  • Learn how to deploy a workflow and test it - viewing its status and monitoring progress.

In Detail

Oracle’s suite of applications is used by many major businesses and public sector organizations throughout the world. The book will show you how to build different types of extensions with different toolsets with Oracle E-Business Suite R12. It will take you from start to finish with fully working examples.

This book will show you how to extend Oracle E-Business Suite Release 12. You will learn highly desirable skills on how to extend the application and develop your expertise. The book will provide detailed information about why things have to be done in certain ways, and will take you through the process of how to get started, what tools are needed, how to develop working examples, and how to deploy them within the application.

Learn how to extend Oracle E-Business Suite (EBS) Release 12. There are detailed examples to work through, such as how various components are configured and how we can extend standard functionality. The book focuses on core development and extension and each chapter will introduce a topic before going through working examples from start to finish. There are plenty of detailed screen shots throughout each chapter giving clear instructions of what we are doing and why. Each recipe will develop a solution that will utilize core components to that topic. The Oracle E-Business Suite R12 Core Development and Extension Cookbook focuses on starting an extension right from the beginning, to deploying it within E-Business Suite. At the end of each chapter the reader will have a good understanding of what they need to do for each area to take away, and start using it in practice.

Each chapter will detail how to build an extension in the supported manner and also comes with complete fully tested code, and scripts that can be downloaded.

Authors

Table of Contents

Chapter 1: Creating Concurrent Programs
Introduction
Defining a concurrent program
Making a concurrent program available to a user
Adding a concurrent program parameter
Creating a value set
Creating dependent parameters
Adding messages to the concurrent program log file
Reporting to the concurrent program output file
Scheduling a concurrent program
Creating multiple concurrent programs
Creating request sets
Installing the database objects
Creating a HOST concurrent program
Chapter 2: Oracle Forms
Introduction
Using forms builder for E-Business Suite
Installing the database objects
Getting started with forms
Creating a master block and container objects
Modifying the template code
Adding a detail block to a form
Adding insert, update, and delete events
Deploying forms
Adding buttons, list, and checkbox items
Adding a query screen to a form
Passing parameters to a form
Chapter 3: Advanced Oracle Forms
Introduction
Installing the database objects
Using messages from the message dictionary
Creating tabs within a form
Creating program units
Adding lookups, date fields, and lists
Controlling menu items
Creating pop-up menu items
Adding flexfields to forms
Creating triggers for flexfield events
Adding a zoom using the CUSTOM library
Adding a spreadtable to a form
Capturing events for a spreadtable
Chapter 4: Forms Personalization
Introduction
Opening the personalization screen
Installing the database objects
Changing properties
Adding a menu item to a form
Performing a simple validation and displaying a message
Launching a form
Adding a toolbar icon to a form
Performing complex validation
Altering an LOV's record group
Chapter 5: Workflow
Introduction
Introducing Workflow Builder
Installing the database objects
Creating an advanced queue
Building a workflow
Creating a business event
Viewing a workflow status and monitoring progress
Adding a function
Creating a lookup
Creating a subprocess
Creating messages
Sending notifications and processing responses
Calling an API
Chapter 6: Utilities
Introduction
Setting the environment variables
Starting and stopping an environment
Creating a custom schema
Extracting data using FNDLOAD
Uploading using FNDLOAD
Using a script for FNDLOAD
Using a script for migrating objects

Book Details

ISBN 139781849684842
Paperback480 pages
Read More

Recommended for You

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
$ 32.99