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 spreadtable to a form

We are now going to add some more advanced features to our forms. In CRM there is a form that allows us to create spreadtables. To create a spreadtable we will need to complete the following tasks:

Adding the CRM Administrator responsibility
Configuring a spreadtable
Adding a tab page
Adding the JTF_GRID object group
Adding a block
Adding an item
Adding a library
Adding code to manage the grid
Adding code to populate the grid
Testing the form

Adding the CRM Administrator responsibility

The first thing we need to do is add a CRM Administrator responsibility. This is the responsibility that allows us to configure our spreadtable.

How to do it...

To add a CRM Administrator responsibility, perform the following:

1. Log in to Oracle with the System Administrator responsibility.
2. Navigate to Security | User | Define and the Users window will open.
3. Press F11 to enter a query.
4. Enter your user name in the User Name field and press Ctrl + F11.
5. Add the CRM Administrator, Vision...

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 spreadtable to a form

Adding the CRM Administrator responsibility

How to do it...