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 (8 chapters)
close
close
close
Preface
Icon
Extending Oracle E-Business Suite
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Creating Concurrent Programs
chevron up
Icon
1. 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
2. Oracle Forms
Icon
2. 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
3. Advanced Oracle Forms
Icon
3. 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
4. Forms Personalization
Icon
4. 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
5. Workflow
Icon
5. 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
6. Utilities
Icon
6. 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
7
Index
Icon
Index

Creating dependent parameters

In this next recipe, we are going to create a new parameter but this time we are going to make it dependent upon the parameter we created in the previous recipe.

We will be adding a parameter to the concurrent program we have already created. We will also be looking to change the package XXHREEBS so we will need to use SQL Developer to make these changes. The following tasks will be performed in this recipe:

  • Create a dependent value set
  • Create a new parameter for the concurrent program
  • Modify the executable to accept the new parameter
  • Run the concurrent program

Create a dependent value set

We are now going to create a dependent value set. It will select a list of employees who belong to the organization chosen in the Organization parameter.

How to do it...

Perform the following steps to create the value set:

  1. Log in to Oracle with the Application Developer responsibility.
  2. Navigate to Application | Validation | Set and the Values Sets window will open.
  3. Enter the details as shown in the following table:

    Item name

    value

    Value Set Name

    XXHR_PERSON_DEP_VS

    Description

    List of HR person records dependent upon organization

    List Type

    List of Values

    Security Type

    No Security

    Format Type

    Char

    Maximum Size

    20

    Validation Type

    Table

  4. Click on the Edit Information button and the Validation Table Information window will open.
  5. Enter the details as shown in the following table:

    Item name

    value

    Type

    Size

    Table Application

    Human Resources

    		  

    Table Name

    per_people_f ppf, per_assignments_f paf

    		  

    Value

    ppf.national_identifier

    Char

    20

    Meaning

    ppf.full_name||'- Employee Number : '||ppf.employee_number

    Varchar2

    240

    ID

    ppf.person_id

    Number

    10

    Where/Order By

    TRUNC(SYSDATE) BETWEEN ppf.effective_start_date and ppf.effective_end_date

    AND TRUNC(SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date AND ppf.person_id = paf.person_id AND paf.primary_flag = 'Y'

    and paf.assignment_type = 'E' AND paf.organization_id = :$FLEX$.XXHR_ORG_LIST_VS

    		  

    Note

    We should just examine the syntax in the Where/Order By field. The clause joins the two tables we have defined in the table name field. The syntax I want to focus on is the following line:

    AND paf.organization_id = :$FLEX$.XXHR_ORG_LIST_VS

    The $FLEX$ indicates that we want to base this upon another value set. It is followed by the name of the value set we want this to be dependent upon. A parameter that uses the value set must exist in another parameter defined in the concurrent program.

  6. Click the Save button in the toolbar (or Ctrl + S) to save the record.
  7. Click on the Test button to test the code entered.

How it works...

We have created a value set that is dependent upon another value set. We have already defined the p_org_id parameter that uses the XXHR_ORG_LIST_VS value set. When we run the concurrent program the parameter that uses this value set will appear disabled until a value has been entered in the dependent parameter.

Create a new parameter for the concurrent program

We are now going to add a new parameter called person_id and use the value set we have just created for the parameter.

How to do it...

Perform the following steps to add the new parameter:

  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. Add a new parameter with the following details:

    Item name

    Value

    Seq

    30

    Parameter

    P_PERSON_ID

    Description

    Person ID

    Enabled

    How to do it...

    Value Set

    XXHR_PERSON_DEP_VS

    Default Type

    		 

    Required

    How to do it...

    Display

    How to do it...

    Display Size

    20

    Description Size

    50

    Concatenated Description Size

    25

    Prompt

    Person

The parameter should now look like the following screenshot:

How to do it...

How it works...

We have configured the P_PERSON_ID parameter that is dependent upon the organization parameter. This can be achieved by referencing the Organization value set with the :$FLEX$.XXHR_ORG_LIST_VS syntax.

Modify the executable to accept the new parameter

We are now going to add the parameter to the executable, which is the package called XXHREEBS.First_Concurrent_Program. If you wish to view the code then it can be found in the files XXHREEBS_1_4.pks and XXHREEBS_1_4.pkb. You can compile the package provided or use the following instructions to add the parameter manually.

How to do it...

To add the new parameter to the code, perform the following steps:

  1. Open SQL Developer and connect to the apps user.
  2. Navigate to Packages and select the XXHREEBS package.
  3. Now edit the package specification.
  4. Scroll down the package specification until you reach the First_Concurrent_Program procedure definition.
  5. Now add the parameter to the code AFTER the p_org_id parameter. The program definition will look like the following:
    PROCEDURE First_Concurrent_Program (errbuf OUT VARCHAR2,
retcode OUT NUMBER,
p_run_date IN VARCHAR2,
p_org_id IN VARCHAR2,
p_person_id IN NUMBER);
  6. Compile the package specification.
  7. Open the package body to add the p_person_id parameter to the body.
  8. Scroll down to the First_Concurrent_Program procedure definition and add p_person_id to the list of parameters, as shown in the following code:
    PROCEDURE First_Concurrent_Program (errbuf OUT VARCHAR2,
retcode OUT NUMBER,
p_run_date IN VARCHAR2,
p_org_id IN VARCHAR2,
p_person_id IN NUMBER) IS
  9. Compile the First_Concurrent_Program package body.

How it works...

We have added the new parameter to the package specification and body. When we run the concurrent program the Person parameter will be dependent upon the organization that is selected.

Run the concurrent program

Now we want to run the concurrent program testing that the concurrent program still runs successfully if the person_id parameter is passed in.

How to do it...

To run the concurrent program, perform 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 parameter set to the default date (which is the current date).

    Note

    You will notice that the Person parameter is disabled. This is because it is dependent upon the Organization field and will remain disabled until an organization has been entered.

  4. Select an organization from the list of values for the Organization parameter and then click OK. (If using a Vision instance select 'Vision Corporation', for example.)
  5. Select an employee record from the list of values for the Person parameter and then click OK.
  6. Click on the Submit button and when prompted to submit a new request select No and the form will close down.
  7. Navigate to View Requests and click on the find button (to find all requests).
  8. You should see that the concurrent program we just submitted has completed successfully. (If it is still Pending then click the refresh button until the status is Completed).

How it works...

We have now added the dependent parameter to the concurrent program. This allows us to control values that are entered by the users.

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