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

Creating messages

When we want to send a notification we must first define a message that the notification will be based upon. We are going to create a number of messages. There will be a message to the manager of the employee to confirm the absence details. This will require a response from the manager to accept or reject the absence that was received in the XML. There will be a message to the system administrator to inform them of an error in validating the XML. Finally there will be a message to the employee to inform them that the manager has rejected the absence details. We are going to create the following three messages:

Absence Approval
Absence Rejection
Invalid XML

To create messages, we will perform the following tasks:

Creating an absence approval message
Adding attributes to our approval message
Creating a rejection message
Adding attributes to our rejection message
Creating an invalid XML message
Adding invalid XML message attributes

Creating an absence approval message

We are now going...

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

Creating messages

Creating an absence approval message