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 DECEMBER 09, 2022

Applies to:

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

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