My Oracle Support Banner

Employees With Negative Variable Integrated Daily Wage (IDW) Were Reported With Lower IDW Than Fixed Part (Doc ID 2042090.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle HRMS (Mexico) - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Social Security

When the last period of a bi-month has negative variable IDW, the Integrated Daily Wage on the next pay period shows as reduced by the negative Variable IDW

The Fixed IDW to be the same value as reported on the Run Results for the Integrated Daily Wage. This should not be reduced by a negative Variable IDW from the previous BiMonthly period

The issue can be reproduced at will with the following steps:
1. Some employees have negative variable for social security at the end of May-June bi-month period.
2. In July (new bi-monthly period), the IDW for these employees is lower that the fixed part.
3. This happens on both SS reporting (Affiliation report) and also on payroll calculation.
4. Employee has a Daily Salary of 1197.33 and a Factor of 1.1473; so the IDW Fixed Part = 1373.70 (Daily Salary x Factor)
5. Affiliation report and Payroll calculation (for July) have this IDW value: 1124.28
6. This is because the variable part for May-June bi-month period was calculated as: -249.42 (IDW Variable Basis / Days Basis of Quotation 1 = -15214.4 / 61)
7. The IDW = Fixed Part + Variable part = 1373.70 - 249.42 = 1124.28
8. This IDW (1124.28) is lower than Fixed Part (1373.70) and application should not report an IDW lower than Fixed part or to say it other way is that when employees have negative variable at the end of the bi-monthly period, it should not be considered for IDW calculation.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.