Pension Scheme With UDT

(Doc ID 2248238.1)

Last updated on MAY 16, 2017

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : Rel 11 version

ACTUAL BEHAVIOR
---------------
When creating a Pension scheme we need to reference a UDT to derive the employee % to use in the calculation.
Amending the Calculation formula as below and the UDT returns the correct value.
However, when passing this in to 'employee_scheduled_contribution_percentage' to use in the 'ORA_PEN_CALC' (Global Pension Calculator) it still passes 0.
Please confirm what other changes are required ?

/* ******************************* COMMENT BEGINS ****************************************
Check UDT for employee contribution (FTE Salary)
 ******************************* COMMENT ENDS **************************************** */

IF GET_PLED_LSED WAS NOT DEFAULTED THEN
(l_date = GET_PLED_LSED)
  ELSE
(l_date = PAY_EARN_PERIOD_END)
 
i = 1
while (RUN_INCLUDED_PAYROLL_ASGS.EXISTS(i)) LOOP
(
  CHANGE_CONTEXTS(PAYROLL_ASSIGNMENT_ID = RUN_INCLUDED_PAYROLL_ASGS[i])
  (

  SET_INPUT('ASSIGNMENT_ID', ASG_HR_ASG_ID)
  SET_INPUT('START_DATE', l_date)
  EXECUTE('UOB_HCM_EMP_HR_DETAILS')
  l_annual_salary=WSA_GET('UOB_CMP_ASG_SALARY_ANNUAL_AMOUNT', 0)
  l_fte = WSA_GET('UOB_PER_ASG_FTE_VALUE',0)
l_annual_salary = l_annual_salary / l_fte
 
  l_tbl_value = TO_NUMBER(GET_TABLE_VALUE('UOB_HCM_NHS',
'Salary',
TO_CHAR(l_annual_salary),
PAY_EARN_PERIOD_END))
  )
  i = i + 1
)
 
employee_scheduled_contribution_p

EXPECTED BEHAVIOR
-----------------------
Pension to be calculated for the employee.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. creating a Pension scheme we need to reference a UDT to derive the employee % to use in the calculation;
2. amending the Calculation formula and the UDT returns the correct value;
3. passing this in to 'employee_scheduled_contribution_percentage' to use in the 'ORA_PEN_CALC' (Global Pension Calculator);
4; it still passes 0.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Pension is not calculated for the employee.

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