Three GMD Forms Fail to Generate After Applying Patch 23255012 or 23121272 (and Possibly Others), and Also Package GMD_QMSMC Became Invalid (Doc ID 2168137.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

After applying patch 23255012 (following application of prerequisite patches R12.OPM_PF.B.delta.7 (23256716) and R12.WMS.B.delta.14 (22598196)), the following Oracle Forms objects did not generate successfully:

gmd forms/US GMDQCSTS.fmx
gmd forms/US GMDQSSTD.fmx
gmd forms/US GMDQSSVT.fmx

GMDQCSTS.fmx
Compiling package body CNTRL_CHG_STATUS...
Compilation error on package body CNTRL_CHG_STATUS:
PL/SQL ERROR 905 at line 100, column 12
object APPS.GMD_STABILITY_STUDIES_VL is invalid
PL/SQL ERROR 0 at line 97, column 7
SQL Statement ignored

GMDQSSTD.fmb
Compiling package body GMD_SS_MATERIAL_SRC...
Compilation error on package body GMD_SS_MATERIAL_SRC:
PL/SQL ERROR 905 at line 449, column 35
object APPS.GMD_STABILITY_STUDIES_VL is invalid
PL/SQL ERROR 0 at line 449, column 2
SQL Statement ignored

GMDQSSVT.fmb
FRM-30064: Unable to parse statement select ss_no
from gmd_stability_studies a
where a.organization_id = :qf_gmdqssvt.organization_id.
ORA-04063: view "APPS.GMD_STABILITY_STUDIES_VL" has errors
Record Group STUDY
Form: GMDQSSVT
FRM-30085: Unable to adjust form for output.

This can also occur after applying patch 23121272, and possibly 22753399 or 22883275. We are discussing the possibiliyt of Obsoleting and Superseding those patches with Development.

Also, applying patch 23255012 caused package GMD_QMSMC to become invalid.

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