Three Forms Fail to Compile When Applying Patch 31318662:R12.GME.C, GMEBDTED.fmx, GMETTMTX.fmx, and INVRSVF1.fmx (Doc ID 2722469.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

Customer was instructed to apply patch 31187491:R12.WMS.C to fix an issue that looked similar to this issue. Development then explained that there is a GME patch that goes along with the WMS patch. So we instructed customer to apply patch 31318662:R12.GME.C. There were errors applying the patch.

The following Oracle Forms objects did not generate successfully:

gme     forms/US        GMEBDTED.fmx
gme     forms/US        GMETTMTX.fmx
inv     forms/US        INVRSVF1.fmx

Generating form "forms/US/GMEBDTED.fmx" with command:

/u03/shared/appl/fs1/EBSapps/10.1.2/bin/frmcmp_batch module=/u03/shared/appl/fs1/EBSapps/appl/au/12.0.0/forms/US/GMEBDTED.fmb output_file=/u03/shared/appl/fs1/EBSapps/appl/gme/12.0.0/forms/US/GMEBDTED.fmx module_type=form batch=yes compile_all=special


ERROR generating form "forms/US/GMEBDTED.fmx" from input file
/u03/shared/appl/fs1/EBSapps/appl/au/12.0.0/forms/US/GMEBDTED.fmb

Results of form generation:
(from file /u03/shared/appl/fs1/EBSapps/appl/au/12.0.0/forms/US/GMEBDTED.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compiling package specification APP_CUSTOM...

Compiling package specification GME_MATERIAL_DETAILS_API...
  No compilation errors.

Compiling package body GME_MATERIAL_DETAILS_API...
Compilation error on package body GME_MATERIAL_DETAILS_API:
PL/SQL ERROR 905 at line 147, column 8
object APPS.GME_RESERVATIONS_PVT is invalid
PL/SQL ERROR 0 at line 147, column 8
Statement ignored

Trying to compile the package manually resulted in the following:

SQL> alter  package apps.gme_reservations_pvt compile;

Warning: Package altered with compilation errors.

SQL> show errors
Errors for PACKAGE APPS.GME_RESERVATIONS_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
22/3     PL/SQL: Declaration ignored
31/38    PLS-00201: identifier 'GME_PENDING_PRODUCT_SERIALS' must be
        declared

Changes

Cause

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