Book Image

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By : Andy Penver
Book Image

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By: Andy Penver

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.
Table of Contents (12 chapters)
Oracle E-Business Suite R12 Core Development and Extension Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

Modifying the template code


In this recipe, we are going to modify the code in the TEMPLATE.fmb form. There are certain triggers that need to be modified when creating a new form. The shell is there, we just need to modify the code to make the form function properly. We need to modify code in the following objects:

  • Modifying the PRE-FORM trigger

  • Modifying the WHEN-NEW-FORM-INSTANCE trigger

  • Modifying the APP_CUSTOM procedure

Modifying the PRE-FORM trigger

The PRE-FORM trigger stores version information about the form and it also dictates the first window of the form.

How to do it...

To modify the PRE-FORM trigger, perform the following tasks:

  1. 1. Navigate to the form level PRE-FORM trigger and open it.

  2. 2. Make the following changes to the FND_STANDARD.FORM_INFO parameters:

    • Change the $Revision: number to 120.1 (change this each time a new version of the form is released)

    • Change the $Date: to the current date

    • Change the $Author: to your current username

  3. 3. Change the first parameter in the call to the...