After Patch 27026466:R12.EAM.B, EAM_PMDEF_PUB Becomes Invalid

(Doc ID 2384589.1)

Last updated on APRIL 10, 2018

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After applying patch 27026466:R12.EAM.B, package EAM_PMDEF_PUB becomes invalid. When trying to recompile, the following error occurs.


ERROR

SQL> show error
Errors for PACKAGE BODY APPS.EAM_PMDEF_PUB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1317/3 PL/SQL: Statement ignored
1317/6 PLS-00313: 'COUNT_OPEN_WO' not declared in this scope


STEPS

1. Apply patch 27026466:R12.EAM.B.
2. Recompile package below:
  SQL> alter PACKAGE apps.EAM_PMDEF_PUB compile body;
3. Show error detail.

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