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:
Oracle Process Manufacturing Financials - Version 12.2.7 and laterOracle 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |