Wage Report Total For Premieloon UFO (PrLnUfo) Tag Doesn't Match The Sum Of Nominative (Doc ID 2048930.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Netherlands Payroll Reports

ACTUAL BEHAVIOR
---------------
During our monthly tests we have found a bug in the Dutch Wage Report, where the collective amount for the PrLnUFO tag does not match the sum of the nominative amounts for the same tag whenever the element "New Wage Report Override" is used. The differences are in the order of several thousand euro and the Dutch Tax Office has already complained about it.

After digging deep in the Wage Report logic, I have found that for the PrLnUfo the wage report expects to retrieve the balance "Retro Actual SI Base" using 2 dimensions:
  g_col_bal_def_table(x).balance_name := 'Retro Actual SI Base'; --19
  g_col_bal_def_table(x).database_item_suffix := l_tu_sit_payroll_adj_ptd;
  g_col_bal_def_table(x).database_item_suffix2 := l_tu_sit_payroll_corr_ptd;
  g_col_bal_def_table(x).context := 'SOURCE_TEXT';
  g_col_bal_def_table(x).context_val := 'UFO' ;

where in our case the above dimensions are:
  l_tu_sit_payroll_adj_ptd := '_TU_SIT_MONTH_ADJ_PTD';
  l_tu_sit_payroll_corr_ptd := '_TU_SIT_MONTH_REP_CORR_PTD';

The above dimensions have not yet been defined for seeded balance "Retro Actual SI Base", as it can be easily verified in the balance definition form. The result is that the collective amount for PrLnUfo tag is missing the retrospective amounts that should be retrieved by the above dimensions.

As a quick workaround I have added the above dimensions to seeded balance "Retro Actual SI Base" and the totals mismatch is solved. Could you please deliver a new legislative patch with the updated defined dimensions for the balance in question? Why the Exception Report does not detect and report this mismatch?

Since this is not the first time we encounter a similar issue, could you also please review ALL the defined balances used in the Dutch Wage Report and make sure that there are no other similar issues left in the report?

EXPECTED BEHAVIOR
-----------------------
Correct values to be reported on the Dutch Wage Report


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms