Oracle E-Business Suite R12 Core Development and Extension Cookbook

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By : Andy Penver

Buy this Book

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By: Andy Penver

Buy this Book

Overview of this book

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.

Oracle E-Business Suite R12 Core Development and Extension Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

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

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

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

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

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

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

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Adding buttons, list, and checkbox items

Now that we have created the form and it is running, we want to add some buttons and change the types of fields that we have created in the form. In this recipe, we are going to perform the following tasks:

Adding OK and Cancel buttons
Modifying the layout
Adding triggers to the buttons
Creating an LOV for the society name field
Configuring the date fields
Creating a list item
Creating a checkbox item
Testing the form

Adding OK and Cancel buttons

We are going to add two buttons. We will add an OK button which will save and exit the form. We will also add a Cancel button which will exit the form without performing any validation. We are going to add the buttons to the PERMGR_DTLS block.

How to do it...

To add buttons to our form, perform the following tasks:

1. In the forms developer, navigate to Data Blocks | PERMGR_DTLS | Items.
2. Click on the + button twice to add two new items.
3. Set the following properties of the first item:
- Name: OK_BTN
- Subclass Information...

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By : Andy Penver

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By: Andy Penver

Overview of this book

Related Content you might be interested in

Current Title:

Oracle E-Business Suite R12 Core Development and Extension Cookbook

Adding buttons, list, and checkbox items

Adding OK and Cancel buttons

How to do it...