After 12.2.7 Upgrade Some Process Manufacturing (OPM) Objects are Invalid In Schemas - GMF, GME, and GMD

(Doc ID 2397872.1)

Last updated on MAY 11, 2018

Applies to:

Oracle Process Manufacturing Financials - Version 12.2.7 and later
Oracle Process Manufacturing Product Development - Version 12.2.7 and later
Oracle Process Manufacturing Process Execution - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version,

After upgrading to 12.2.7, some Process Manufacturing objects are invalid in the schemas GMF, GME, and GMD. These invalids include the following:


GMF_COPY_ITEM_COST PACKAGE
GMF_COPY_ITEM_COST PACKAGE BODY
GMF_ALLOCATIONDEFINITION_PUB PACKAGE
GMF_ITEMCOST_PUB PACKAGE
GMF_BURDENDETAILS_PUB PACKAGE
GMF_ALLOCATIONDEFINITION_PVT PACKAGE
GMF_BURDENDETAILS_PVT PACKAGE
GMF_VALIDATIONS_PVT PACKAGE
GMF_ALLOCATIONDEFINITION_PUB PACKAGE BODY
GMF_BURDENDETAILS_PUB PACKAGE BODY
GMF_ALLOCATIONDEFINITION_PVT PACKAGE BODY

GME_GANTT_LOV_PKG PACKAGE BODY
GME_GANTT_PKG PACKAGE BODY
GME_MATERIAL_DETAILS_V VIEW
GME_STEP_MATERIAL_DETAILS_V VIEW
GME_INGRED_PICK_VW VIEW
GME_MOBILE_TXN PACKAGE BODY
GME_PICKING_PVT PACKAGE BODY
GME_POST_MIGRATION PACKAGE BODY


GMD_FORMULA_DETAIL_PUB PACKAGE BODY
GMD_ERES_MATERIALS_VW VIEW
GMD_ERES_UTILS PACKAGE BODY
GMD_SAMPLES_GRP PACKAGE BODY
GMD_QMSMC PACKAGE BODY
GMD_MBR_MATERIAL_V1 VIEW
GMD_MBR_STEP_MATERIAL_V1 VIEW
GMD_MOBILE_QUALITY_API PACKAGE BODY

 

When compiling these objects, there are errors like the following:


ERRORS:
-----------------------
PLS-00905: object APPS.MTL_ITEM_FLEXFIELDS is invalid


PL/SQL: ORA-04063: view "APPS.MTL_SYSTEM_ITEMS_VL" has errors
PL/SQL: SQL Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform upgrade to 12.2.7
2. Check for invalids



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