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

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Oracle Email Center - Version 12.1.3 and later
Information in this document applies to any platform.

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms