Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Friday, October 18, 2013

Oracle Payroll corrections



Rollback
This is the most commonly used feature. We can use this to un-process the Payroll. However using a Rollback removes the entire history of the data. Let's use Joe's example. All of a sudden we realize that Joe has been paid $200 extra this time. Now we are at the last stage of our post processing. We are running costing now. How do we fix the Issue? 
We will Rollback the Payroll for Joe. We will Rollback the Costing for Joe first. Then the Check writer job, then the NACHA / BACS, then the PrePayments and finally we will rollback his payroll. We will fix his elements, and rerun the entire set of jobs again in the actual order only for Joe.
Cases: So what are the cases where we would process Rollback?
  • We have processed Payroll for a person with a wrong Salary
  • We have processed Payroll for a guy who was terminated long back
  • We have processed Payroll for a wrong assignment set
How: How to Rollback?
  • To rollback payroll of a set of Individuals, Go to the View -> Payroll Process window OR Go to the View -> Assignment Process. Click on the individuals we want to rollback and select Delete Record from the Edit Menu.
  • To rollback payroll of an entire payroll, Submit a new request: "Rollback US Payroll Process". Choose the Payroll run. And Submit.
Retry
Retry is used when we see a small mistake just after the Payroll run. We want to fix it and move ahead with the Process. This is done when we see a set of assignments are processed wrong. We fix the data causing issue and then mark them to retry. It processes only those entries that are incorrect. In some cases where we saw there is something wrong with the Fast Formula we just recompiled; probably a calculation mistake. We fix it and run a retry.
Cases: So what are the cases where we would process a Retry?
  • We have an issue with the Calculation method used in a FF
  • We found out an issue with a set of assignments, where an earning was not added at all.
How: How to Retry?
  • To retry for an assignment, Go to View ->Assignment Process and select the Process we want to retry. Check the Retry Box.
  • To retry for a set of assignments, Go to View ->Payroll Process and select the assignments we want to retry. Check the Retry Box. And then run the "Retry US Payroll Process".
  • To retry an entire Payroll, Go to View ->Payroll Process and select the run, Check the Retry Box. And then run the "Retry US Payroll Process".
Reversal
Reversal is chosen in cases when all the processes are already complete, and we see an issue with an assignment. This will reverse all the Processes this far for the particular Run for the particular assignment. 
Cases: So what are the cases where we would process Reversal?
  • An assignment was processed incorrectly like: An employee got a payment of $400 by a check, which should have gone to someone else.
How: How to Reverse?
  • Open the Employee's assignment screen.
  • Others -> Reverse Run
  • Select the Run we want Reverse.
  • Check the Reverse check Box.
5.4.6.4 Adjusting Balances
When Balances are calculated wrong, or we have done some manual workaround and want the Balance to be updated for the same, we can opt for Balance adjustments.
  • To view Balance of any particular assignment, we can go to View -> Assignment Process Results -> Employee Assignment Processes
  • To Adjust Balances, we can go to the Assignment Record of the Employee, Others->Adjust Balance.

Quick Pay


QuickPay is the process that can be used to process Payroll and Prepayments for one Individual assignment at a time. So this is the Assignment level version of the Payroll Process. Although all the other Post Processing except the Prepayments has to be done separately, but this tool, can help us to do small changes on the assignments and rerun the payroll for them, after a successful rollback. This can also be used as a testing tool. We can just run a quick pay and see the SOE. Once our validation is done, just roll back the Quick pay. It’s so simple.
quick_pay_ben00029
Figure 27 QuickPay Process
(Figure 5.27 – QuickPay Process)

Quick pay can be processed from the assignment screen of an employee. Others -> QuickPay
  • Choose the pay period for which we want to process the quick pay
  • Enter the Pay period end date
  • Select run type as Regular
  • Save the record and Process.


Retro Pay


Retro Pay are one of the Important tools with which we can fix something that has happened in Past. For an example, salary of an employee is increased to $300 as of March, effective from the Month of January. Now, we need to make sure that the Amount of money accumulated since January to March to be paid as part of March Payroll; Similarly, if the Rate of Medical Insurance has been changed from $450 to $550 as of March, effective from the month of January. Here we need to adjust the $100/ month for three months. How do we do that?
There is a process called the Retro Pay that can solve the problem. There are three types of Retro pays, however not all of them are available in a particular localization. 
  • Retro Pay by Aggregate
  • Retro Pay by Run
  • Retro Pay by Element
Even though the concept looks simple, it’s not. We must think about the deductions and taxes in place. If the salary increases by $100, my system will need the entire calculation to be done once again. Not only that, even my balances will need updates. Oracle Payroll takes care of all that. Let's discuss how to achieve the same.

Retro by Aggegate
We can use this, if we do not want to see the way Payroll derives the amount. If we take Joe's example forward, we will never see how payroll came up with that $300 for the three Months, if we use Retro Pay by Aggregate. It’s abstracted. Here it was simple to track, as its just $100/ month. But in Complex Calculations it will be completely abstract.
Set up:
  • Complete the Salary level changes.
  • First thing is to create/ update the element entries with the new value.
  • Now, create the retro pay elements with the following details.
    • Pick an appropriate classification. Should not be Information.
    • Type should be Non-Recurring
    • Should have three input values - Pay Value, Start Date, End Date
  • Create an Assignment set with the Impacted assignments
  • Link the element to the assignment set
  • Create a Retro pay set
  • Process Retro pay request.
Retro by Run
This one is similar to "Retro Pay by Aggregate". Just that it gives us the clear picture without any abstraction. It allows us to see how backdated changes are distributed across Individual processes. Here the system uses the old information and also calculates the difference using the new information and finally updates the system.
Set up:
  • Follow everything that's there in the "Retro Pay by Aggregate". However with the following changes on the element:
    • Multiple Entries allowed flag should be checked
    • It just needs one Input Value "Pay Value". No Start date or end date would be required.
Retro by Element
This option is chosen when we want the retro to be applied for one single Element without recalculating the others. This is highly specific to Elements and does not happen a lot often. Imagine just a Post Tax Bonus was updated wrong in Joe's record. To correct situations like that, we might need Retro Pay by Element
Set up:
  • Update the element entries with the desired value.
  • Create an assignment set 
  • Create an Element Set of type Run Set
  • Process Retro Pay request
Retro by Set
This is not required in Retro Pay by Element. This is used only in the other two cases.
Responsibility: HRMS Manager
Navigation: Payroll -> RetroPay Set
Steps: Create a new record and enter the details.

 Name
 A name for the Retro Pay set
 Description
 Description of the Set
 Balance
 If it's for Retro Pay by Run it must be "ASG_RETRO_RUN". Else, choose an appropriate balance.
 Element Name
 Choose the Retro Pay element here
 Input Value
 Select Pay Value

Retro pay process
Responsibility: HRMS Manager
Navigation: View (M) -> Request (M) ->Submit a new request -> single request
Steps: Enter the name of the Process "RetroPay by Aggregate or RetroPay by Run or RetroPay by Element." and enter the parameters.

 Assignment Set
 Name of the assignment set
 Retro Pay Set
 Enter the Retro Pay set if it’s not Retro Pay by Element
 Element Set
 Enter the Element set if its Retro Pay by Element
 Start Date
 Start Date of the Retro
 End Date
 End Date of the Retro

Oracle Payroll now rolls back and reprocesses all the payrolls for the assignment set from the date we specified. The system compares the old balance values with the new ones and creates entry values for the Retro Pay elements based on the difference. These entries are processed for the assignments in the subsequent payroll run for our current period. No changes are made to our audited payroll data.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect