How to Enable EIT in Self Service and in Core HR

Extra Information Types (EITs) are a type of descriptive flex-field that help us to configure and store the extra information.Unlike the descriptive flexfield, EITs are child entities with separate tables to hold the information.It means one can store multiple instances of  an EIT for each main record.
Here we will discuss about how to create an EIT and enable in Self-Service.
Basic Requirement  
Our basic requirement is to  create an EIT (person) with the following editable field.

1. Full Name                        --- Mandatory Free text field
2. Effective Date                   ---Mandatory Date field
3. Amount                           --- Mandatory Numeric field
4. Closed(Y/N)                    ---  Mandatory Field with Y/N LOV

• The EIT will be viewable from US Super HRMS Manager and Employee-Self Service responsibility. 
• In self-service a dedicated link should be provided to see/update/add data to this EIT.
• Other EIT must not be visible from this new link available under Employee-Self Service Menu.
• Employee will able to Add/Update the entery and on submission this will go for approval.
• HR can enter information directly via Super HRMS Manager.
• User should able to enter more than one entry. 

To read the full document go to Shareapps4u

How to Enable/Disable Concurrent Program Parameter Dynamically

concurrent program is a data-intensive task.A concurrent program is an executable file that runs simultaneously with other concurrent programs and with online operations, fully utilizing system's hardware capacity.

Standard Request Submission (SRS) is an Oracle Applications feature that allows us to select and run any concurrent programs from a single, standard form (Submit Request) or window (Schedule Request). Requests to run concurrent programs are called concurrent requests.

Basic Requirement 
Our basic requirement is to enable or disable concurrent program parameter dynamically.Here we will take two different requirement scenario
Scenario I
We have to define a concurrent program with the following parameter
Run Mode:- The parameter will contain a list of values.

• REPORT           :- Report mode will generate a report.(as per requirement)
• ROLLBACK    :- Rollback mode will rollback/delete the data changes done by previously executed request

Request Id:- This parameter will allow the user to select any of the previously executed concurrent request.

Request Id parameter will be enabled and mandatory if the Run Mode is selected as "ROLLBACK".
If the Run Mode is selected as "REPORT", then Request Id parameter will remain disable.



To read the full document go to Shareapps4u

How to Add Element Value in Oracle Online Payslip

Online Payslip enables employees to view their own payslip, via the Employee Self Service menu after payroll processing has been completed. Managers can also search for, and access the payslip of individual employees via the Payroll Professional menu.

The information displayed on the payslip is generated by an archiver program during the payroll process. This process and the payslip are localised for each payroll legislation supplied by Oracle to satisfy local requirements.

Each legislation has it's own requirements regarding what information to display on the Online Payslip. There will be standard information including header details such as Name, Address, Employee Number and National Identifier, and also statutory deductions and balances. There is also a user-definable capability as each legislation allows the user to specify additional site specific elements and balances that they wish to include on their payslip

Basic Requirement

Our basic requirement is related to US legislation requirement.
It says:- Over Time rate must be displayed for all "Hourly" employee irrespective of their elligibility of OverTime payment.
This can be extent to any legislation or method can be used to fullfill other business requirement of similar kind.

To read the full document go to Shareapps4u

How to Send Reminder Notification to Approver

Oracle Workflow provide us several standrad functions which helps us to implement our business requirement.

 

Here we will discuss about two such standard functions to implement our requirement.

Basic Requirement

Our old requirement looks like "when a person applies for a leave it should go his/her supervisor for approval.Approver must be able to provide his/her approval/rejection comments. The comments must be entered by the approver while rejecting the leave requisition.If he/she rejects the leave requisition without entering comments, then it should raise an application error.If he/she approves the requisition it should be optional.Approver must also be able to select theOrganization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database.The approver should able to view/edit the person "Special Information Types" before approving the leave request.Before approving the sick leave request the approver must able to see the submitted medical document."

 

Apart from the above requirement, We will introduce an additional requirement that "A reminder notification(email) must go to approver in every 2 days untill he/she takes action (Approve or Reject) on the leave notification."

 

 

To read the full document go to Shareapps4u

 

How to Use XML Bursting to Send XML Report via Email

Oracle Bursting Mechanism enables us to deliver a single XML Publisher report/letter to multiple destinations simultaneously.One can create a single report/letter , then send it in any format (e.g., PDF or HTML) to multiple destinations(email ids).
There are two kind of bursting mechanism available within BI publisher

1) Control File Base:- Integrated with EBS
2) Delivery SQL based:- Part of Enterprise release.All delivery, template, output format, locale and other details define through delivery SQL Query. Enterprise Edition assume that this information is stored in data base. The process create the XML file out if this query and the delivery xml file works as control file.

 

Here we will discuss about the "Control File Base" mechanism.

 

To read the full document go to Shareapps4u

How to Create Global User Defined Table(UDT)

User Defined Table(UDT) is a table defined by the user in application to hold the data .Oracle HRMS user-defined tables are different from the database tables of the Oracle Relational Database Management System.While defining the table we need to define all the rows and the columns. With the help of Oracle Fast formula, we can validate the entry made in the table column. 

Basic Requirement

Our basic requirement is to create a global UDT that will hold the employee data and can be accessible from across the business group.

To read the full document go to Shareapps4u

How to Retrieve XML Publisher Report output

Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite.One can Design and control how the report outputs will be presented in separate template files,known as template.At runtime, XML Publisher merges designed template files with the report data to create a variety of outputs to meet a variety of business needs.

To read the full document go to Shareapps4u

How to Add Third Party Web Page Link to Oracle Application Web Page

Oracle e-Business Suite may require to integrate with third party/custom tool/software to augments the investment in Oracle e-Business Suite and to meet the business requirements.There are large number of third party tool/software available in the market that can be integrate with e-business Suite (for example Org-Plus).


Here we will discuss about how can we provide a hyper-link to oracle application web page through which we can navigate to third party web-page/or any custom created jsp page.

Basic Requirement
We need to provide a hyper-link to "My Employee Information" page so that we can directly access the third party web page via the hyper-link.
The third party sample URL is :-
https://cust-devenv.Client.local/OPE/Access.aspx?user=<Username> 

cid=<EmployeeNumber>&rid=<RoleName>&status=valid 

Here <Username>,<EmployeeNumber> => needs to be taken from the person who has logged in the system

             <RoleName> => Role Name will be based on the responsibility

                                 through which Third Party page will be accessed. 

                                For Manager Self  Service  Role Name is "XX_Manager".

To read the full document go to Shareapps4u

Problem With XML Parsing

XML stands for Extensible Markup Language.XML was designed to carry data not to display data.XML was designed to transport and store data, with focus on what data is.

An XML Parser is a parser that is designed to read XML and create a way for programs to use XML. There are different types, and each has its advantages.

The different types of parsers are:- a) SAX b) DOM c) PULL

To read the full document go to Shareapps4u

How To Customise Vacancy Search in iRecruitment- Adding Subsidiary Logo

Oracle iRecruitment enables us to set up a flexfield to capture additional vacancy (and candidate) information that can then be used by managers searching for a job/vacancy (or candidate and by candidates searching for a job).

Basic Requirement
The Basic requirement is explained below

The end user(recruiter/manager) should able to search a job based on the subsidiary company. Business will provide us the different subsidiary logo that should be available in the page and when clicks on that logo , the subsidiary field(available under vacancy search)  must be populated with the value. When recruiter/Manager clicks on go it should show only the vacancy for that subsidiary.

The requirement is explained below with a prototype.

To read the full document go to Shareapps4u

How to Change User Password

Users log in to Oracle Applications using a client web browser. From the Oracle Applications Login page, users access the E-Business Suite Home Page(AppsLocalLogin.jsp) which provides a single point of access to HTML-based applications, forms-based applications, and Business Intelligence applications.

Here we will discuss how can we change the user password with the help of oracle provided API.

Basic Requirement
Our basic requirement is to change the user password programatically and also force the user to change the password(which was changed through API) onfirst login.

To read the full document go to Shareapps4u 

How To Send Notification To Multiple Users

sOracle Workflow roles are stored in the database, in the Oracle Workflow directory service.The performer can be an item type attribute that dynamically returns a role.To send a single notification(FYI/Actionable) to multiple users we have to use Role attribute as performer of that notification.The attribute value must be the internal name of a role. 

Here we will discuss how can we send a single notification to multiple users.

Basic Requirement

Our old requirement looks like "when a person applies for a leave it should go his/her supervisor for approval.Approver must be able to provide his/her approval/rejection comments. The comments must be entered by the approver while rejecting the leave requisition.If he/she rejects the leave requisition without entering comments, then it should raise an application error.If he/she approves the requisition it should be optional.Approver must also be able to select theOrganization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database.The approver should able to view/edit the person "Special Information Types" before approving the leave request.Before approving the sick leave request the approver must able to see the submitted medical document."

Now we will twist our original requirement- Instead of going to Supervisor for approval, all the leave request must go to the following identified people

• ROLE1_APPR (User name of the person)
• ROLE2_APPR (User name of the person)
• ROLE3_APPR (User name of the person)

To read the full document go to Shareapps4u 

How To Attach Document With Notification

Oracle Workflow also provide us a provision to attach document and help us to share information with the different stakeholders of business process (whereever is required) .

In a workflow process, we can attach documents generated by a PL/SQL procedure, which we call PL/SQL, PL/SQL CLOB, or PL/SQL BLOB documents.

Here we will discuss about the ways to attach PL/SQL BLOB and PL/SQL CLOB with the notification.

Basic Requirement

Our old requirement looks like "when a person applies for a leave it should go his/her supervisor for approval.Approver must be able to provide his/her approval/rejection comments. The comments must be entered by the approver while rejecting the leave requisition.If he/she rejects the leave requisition without entering comments, then it should raise an application error.If he/she approves the requisition it should be optional.Approver must also be able to select theOrganization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database.The approver should able to view/edit the person "Special Information Types" before approving the leave request."

In addition to the above requirement:- When a Person applies for leave* he/she also submits the medical document. Approver should able to see the submitted medical document submitted by person.

* ==> Here we are considering only sick leave.

To read the full document go to Shareapps4u 

How to Restrict Agency from entering Duplicate Candidate

Agency personnel can Search for vacancies assigned to that agency, and view vacancy details such as the maximum number of applicants that can submit for a vacancy and current number of applicants.They can also create user accounts for candidate and apply for job on behalf of candidate.

Basic Requirement

Our basic requirement is as mentioned below:-

Oracle application doesn't restrict agency from entering duplicate candidate.Now our organization is landing up paying multiple times  for a single candidate,since there are multiple entry for a single candidate is found. Now our basic requirement is to restrict the agency from entering duplicate candidate.

The duplicate candidate can be identified by email address.

If agency personnel try to enter candidate with already existing email address then application should throw an error.

To read the full document go to Shareapps4u 

iRecruitment Data Migration - How To Migrate Resume

Oracle iRecruitment integrates with Oracle HRMS to manage the entire workforce lifecycle.It automates every phase of the recruitment process.Most of the companies have their Recruitment solution.Now in most of the iRecruitment implementation we need to do the migration of Resume files from already existing system to newly configured (may be from iRecruitment perspective) oracle iRecruitment system.Here we will only discuss about  how we can migrate resume from existing system to our oracle system.

Here we have considered that reader has a basic knowledge on Oracle iRecruitment functionality and aware of terminology(candidate,applicant,vacancy etc..).

Basic Requirement

Our basic requirement is to migrate Resume files and make it available through iRecruitment.

Pre-Requisite

 Following are the pre-requisites for Resume migration
 1) iRecruitment system is configured
  2) Candidate and/or Applicant are already migrated and present in the system.
  3) Resume files are already transfered from older system to our oracle database server(say database server path:- /usr/tmp ).The path may differ in your case.
 4) The candidate/applicant resume mapping file(file that contains the candidate/applicant necessary details(any unique identifier) and corresponding file name. The mapping file is loaded in our migration stagging table.

To read the full document go to Shareapps4u 
 

How To Take Approver's Input- Launching Oracle Form from Workflow(from Approver's Notification)

Oracle Workflow also provide us a provision to launch Oracle form/s from a notification.It helps the performer to see the details that is stored in core HR without explicitly login into system from another session.
We are now quite familiar with oracle workflow and already developed some of simple workflows. Now we will discuss here how can we give the user a provision to open a form from notification itself.

Basic Requirement
Our old requirement looks like "when a person applies for a leave it should go his/her supervisor for approval.Approver must be able to provide his/her approval/rejection comments. The comments must be entered by the approver while rejecting the leave requisition.If he/she rejects the leave requisition without entering comments, then it should raise an application error.If he/she approves the requisition it should be optional.Approver must also be able to select the Organization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database."

In addition to the above requirement:- The approver should able to view/edit the person "Special Information Types" before approving the leave request.

To read the full document go to Shareapps4u 

Form Personalization - How to Change Field Name

Form Personalization feature allows us to alter the behavior of Forms-based screens, including changing properties, displaying messages etc.
For a single form-function(a form running in a particular context based on parameters passed to it defined at function level) we can specify one or more Rules. Each Rule consists of an Event, an optional Condition, the Scope for which it applies, and one or more Actions to perform.

Here we will discuss about how can we change the field display name.

Basic Requirement

Our basic requirement is to change name the 'Latest Start Date' field to 'ABCD' in people Screen. Remember this name change should only be applicable for persons who are using 'UK HRMS Manager'.


To read the full document go to Shareapps4u

How To Take Approver's Input- Making approver comments a mandatory Free Text field

We have already discussed how we can provide a free text field to approver. Now Our aim is to make the field mandatory.

Basic Requirement 
Our old requirement looks like "when a person applies for a leave it should go his/her supervisor for approval. Approver must be able to provide his/her comments for approval or rejection of the requisition(comments optional). Approver must also be able to select the Organization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database."

Now our changed requirement will looks like
"when a person applies for a leave it should go his/her supervisor for approval.Approver must be able to provide his/her approval/rejection comments. The comments must be entered by the approver while rejecting the leave requisition.If he/she rejects the leave requisition without entering comments, then it should raise an application error.If he/she approves the requisition it should be optional.Approver must also be able to select the Organization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database."

Design Appraoch 
Following  interpretation can be drawn from the above requirement.
1) The comment field is mandatory while rejecting the leave request.
2) The comment field is remain as optional if he/she approves the requisition.


To read the full document go to Shareapps4u

How To Take Approver's Input- Providing a Drop Down field

Now  we know how to put a place holder for approver comments.Now we will learn how we can provide a list of values, so that approver can select a possible values from the drop down.

Basic Requirement
Our new requirement looks like "when a person applies for a leave, it should go his/her supervisor for approval. Approver must be able to provide his/her comments for approval or rejection of the requisition(comments is optional).and once it is approved save the information in database . If the leave gets rejected, don’t store any information in database."
Now we will change our requirement a bit. It is as mentioned below"when a person applies for a leave it should go his/her supervisor for approval. Approver must be able to provide his/her comments for approval or rejection of the requisition(comments optional). Approver must also be able to select the Organization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database."

The possible "Organization Leave Type" list of values are
1)  Medical Leave
2) Personal Unpaid Leave
3) Personal Paid Leave
(Change requirement is in bold)

To read the full document go to Shareapps4u

How To Take Approver's Input - Providing a Free Text Field

We have already build a simple custom workflow. Now we will make our previous workflow more n more complex.

Basic Requirement
Our initial requirement was "when a person applies for a leave it should go his/her supervisor for approval and once it is approved save the information in database . If the leave gets rejected, don’t store any information in database."
Now we will change our requirement a bit. It is as mentioned below"when a person applies for a leave it should go his/her supervisor for approval. Approver must able be to provide his/her comments for approval or rejection of the requisition.Once it is approved save the information in database . If the leave gets rejected, don’t store any information in database."
(Change requirement is in bold)

To read the full document go to Shareapps4u