My Oracle Support Banner

PQP_230334_ENROLL_WRONG_SCH Error In Penserver Payment History For Employees Migrated On 01-APR-2015 under TUPE (Doc ID 2034462.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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


Receive the error:-

PQP_230334_ENROLL_WRONG_SCH Error in Penserver Payment History for employees migrated on 01-APR-2015

Employees migrating to Oracle System on 01-APR-2015 hence their start date in Oracle is '01-APR-2015'. The employees are already having Principal Civil Service Pension Schemes assigned to them and have to continue with the same scheme. For eg if an employee was in Classic Scheme in the previous system he or she will having the same scheme from 01-APR-2015 in Oracle too and not Alpha Scheme as the employee is not a new Joiner.

Now when we run the Penserver Interface Processs for Payment History Interface it gives an error PQP_230334_ENROLL_WRONG_SCH as it expects the employee to be in Alpha Scheme which is wrong as the employee is not a new joiner. We analysed the Oracle Code and issue happens due to the below validation:

  if l_hire_date >= fnd_date.canonical_to_date('2015/04/01') and p_scheme <> 'CSO' then
  debug('ERROR: Employee is enrolled in the wrong scheme',20);
  l_value :=
  p_error_number => 230334
  ,p_error_text => 'PQP_230334_ENROLL_WRONG_SCH'
  end if;

l_hire_date is fetched by the following query:

SELECT MIN(effective_start_date)
  FROM per_all_assignments_f
  WHERE assignment_id = p_assignment_id;

hence using adjusted service date is also not an option.





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.