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 SEPTEMBER 01, 2023

Applies to:

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

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