Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle E-Business Suite R12 Core Development and Extension Cookbook
  • Table Of Contents Toc
Oracle E-Business Suite R12 Core Development and Extension Cookbook

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By : Andy Penver
4 (2)
Buy this Book
close
close
Oracle E-Business Suite R12 Core Development and Extension Cookbook

Oracle E-Business Suite R12 Core Development and Extension Cookbook

4 (2)
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.
Table of Contents (12 chapters)
close
close
close
Oracle E-Business Suite R12 Core Development and Extension Cookbook
Icon
Oracle E-Business Suite R12 Core Development and Extension Cookbook
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Creating Concurrent Programs
chevron up
Icon
Creating Concurrent Programs
Icon
Introduction
Icon
Defining a concurrent program
Icon
Making a concurrent program available to a user
Icon
Adding a concurrent program parameter
Icon
Creating a value set
Icon
Creating dependent parameters
Icon
Adding messages to the concurrent program log file
Icon
Reporting to the concurrent program output file
Icon
Scheduling a concurrent program
Icon
Creating multiple concurrent programs
Icon
Creating request sets
Icon
Installing the database objects
Icon
Creating a HOST concurrent program
2
Oracle Forms
Icon
Oracle Forms
Icon
Introduction
Icon
Using forms builder for E-Business Suite
Icon
Installing the database objects
Icon
Getting started with forms
Icon
Creating a master block and container objects
Icon
Modifying the template code
Icon
Adding a detail block to a form
Icon
Adding insert, update, and delete events
Icon
Deploying forms
Icon
Adding buttons, list, and checkbox items
Icon
Adding a query screen to a form
Icon
Passing parameters to a form
3
Advanced Oracle Forms
Icon
Advanced Oracle Forms
Icon
Introduction
Icon
Installing the database objects
Icon
Using messages from the message dictionary
Icon
Creating tabs within a form
Icon
Creating program units
Icon
Adding lookups, date fields, and lists
Icon
Controlling menu items
Icon
Creating pop-up menu items
Icon
Adding flexfields to forms
Icon
Creating triggers for flexfield events
Icon
Adding a zoom using the CUSTOM library
Icon
Adding a spreadtable to a form
Icon
Capturing events for a spreadtable
4
Forms Personalization
Icon
Forms Personalization
Icon
Introduction
Icon
Opening the personalization screen
Icon
Installing the database objects
Icon
Changing properties
Icon
Adding a menu item to a form
Icon
Performing a simple validation and displaying a message
Icon
Launching a form
Icon
Adding a toolbar icon to a form
Icon
Performing complex validation
Icon
Altering an LOV's record group
5
Workflow
Icon
Workflow
Icon
Introduction
Icon
Introducing Workflow Builder
Icon
Installing the database objects
Icon
Creating an advanced queue
Icon
Building a workflow
Icon
Creating a business event
Icon
Viewing a workflow status and monitoring progress
Icon
Adding a function
Icon
Creating a lookup
Icon
Creating a subprocess
Icon
Creating messages
Icon
Sending notifications and processing responses
Icon
Calling an API
6
Utilities
Icon
Utilities
Icon
Introduction
Icon
Setting the environment variables
Icon
Starting and stopping an environment
Icon
Creating a custom schema
Icon
Extracting data using FNDLOAD
Icon
Uploading using FNDLOAD
Icon
Using a script for FNDLOAD
Icon
Using a script for migrating objects

Scheduling a concurrent program

There are two ways in which a concurrent program can be executed; it can be launched manually by a user or it can be scheduled to run automatically either on a one off basis or on a regular basis. In the next recipe, we are going to schedule the concurrent program we have created. It is important to note that when we schedule a concurrent program there is no user there to select the values for the parameters that are defined. Therefore, any required parameters we have added must have a default value. This can be done when entering the concurrent program but we are going to default a value for the organization.

We are going to complete the following tasks in this recipe:

  • Add default values for any required parameters
  • Schedule the concurrent program

Add default values for any required parameters

We are now going to add default values for the parameters in our concurrent program that are required.

Getting ready

In our concurrent program XXHR First Concurrent Program we have three parameters:

  • P_RUN_DATE
  • P_ORG_ID
  • P_PERSON_ID

The first parameter P_RUN_DATE is not required and is already defaulted to the current date. The second parameter P_ORG_ID is required and so we are going to default this to Vision Corporation.

How to do it...

To add default values to our concurrent program parameters complete the following steps:

  1. Log in to Oracle with the Application Developer responsibility.
  2. Navigate to Concurrent | Program and the Concurrent Programs window will open.
  3. Press the F11 key to enter a query.
  4. Query back the XXHR First Concurrent Program concurrent program and click the parameters button.
  5. Click on the P_ORG_ID parameter and enter the following details to set the default parameter:

    Item name

    Item value

    Default Type

    SQL Statement

    Default Value

    SELECT organization_id FROM hr_all_organization_units WHERE name = 'Vision Corporation'

  6. Click the Save button in the toolbar (or Ctrl + S) to save the record.

How it works...

We have set a default value for the Organization parameter in the concurrent program so that it can be scheduled.

Schedule the concurrent program

Now we are going to schedule the concurrent program to run on a daily basis for two days.

How to do it...

To schedule the concurrent program do the following:

  1. Log in to Oracle with the XXEBS Extending e-Business Suite responsibility.
  2. Navigate to Submit Requests and submit a single request.
  3. Select the XXHR First Concurrent Program concurrent program and leave the Run Date and Organization parameters set to their default values and click on OK:
    How to do it...
  4. Now click on the Schedule button. The screen dynamically changes when you click on each item of the Run the Job radio group.
  5. Click Periodically.
  6. Set Re-Run to every 1 Day(s).
  7. Enter an End At value 2 days from the current date.
  8. Check the Increment date parameters each run.

The steps are shown in the following screenshot:

How to do it...
  1. Click on OK and the window will close.
  2. Click on the Submit button and when prompted to submit a new request select No and the form will close down.
  3. Navigate to View Requests and click on the Find button (to find all requests).
  4. You should see that the concurrent program we just submitted has submitted two requests. The first will be set to run immediately and the second concurrent program is Pending with a status of Scheduled, as shown in the following screenshot:
How to do it...

Note

You will notice that the date in the Parameters field has automatically been incremented because we checked the Increment date parameters each run checkbox.

How it works...

We have now scheduled our concurrent program for two days and the program will run automatically unless it is cancelled before the last run has completed.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle E-Business Suite R12 Core Development and Extension Cookbook
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon