After Patch 20986782 OZF_UTILITY_PVT IEM_EMAIL_PROC_PVT are invalid (Doc ID 2037104.1)

Last updated on MAY 05, 2023

Applies to:

Symptoms

Two new invalid objects are reported after Patch 20986782.

> PACKAGE BODY IEM_EMAIL_PROC_PVT
> PACKAGE BODY OZF_UTILITY_PVT

versions:
 iemmprps.pls 120.1.12010000.7
 iemmprpb.pls 120.20.12010000.36
 
 ozfvutls.pls 120.7.12010000.5
 ozfvutlb.pls 120.13.12010000.11



ERROR
-----------------------
Errors for PACKAGE BODY APPS.IEM_EMAIL_PROC_PVT:

LINE/COL ERROR

-------- -----------------------------------------------------------------

7055/10 PL/SQL: Statement ignored

7055/10 PLS-00313: 'GETBILLTOSHIPTO' not declared in this scope

SQL> alter PACKAGE apps.OZF_UTILITY_PVT compile BODY;


Warning: Package Body altered with compilation errors.

SQL> show errors;

Errors for PACKAGE BODY APPS.OZF_UTILITY_PVT:

LINE/COL ERROR

-------- -----------------------------------------------------------------

1202/11 PLS-00323: subprogram or cursor 'UPDATE_OZF_ACT_BUDGETS' is

  declared in a package specification and must be defined in the
  package body


1224/11 PLS-00323: subprogram or cursor 'UPDATE_OZF_FUNDS_ALL_B' is

  declared in a package specification and must be defined in the

Changes

Cause

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