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 a detail block to a form

We are now ready to create a detail block to our form. The detail block is going to store information relating to societies the employee belongs to. The block is a detail block to the PERMGR_DTLS block we have already created. The foreign key is the PERSON_ID. In this recipe, we are going to perform the following tasks:

Creating a lookup
Creating a detail block
Setting the block properties
Setting the item properties
Creating a relationship between the master and detail blocks
Adding a record indicator to the block

Note

The following recipe assumes that you have created a custom schema called XXHR. If you do not have a custom schema, follow the recipe in Chapter 6, Utilities called Creating a custom schema. We have registered the custom application in Chapter 1, Creating Concurrent Programs but we need to create the directory structure on the applications tier. This is where we need to put our custom form.

We have already created a table called XXHR_PER_SOCIETIES...

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 a detail block to a form

Note