PacktLib: Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Personalizing OA Framework Pages

Introduction

Getting started with personalizations

Setting the personalization profile options

Discovering information about a page

Clearing the cache

Creating a user-level personalization

Adding tool tips

Creating an item

Re-ordering items on a page

Adding a button to a page

Hiding a button on a page

Making a field required

Adding a flexfield to a page

Using SPEL to trigger personalizations

Deactivating personalizations

Deleting personalizations

Getting Started with OA Framework Pages

Introduction

Getting started with OA Framework

Installing the database objects

Setting up our development environment

Setting the environment variables

Transferring the DBC file from the application server

Creating a shortcut to JDeveloper

Creating an EBS user and assigning responsibilities

Adding database connections in JDeveloper

Setting the OC4J settings and project properties

Running a page

Creating a new project

Creating the model layer for a query page

Creating the view layer for a query page

Creating a Master Detail Page in OA Framework

Introduction

Creating the model layer for a master detail page

Creating a master region

Creating a detail region

Deploying a page to EBS

Adding a Creation Page and LOV Region in OA Framework

Introduction

Creating a page to insert and update records

Passing the parameters

Creating a list of values

Adding a link to a region

Running a page in the debug mode

Advanced OA Framework

Introduction

Navigating between OA Framework pages

Updating records

Adding a validation to the page

Calling PL/SQL from the OAF page

Adding a decision message

Partial Page Rendering

Viewing a page from EBS

Transferring the files

BI Publisher

Introduction

Generating XML output using a concurrent program

Making a concurrent program available to a user

Using Oracle BI Publisher Desktop software to create a rich text format (RTF) template

Creating a Data Definition

Defining a template

Running a BI Publisher report

Generating PDF and Excel output using an RTF template

Implementing BI Publisher Bursting (e-mail)

Implementing BI Publisher Bursting (file system)

Desktop Integration

Introduction

Installing the database objects

Getting started with desktop integration

Configuring the browser and MS Office settings

Registering a table and its columns within Oracle E-Business Suite

Creating a custom integrator

Creating a function for an integrator

Adding an integrator to a menu

Adding advanced features to an integrator

Defining the importer

Utilities

Introduction

Setting the environment variables

Starting and stopping an environment

Creating a custom schema

Index