RameshKumar Shanmugam

Subscribe to RameshKumar Shanmugam feed
Oracle HR, Payroll, Time and Labor, Self Service HR, Advance Benefit, Talent Management(Performance Management,Competency Management, Performance Appraisal, Goal Management) iRecruitment, Compensation WorkbenchRameshhttp://www.blogger.com/profile/15715619755875567883noreply@blogger.comBlogger34125
Updated: 8 hours 41 min ago

Payroll Retry

Mon, 2007-08-27 11:40
Once the Payroll run is completed there may be chance that few assignment may end up in some errors or few assignment may be processed with some old element entries or payroll department would have processed with limited information or the payroll analyst would have forgotten to modify the formula for earning/deduction element which will affect certain group of Employees, We can uses retries for correcting these mistake which occurred in the Payroll Run provided there are no Post run process taken Place

We can retry a single assignment, set of assignment, or Mark a large payroll Process for Retry

To retry Single assignment
  • It can be done in the quick Pay form by clicking the Retry Button, this is the convenient method for retying if we have very few employees to be corrected

To retry for small number of process

  • In the Payroll Process window, Query the process based on the payroll and the Action type, Mark the process for retry by checking the Retry check box
  • This effectively marks all the assignment attached to the process

To Mark a Large Payroll Process for Retry

  • If we need to retry the payroll, run the Process 'Mark Payroll Run for Retry' this has two parameters Payroll run and the Assignment Set

Note:

  • If any post run process has occurred then we need to rollback the Post Run Process and then mark the process for retry
  • Any assignments having a status of Error after a payroll run, those assignments are automatically retried when you run the payroll again
Try this Process!!!
Categories: APPS Blogs

Payroll Processing

Tue, 2007-08-21 00:41
Before we start the Payroll Run. We need to assign the necessary element for the employee

For the normal payroll run we will include all the elements and process all the assignment
But under certain circumstance we may need

  • Include or exclude certain element or assignment
  • Include or exclude certain group of assignment
  • Include or Exclude certain classification of element

For the above conditions we may need to create an Assignment set or an Element set

Creating Assignment Set

Example for the use of assignment set is. We need to process the payroll for the night shift employees before the day shift employees as they need to receive the Pay advice the night before the rest
For complete details of setting up the Assignment set please refer the blog http://ramesh-oraclehrms.blogspot.com/2007/08/assignment-set.html

Creating Element Set

  • Enter the Element Set name
  • Choose the classification as ‘Run Set’
  • Save the work
  • Select the Include button and add the required element to the set

The Payroll Process

  • Quick Pay
  • Payroll run

Quick Pay

Follow the link for the Quick Pay in Detail

Follow the steps to run the Payroll Process
1) Payroll Process
Parameters: Payroll Name
Consolidation Set
Element Set
Assignment Set
Date Earned
Date Paid
Run type
2) PrePayments
Parameter: Payroll Name
Consolidation set
Start Date
End Date

3) Run the check writer Process (Enabled for few legislation)
4) Run the Direct Deposit Process
5) Payslip Archive Process

If the costing is enabled then
6) Run the costing Process
7) Costing of Payments (if you want to cost at the payment method level)
8) Transfer to GL

From the GL side, import the Journal Entry

Try it out!!!

Categories: APPS Blogs

Assignment Set

Sun, 2007-08-19 16:41
Assignment set are to be defined for the following purpose
  • For processing only the subset of the Assignment for the payroll processing eg: Payroll for the People who work in the night shift need to be processed first as they need to receive the pay advice before the day shift employees
  • For generating the quick paint report for the set of assignment
  • Can be used in the BEE for creating the identical entry for all the assignment in the Assignment set

Before we start defining the Assignment set we need to decide whether we are going to use Assignment set for the payroll process or for some other process like reporting etc.

Defining the Assignment set

  • Enter the name of assignment set (Only Char, ( _ ) and Numbers are allowed and NO SPACE allowed)
  • If you need to use this assignment set only for the payroll then select the Payroll from the LOV Otherwise it is an optional field we can leave it blank.
  • Save the work

If we want to use the formula criteria for defining the Assignment set choose the button Criteria from the assignment set window

  • Enter the Seq Number
  • Leave the Condition field Blank for the first line, you can choose either AND / OR depending on the criteria
  • Choose the Database Item as the variable for the criteria (all the Database Item will be prefixed by '&')
  • Choose the Operator (=, <=, >= , etc..,)
  • Enter the Value or choose the Database Item
  • Keep entering the other criteria from the second line
  • Save the work

If you specifically want to include or exclude any assignment choose the button Amendment button

  • Choose the option Inc/Exc from the LOV
  • Select the Name from the LOV
  • Save the work

Select the Generate Button for generating the Fast Formula for the criteria defined above. The Fast formula will be created with the same name as the assignment set

Try it out!!!

Categories: APPS Blogs

Cost Allocation flexfield and Costing process

Mon, 2007-08-13 17:40
Following are the important Key flexfield in HR and Payroll

HRMS

  • Job Flexfield
  • Position flexfield
  • Grade Flexfield
  • People Group
  • Cost Allocation
  • Competence Flexfield
  • Personal Analysis Flexfield
  • Soft Coded KeyFlexfield
Payroll

  • People Group Flexfield
  • Cost Allocation Flexfield
  • Bank Details KeyFlexField
Setting up of Cost allocation flexfield is an mandatory setup step for the Payroll Setup

Cost allocation Flexfield is used to accumulate the employee costing information, if we use Oracle Payroll we can accumulate the cost associated with the payroll and transfer to GL and if we are not using Oracle Payroll we can able to interface the costing information to the third Party Payroll system

Few important points which should be taken care before creating the Cost allocation flexfield.

  • If we are planning to integrate with the GL, then the number segment in the cost allocation flexfield should be same or more than the accounting flexfield.

  • We should atleast have one segment for the cost allocation flexfield otherwise will run into error when defining payroll or in other form which is having this flexfield

Cost Allocation flexfiled makes use of qualifiers, we can use the segment qualifiers to control the level at which the costing information can be entered in the system.the various level at which we can cost are

  • Element entry
  • Assignment
  • Organization
  • Element Link
  • Payroll

If the element is not costed at any level then the final costing information will get accumulated in the suspense account which is defined in the payroll form.

Use the GL Map window to map the cost allocation flexfield with the GL Accounting flexfield, we should map each cost allocation segment with the GL Segment for each Payroll. for the addition segment in the cost allocation flexfield should be mapped to 'Null'

Following are the process that you need to run for transferring the costing information from Oracle to Payroll

  • Costing process
  • Costing of Payment
  • Transfer to GL

Try it out!!!

Categories: APPS Blogs

Assignment action interlock rule failure

Sun, 2007-08-12 17:02
During the Payrol Run Rollback Many time we might come accross with the Error message
APP-PAY-07507: Assignment action interlock rule failure

This May be due to multiple resason but one such reason is, there may be some future sequenced process which has to be rollback before we roll back the current process.

To find the list of all future sequenced process Exucute the following Query

select distinct pact.payroll_action_id, pact.effective_date, pact.action_type
from pay_action_classifications CLASS,
pay_payroll_actions PACT,
pay_assignment_actions ACT,
per_assignments_f ASS,
per_periods_of_service POS,
pay_assignment_actions act1,
per_assignments_f ass1
where POS.person_id = ass1.person_id
and ass1.assignment_id = act1.assignment_id
and ASS.period_of_service_id = POS.period_of_service_id
and ACT.assignment_id = ASS.assignment_id
and ACT.action_sequence > act1.action_sequence
and ACT.action_status in ('C', 'S', 'M')
and ACT.payroll_action_id = PACT.payroll_action_id
and PACT.action_type = CLASS.action_type
and CLASS.classification_name = 'SEQUENCED'

This Query will return the list of all future sequence process which need to be rolled back first before we rollback the current process

Hope this helps :)
Categories: APPS Blogs

Pages