My Oracle Support Banner

UPRGRADE ERROR PAY_US_GEO_UPD_PK PLS-00302: Component 'AUTO_CALC_FTE' (Doc ID 2768924.1)

Last updated on APRIL 23, 2021

Applies to:

Oracle HRMS (US) - 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, PAY_US_GEO_UPD_PKG compiling with
the following 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 PAY_US_GEO_UPD_PKG Icompiling with warning.

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


File version

pay/12.0.0/patch/115/sql/pyusgeou.pkb:
  $Header: pyusgeou.pkb 120.27.12020000.23 2017/09/20 11:25:55 samkar ship$

pay/12.0.0/patch/115/sql/pyusgeou.pkh:
  $Header: pyusgeou.pkh 120.4.12020000.5 2016/07/20 10:24:01 samkar ship $

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
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.