APPS Blogs

Balance Adjustment

RameshKumar Shanmugam - Sat, 2007-09-29 16:29
When we process the payroll, there are times that the users might have deducted excess tax or other deduction, So we might need to correct the Balances for the correct YTD and the for year end reporting

There are two methods of doing it.
By defining an Balance Adjustment Element or if we know the exact amount to be corrected then we can able to adjust using the Adjust Balance Form. The latter one is very simple and it is an easy option to adjust the balance

Follow the below steps to adjust the balance using the Adjust Balance form, if we know the exact amount to be adjusted

Fast Path > Adjust Balance > Select the Assignment for which we need to adjust the balance
Set the Effective date
  • Select the element who's pay or the Input Value need to be adjusted
  • Select the Consolidation set to control the further Post-run Processing
  • Check the costing Check box if you need the balance adjustment to be costed
  • Save the work

Try this out!!!

Categories: APPS Blogs

Payroll Reversal

RameshKumar Shanmugam - Sun, 2007-09-16 16:38
After running the payroll and if post run processing has already occured we cannot correct the payroll by Retry, even in case of roll back we need to roll back the complete Payroll for correcting an entry for one or two assignment.
In these cases we can use Payroll Reversal. In short Payroll Reversal helps to correct the run result for an single assignment

To Reverse the Payroll run for an assignemnt
(R) US HRMS Manager
(N) Fast Path > Reverse Payroll Run
Select the Assignment that you need to reverse from the LOV, Tick the Reverse Check Box for the Payroll that we need to reverse and save the work. Consolidation set for the run will be automatically displayed for the Reversal
Now the Run Result is been reversed to the Value before the payroll Run. Now you can modify the Entry and start processing your payroll again.

Try this out!!!
Categories: APPS Blogs

Payroll Rollback

RameshKumar Shanmugam - Wed, 2007-09-05 16:19
Once the Payroll /Quick Pay process is completed if there is some issue or if some correction need to be made. We can either
  • Retry
  • Reverse
  • Rollback

In this blog i am trying to explain how to rollback a Payroll process.

What Rollback does?

In simple word to explain Rollback process reset the Run Result and the Latest balance back to the value before running the Payroll Process.

Rollback process has to be run in the same reverse sequence of the Payroll Run. for eg. for processing the payroll, we run the following process in sequence Payroll run, Prepayment, costing, Transfer to GL. Similarly for the Rollback we need to run in the reverse sequence Rollback Transfer to GL, Rollback Costing, Rollback Prepayment, Rollback Payroll Run.

Note: if the costing details are imported into GL then we cannot rollback the process.So it is always advisable to run the Transfer to GL process after all validation and checking are done and run this process when we feel no more modification are needed

List of Process type that can be rolled back in PF K RUP1

  • Advance Pay Element
  • Balance Adjustment
  • Bank or Post office Payment
  • Batch element entry
  • cheque writer
  • Costing
  • Costing of Payment
  • Estimate costing
  • ext/Manual Payment
  • Magnetic report
  • Magnetic Transfer
  • Pre-Payments
  • Purge
  • QuickPay Pre-Payment
  • Quick Pay run
  • Report Generator
  • Retro Costing
  • Retro Pay
  • Retro Pay by Action
  • Retro Pay by element
  • Reversal
  • Run
  • Transfer to GL
  • Void Payment

Categories: APPS Blogs

Quick Pay Process

RameshKumar Shanmugam - Mon, 2007-09-03 21:32
  • For processing the payroll for a single employee we can use Quick pay
  • For employee who is leaving and for whom we need to pay by check or cash
  • When an employee is joined after the payroll run has been completed for the period we can use Quick pay to process only for this particular employee instead of completely rollback the Payroll Process and starting it again.

Follow the process to run the Quick Pay(N) Assignment > (B) Others > Quick Pay

  • Set the effective Date for the Quick pay
  • Date Paid and Date Earned will be defaulted to the effective date
  • Select the consolidation set
  • Select the Run Types (it varies from Legislation to Legislation)
  • Save the Quick Pay Definition
  • Submit the quick pay by pressing the start Run Button.
  • Status should be changed from un-processed to Complete.
  • If any errors fix the error and press the retry button
  • Once the Quick Pay run is completed we need to process the PrePayment
  • We can run the Prepayment from the Quick Pay window by just clicking the button start PrePayment Or combine it in the Batch PrePayments processing for the assignment’s Payroll (this can be used when a new employee is joined after the payroll run is completed so we can run the quick pay separately for this employee and combine it with the batch or the prepayment.)

Try it out!!!

Categories: APPS Blogs

Payroll Retry

RameshKumar Shanmugam - 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

RameshKumar Shanmugam - 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

RameshKumar Shanmugam - 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

RameshKumar Shanmugam - 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

RameshKumar Shanmugam - 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

Subscribe to Oracle FAQ aggregator - APPS Blogs