Entering Public Sector Pension Details On Extra Detail of Service Form Error APP-PER-51938 ORA-06508 in API module PQP_ASSIGNMENT_ATTRIBUTES_F at hook After Insert

(Doc ID 2112635.1)

Last updated on APRIL 21, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Pensions funtionality

When attempting to enter the detail on Extra Detail of Service Form
the following error occurs.

ERROR
-----------------------
APP-PER-51938: The system cannot find the program unit being called.
This could be because the application API pre-processor has not been run.
Contact your system administrator quoting the following details: Error ORA-06508 in API module PQP_ASSIGNMENT_ATTRIBUTES_F at hook After Insert.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an employee/assignment record.
2. Go to Assignment=>Others=>Extra Detail of Service form.
3. Enter the following on Public Sector Pension Detail
  LGPS/PCSPS Process Flag: Yes
4. Save the form.
5. System throws the following error message:
  "APP-PER-51938 - System cannot find the program unit being called. This could be because the application API processor has not
  been run. Contact your system administrator quoting the following : Error ORA-6508 in API module PQP_ASSIGNMENT_ATTRIBUTES_F at hook
  After Insert"

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