Oracle Payroll Payment Distribution Flow

 

Retry Payroll Example

 Let us say, we have run the payroll and later make some changes to an employee and retry the payroll. The process is as follows.

First Mark the process for retry.

Then run the process Retry Payroll or Retroactive Calculation

Select the correct process name and Submit it.

Once this process is complete the process which was marked for Retry earlier will now show it is completed.

HDL to delete payroll relationship number from Payroll Relationship type Object Group

 File Name: ObjectGroupAmend.dat

METADATA|ObjectGroupAmend|LegislativeDataGroupName|ObjectCode|ObjectGroupCode|ObjectGroupLevelName

DELETE|ObjectGroupAmend|US Legislative Data Group|12345|Test_PRO_Group|Payroll Relationship

Padding Negative numbers in SQL and Etext Templates

 I had a requirement to display a negative number left padded with 0's in etext template. This is how you do it.

FORMAT_NUMBER(-25,'00000000') will give -00002500

In SQL this can be achieved using to_char('-25','000000000')