My Oracle Support Banner

12.2.10 RUP14 UPGRADE ERROR WITH HR_ASSIGNMENT_API - PLS-00302: COMPONENT 'AUTO_CALC_FTE' MUST BE DECLARED (Doc ID 2765943.1)

Last updated on APRIL 05, 2021

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP14 and later
Information in this document applies to any platform.

Symptoms

When attempting to updated from 12.1.3 to 12.2.10 RUP14, HR_ASSIGNMENT_API became invalid with compiling error occurs.

ERROR
-----------------------

11565/3 PL/SQL: Statement ignored
11565/26 PLS-00302: component 'AUTO_CALC_FTE' must be declared


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 Upgrade application from 12.1.3 to 12.2.10 RUP14
2. found HR_ASSIGNMENT_API compiling with warning.

3. Log into Adamin in application, compile all the invalid in Apps Schema, still the same issue.

4. Manually compiled in database:
SQL> ALTER PACKAGE APPS.HR_ASSIGNMENT_API COMPILE BODY;
 
Warning: Package Body altered with compilation errors.
 
SQL> show error
Errors for PACKAGE BODY APPS.HR_ASSIGNMENT_API:
 
LINE/COL ERROR
-------- -----------------------------------------------------------------
11565/3 PL/SQL: Statement ignored
11565/26 PLS-00302: component 'AUTO_CALC_FTE' must be declared


File version
per/12.0.0/patch/115/sql/peasgapi.pkb:
  $Header: peasgapi.pkb 120.37.12020000.28 2020/02/19 05:32:44 jaakhtar ship $

Changes

 Applied 12.2.10 upgrade from 12.1.3 instance.

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.