EAM_WORKORDERTRANSACTIONS_PUB Compilation Error after Applying EAM Patch 5711045 (Doc ID 754459.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Complex Maintenance, Repair & Overhaul - Version 11.5.10.2 and later
Oracle Enterprise Asset Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-May-2015***


Symptoms

On the attempt to fix the issue described in <Note 471426.1> which is talking about the ability to close a CMRO Work Order when the Accounting or Inventory Period is closed, the following error occurs after applying EAM <Patch 5711045> at package EAM_WORKORDERTRANSACTIONS_PUB compilation:

ERROR

(1): PLS-00201: identifier 'EAM_PROCESS_FAILURE_ENTRY_PUB.EAM_FAILURE_ENTRY_RECORD_TYP' must be
declared
(2): PL/SQL: Item ignored
(3): PLS-00201: identifier 'EAM_PROCESS_FAILURE_ENTRY_PUB.EAM_FAILURE_CODES_TBL_TYP' must be
declared
(4): PL/SQL: Item ignored
(5): PL/SQL: ORA-00942: table or view does not exist
(6): PL/SQL: SQL Statement ignored
(7): PL/SQL: ORA-00942: table or view does not exist
(8): PL/SQL: SQL Statement ignored
(9): PL/SQL: ORA-00942: table or view does not exist
(10): PL/SQL: SQL Statement ignored
(11): PLS-00320: the declaration of the type of this expression is incomplete or malformed
(12): PL/SQL: Statement ignored
(13): PLS-00320: the declaration of the type of this expression is incomplete or malformed
(14): PL/SQL: Statement ignored
(15): PLS-00320: the declaration of the type of this expression is incomplete or malformed
(16): PL/SQL: Statement ignored
(17): PLS-00320: the declaration of the type of this expression is incomplete or malformed
(18): PL/SQL: Statement ignored
(19): PLS-00320: the declaration of the type of this expression is incomplete or malformed
(20): PL/SQL: Statement ignored



-- Steps To Reproduce:

1. Apply EAM <Patch 5711045> as mentioned in <Note 471426.1> to fix the issue of closing Visit after closing Period in Inventory

2. Verify any invalids and see that  EAM_WORKORDERTRANSACTIONS_PUB package is invalid

3. Compile the package and PLS-00201 error is received


Changes

Apply EAM <Patch 5711045> as mentioned in <Note 471426.1> to fix the issue of closing Visit after closing Period in Inventory

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