My Oracle Support Banner

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

Last updated on SEPTEMBER 24, 2018

Applies to:

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


On : 12.1.3 version, Netherlands Payroll Reports

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?


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.