My Oracle Support Banner

Self Service Leave of Absence Error ORA-06553: PLS-801: internal error [pklsdlp:dependency verification] (Doc ID 2502288.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Self-Service Human Resources - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

 When attempting to  access the Absence Management Function,
the following error occurs.

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error
during statement preparation.  Statement: SELECT * FROM (select
decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf.global_name,ppf.loca
l_name) full_name,
      ppf.person_id,
      ppf.employee_number,
      ppf.npw_number,
      decode(ppf.current_employee_flag, 'Y', 'Y',decode(ppf.current_npw_flag,'Y','Y'),'N') active,
      paf.assignment_id,
      paf.assignment_number,
      paf.assignment_type,
      paf.primary_flag,
      paf.supervisor_id,
decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',sup.global_name,sup.loc
al_name) supervisor_name,
      HR_UTIL_MISC_SS.getBusinessGroup(:1,ppf.business_group_id,ppf.person_id) as
business_group_id,
      paf.organization_id,
      bustl.name business_group_name,
      orgtl.name organization_name,
      paf.job_id,
      jtl.name job_name,
      paf.position_id,
      postl.name position_name,
      oi.org_information10 currency_code,
      oi.org_information2 employee_number_generation,
      oi.org_information3 applicant_number_generation,
      oi.org_information16 npw_number_generation,
      oi.org_information9 legislation_code,
      fs.id_flex_structure_code people_grp_f_struct_code,
      oi.org_information14 security_group_id,
      null effective_date,
      paf.location_id,
      paf.grade_id,
      paf.effective_start_date,
      paf.effective_end_date,
      paf.payroll_id
from    per_all_people_f ppf,
      per_all_assignments_f paf,
      hr_all_organization_units_tl bustl,
      hr_all_organization_units_tl orgtl,
      per_jobs_tl jtl,
      hr_all_positions_f_tl postl,
      per_all_people_f sup,
      hr_organization_information oi,
      fnd_id_flex_structures fs
where   ppf.person_id = :2
and     ppf.person_id = paf.person_id
and     paf.assignment_type in ('E', 'C')
and     paf.supervisor_id = sup.person_id(+)
and     ppf.business_group_id = oi.organization_id
and     oi.org_information_context = 'Business Group Information'
and     oi.org_information5 = fs.id_flex_num(+)
and     fs.id_flex_code(+) = 'GRP'
and     fs.application_id(+) = 801
and     ppf.business_group_id = bustl.organization_id
and     bustl.language = :3
and     paf.organization_id = orgtl.organization_id
and     orgtl.language = :4
and     paf.job_id = jtl.job_id(+)
and     jtl.language(+) = :5
and     paf.position_id = postl.position_id(+)
and     postl.language(+) = :6
and     :7 between ppf.effective_start_date and ppf.effective_end_date
and     :8 between paf.effective_start_date and paf.effective_end_date
and     :9 between sup.effective_start_date(+) and sup.effective_end_date(+)) QRSLT  WHERE
(primary_flag(+) = :10)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at
oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:

## Detail 0 ##
java.sql.SQLException: ORA-06552: PL/SQL: Statement ignored
ORA-06553: PLS-801: internal error [pklsdlp:dependency verification]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to 'Employee Self-Service' -> Absence Management
2. Shows Error.

OTHER IMPORTANT INFORMATION
--------------------------------------------------

1. Used adadmin utility to compile the APPS schema, did not help.
2. Running the following SQL gives error (this call has been done from the SQL above)

SELECT HR_UTIL_MISC_SS.getBusinessGroup (function_id, business_group_id,person_id) AS business_group_id FROM DUAL ;

SELECT HR_UTIL_MISC_SS.getBusinessGroup (p_function_id, p_bg_id,p_person_id) AS business_group_id FROM DUAL
     *
ERROR at line 1:
ORA-06552: PL/SQL: Statement ignored
ORA-06553: PLS-801: internal error [pklsdlp:dependency verification]

Changes

 No recent changes.

Cause

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
Symptoms
Changes
Cause
Solution
References


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