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 JANUARY 03, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.