Friday, 6 June 2008

Consolidation Set in Oracle Payroll

A Consolidation Set is a means of labelling a collection of Payroll runs. After a payroll Run is complete, it may be required to do some additional processing on a collection of Payroll runs. One example is the Costing process which needs to be run after the Payroll Run.

Defining a Consolidation Set is probably the simplest thing to do in Oracle HRMS :). Just open the Consolidation Set form, click on the new record icon, enter a new name and you are done.

When we define a new Payroll, the consolidation set name is mandatory. While submitting the Payroll Run process, Consolidation Set associated with the Payroll gets populated by default in the SRS window.
Even after a Payroll Run is complete we can update the Consolidation Set by using the Update Payroll Run form.

Monday, 2 June 2008

Workstructures in Oracle HRMS

This entry will just act as a "Hello World" to the world of HRMS Workstructures.Below are some quick definitions of Oracle HRMS Workstructures. Please note that this definitions are not exhaustive. Refer to the Oracle User Guides if you want detailed information.

Location:

Location is the place where employees work.

Business Group:
A Business Group typically represent the whole company.

Organization:
An Organization is like a department. Typical for a company will be HR,Admin,IT etc.

Job:
A Job is a generic role in a company. Typical jobs are manager,director etc

Position:
To define a position you need to give a job and an Organization. A "Director" job in an "IT" organization becomes a "IT Manager" position.Positions are very cumbersome to implement but more powerful than Jobs.

Grades:
Grades are directly related to Salary. Grades span across all other workstructures.

More detailed information later..

Tuesday, 27 May 2008

Running ftp commands from a script

Most of the times the things we do from an FTP server will be the same.
  • Login to the ftp server.
  • Navigate to some directory.
  • Change the file type to binary/ascii.
  • Get the file and close the connection.

We can automate the task by doing the following

open ftpserver
username
password
cd /temp
get somefile
bye

Now from the command prompt give ftp-s:Your_file_name and you are done :)

Friday, 23 May 2008

Multi-Org mandatory for Oracle Applications R12

Multi-Org is mandatory for Oracle Applications R12. For a HRMS customer wishing to move to R12, multi-org needs to be enabled even if they are not using Financial modules.

The following query can be run to determine if Multi-Org is enabled already.

select multi_org_flag
from fnd_product_groups;

Oracle has provided a patch 5965493 which creates a dummy Operating unit named
'Non Usable Operating Unit for Multi-Org Conversion'
Once the dummy operating unit is created we can run adadmin and choose the correct options to convert to Multi-Org.