Oracle Apps Fusion Training Home

Test workbench in AME - Testing SSHR AME - Part 8

Sat, 24 Oct 2009 12:27:22 +0000

Oracle provides a wonderful utility for testing your AME. This is called AME Test Workbench.

What is AME Test Workbench?
This is a screen using which you can simulate the calls to AME engine by passing some parameters. For example, Self Service HRMS passes transaction_id from hr_api_transactions to the AME. In this article, you will see an audio video demo that explains how you can use the test workbench in AME for testing and debugging your AME customizations. For this specific example, we will be using transaction_id of Self Service HRMS to simulate an AME call from the AME test workbench.

Oracle Apps Book is shipping now

Thu, 22 Oct 2009 00:10:30 +0000

Finally the book is shipping from amazon.com website priced at USD 37/-

This book is the result of an effort from me and Vladimir Ajvaz to condense the Oracle Applications development concepts and best practices in an organized manner.

Creating the AME Rule in Self Service HRMS - Part 7

Tue, 20 Oct 2009 23:51:42 +0000

Thanks for your patience while I explained the basics behind AME's integration in Self Service HRMS.

In this article, you will find a video demo that brings the knowledge from Part 1 to Part 6 together, to create an AME Rule in Self Services Human Resources.

Self Service HRMS - Design and Unit test AME - Part 6

Sun, 18 Oct 2009 23:56:02 +0000

In this article, we will see the steps for implementing the AME solution, so that the data changes made from "Holiday Rejection Complaint Screen" will be sent for approval to your manager's manager. Before reading this article, you must read the following articles

1. Enable AME- Workflow customization in Self Service

2. Understanding AME Concepts

http://apps2fusion.com/apps-training/apps-functional-documents/ame-sshr/395-ame

http://apps2fusion.com/apps-training/apps-functional-documents/ame-sshr/396-sshr-approval-management-engine

http://apps2fusion.com/apps-training/apps-functional-documents/ame-sshr/397-rbac-ame

This article also contains a video demo to demonstrate integration of AME,HRSSA Workflow, Screen and HR_API_TRANSACTIONS.

Self Service HRMS and AME Part 5 - Understanding HR_API_TRANSACTIONS

Sat, 17 Oct 2009 11:42:37 +0000

When a Self Service HRMS user creates any data from the screens, such data goes and resides in some temporary tables. This data is retained within the temporary tables until the transaction is Completed. A transaction in this example gets completed when Holiday Rejection complaint is either Rejected or Approved. These temporary table names begin with name HR_API%. In reality, the data entered by the user is either stored within just one table i.e. HR_API_TRANSACTIONS or within HR_API_TRANSACTION_VALUES. When the data is stored in just the HR_API_TRANSACTIONS then the entire data entered by the user is captured in a CLOB column. This feature was introduced couple of years ago, whereby for performance reasons the temporary data is captured in a clob column named HR_API_TRANSACTIONS within HR_API_TRANSACTIONS. This CLOB column contains XML contents. By now, you might have the following questions
1. What exactly is captured in CLOB column hr_api_transactions.transaction_document
2. How does Self Service HRMS decide whether the transaction data which is in-transit goes into CLOB or HR_API_TRANSACTION_VALUES.
3. How is this temporary data used by AME
4. How is the data transferred from temporary tables to base tables in HRMS.

In this article I will answer these questions, so that you can proceed with the AME bits that depends upon this information. In addition to this, you will also learn how the "SAVE FOR LATTER" feature works in HRMS.

BPEL Scheduling Processes

Sun, 11 Oct 2009 22:10:04 +0000

BPEL: Scheduling Processes

Introduction

All we know that, Oracle BPEL process instance can be initiate in number of ways. Like

Passive: BPEL engine receives a call (BPEL console or some other web service)

Active: BPEL engine looks for events to be occur that should trigger new instance of process.( Polling for file in particular folder and polling for new record in database table)

There is intermediate option where BPEL engine will start process instance at specific time (schedule).

This document talks more about scheduling BPEL process using various methods like Quartz scheduler and Wait activity.

Self Service HRMS Workflow Explained - Part 4

Wed, 30 Sep 2009 23:05:45 +0000

In this article, we will continue with the HRSSA workflow, and see how it integrates with the AME. You will also see the best practices steps to customize this workflow in an upgrade safe manner. In all the HRSSA processes, there is a Workflow activity named "Review Page..." as shown below. If you double click to open the properties of this WF Activity, you will find that Node Attributes tab contains a two Attributes i.e. HR_DYNAMIC_APPROVAL_LEVEL and HR_APPROVAL_FLAG. In the context of our example, the Special Information Type WF process has AME Approvals switched off, because HR_APPROVAL_FLAG is set to NO. However as per our requirements we need to enable AME for our Holiday Rejection Complaint screen. Effectively, we are trying to achieve a result whereby our custom workflow process is kicked off from the screen we created, and this custom workflow process will ensure that AME is invoked. In order to enable AME approval for our custom screen, you must not modify the standard HRSSA workflow process. Instead you should adhere to some best practices as detailed in this article.

OA Framework Screen in SSHR - HRSSA Workflow - Part 3

Tue, 29 Sep 2009 22:28:59 +0000

In this article you will learn about the Oracle Self Service HRMS workflow, and how this Workflow fits into Self Service Human Resource architecture. This knowledge is required for any technical or functional HRMS person to troubleshoot the common issues that might get reported during Self Service HRMS implementation. First and foremost thing to remember is that a Workflow with item type named HRSSA is instantiated whenever a screen in Self Service HRMS is invoked. If you open this workflow in workflow builder, you will notice that there exists one single "Runnable Workflow Process" for each Employee Self Service HRMS AOL Function. Therefore, there is a direct connection between the AOL Function and HRSSA workflow. Given that the AOL Function is attached to a menu item in SSHR, therefore it is safe to say that there exists a relationship between SSHR menu item and a process within this workflow. Effectively whenever an employee opens a screen in Self Service HRMS it then creates a new instance of the workflow process. Infact the name/path of the OA Framework page that gets opened is configured within the HRSSA workflow itself. By reading this article, you will be able to understand these relationships. However you must read the preceding article linked here, to understand the context of this article.

OAF Screen in Self Service HRMS - Without Programming - Part 2

Mon, 28 Sep 2009 23:25:49 +0000

This article is the followup of previous article in this link

In this article, you will see the detailed step by step instruction for creating a new Self Service Human Resource data entry screen using configuration and personalizations.

To summarize, we need to create a Flexfield structure for data entry with four segments. Thereafter a custom function and a custom menu will be created to invoke the Special Information Type page. Our custom function will thereafter be personalized so that a dedicated screen is made available to the self service HRMS Users for this data entry. The custom AOL function will also be registered against the HRMS Global menu, so that it can be accessible from SSHR [Self Service HRMS].

First and foremost, identify the Key Flexfield to be configured

OAF Screen in Self Service HRMS - Without Programming - Part 1

Sun, 27 Sep 2009 22:25:47 +0000

Imagine you have a new requirement for rectifying a gap in "Oracle Self Service HRMS", i.e. SSHR.

The client requirement is described as below

Requirement a. Give a facility to the employee to complaint when their leave/holiday gets rejected

Requirement b. If an employee's holiday request has been rejected by their manager, they can complaint to their Manager's manager.

Requirement c. In a new OA Framework page, employee will enter the complaint as follow

Holiday Start Date

Number of days

Brief description of their complaint

Is Holiday Health related?

Requirement d. This information is captured in database tables and then sent to employees Manager's Manager for approval.

Effectively you will learn how to develop a complaining mechanism to the boss of your boss, in the event the holiday request has been unfairly rejected.

If the employee's boss's boss approves the holidays, then Central Human resource team is notified.

In this article you will see how to create a Web Based Data Entry screen for this requirement in OAF Self Service HRMS without writing any line of code.

In this first article on this topic, we will simply see the brief steps for creating one such screen. This will be followed by detailed screenshots based steps.

In followup articles, you will also see how this can be integrated with AME. Requirement (c) and Requirement (d) as above can be implemented without writing any code barring some simple Workflow and SQL.

How to create a XML Publisher report to display BLOB images from an RDF report

Sat, 15 Aug 2009 11:23:05 +0000

XML Publisher (release 10.1.3 now BI Publisher) uses templates (data and layout both) to define a BI publisher report.
The good news is that existing custom RDF (oracle designer) reports can be converted into BI reports easily using utilities available online.
Below are the various steps listed for a custom report:

Asynchronous BPEL Process Tutorial

Thu, 09 Jul 2009 20:35:34 +0000

Asynchronous BPEL Process

A Asynchronous Process is one which you call and need not wait for the response before proceeding further. You may just initiate the Asynchronous process and receive the response when you require it as a part of your process, hence you are not forced to wait for response.

For analogy sake, let me give you an example for better understanding. I have chosen simplicity of the analogy above technical similarity.

Real life example of a Synchronous process: You call a friend and ask him to give you some information. While your friend is finding out the information for you, you are on the call waiting for his response. Note that connection is not dropped

Real life example of an Asynchronous process: You call a friend and ask him to give you some information. You ask him to call you back when the information is ready and you disconnect the call. When your friend is ready with the information, he calls you and gives you the information. Note that you don’t wait for a response from your friend and connection is lost. When your friend is ready, he has to establish a new connection and then provide you the information

FNDLOAD AME Objects

Mon, 06 Jul 2009 23:57:11 +0000

We have in the past articles seen various examples of FNDLOAD, for both AOL objects and web ADI. In this article, you will see how to move AME Definitions from one instance to another. The confusing thing about AME FNDLOAD is that these scripts are available in two locations, which are
$AME_TOP/patch/115/import
$PER_TOP/patch/115/import
It is recommended to use the LCT files in $AME_TOP where possible.

In this article, you will learn to download and upload the following AME Components
1. AME Conditions
2. AME Groups
3. AME action type usages
4. AME Rules

Maintaining authentication between APEX applications

Mon, 06 Jul 2009 14:47:22 +0000

If you have a bunch of APEX applications which are authenticated in similar fashion say using EBS login credentials, this article shows you how to maintain authentication while navigating between those applications without going through login process again.

For example, I have a central application which has links to HR and Payables apex applications. I login to central application and navigate to HR application without re-login. Also if I logout from HR application, I will redirected to login page of central application. It is similar to eBusiness Suite security model where upon successful login, I've responsibilities to choose a particular module. This approach makes sense if these apex applications are authenticated in the same way.

How to call Oracle Apps Adapters from BPEL ?

Thu, 02 Jul 2009 00:00:00 +0000

This article would cover setups required to enable BPEL to poll Oracle apps adapter as well as we will also see an example of how all of this fits together