Error component 'G_TYPE_REV_STG_TRFR' must be declared during forms compilation (Doc ID 2847082.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Symptoms

Problem Statement
----------------------
When attempting to apply patch:30399999 during upgrading the instance to 12.2.X,the following error occurs.

Error
-----------------------
The following Oracle Forms objects did not generate successfully:
ja forms/US JAINTORG.fmx
ja forms/US JAINVMTX.fmx

Error (form compilation)
----------------------------
a. JAINTORG.fmb compilation error 

Compiling WHEN-VALIDATE-ITEM trigger on LOT_NUMBER item in LOT_ENTRY data block...
Compilation error on WHEN-VALIDATE-ITEM trigger on LOT_NUMBER item in LOT_ENTRY data block:
PL/SQL ERROR 302 at line 99, column 66
component 'G_TYPE_REV_STG_TRFR' must be declared
PL/SQL ERROR 0 at line 98, column 4
Statement ignored

b.JAINVMTX.fmb compilation error 
   
Compiling WHEN-VALIDATE-ITEM trigger on LOT_NUMBER item in LOT_ENTRY data block...
Compilation error on WHEN-VALIDATE-ITEM trigger on LOT_NUMBER item in LOT_ENTRY data block:
PL/SQL ERROR 302 at line 99, column 66
component 'G_TYPE_REV_STG_TRFR' must be declared
PL/SQL ERROR 0 at line 98, column 4
Statement ignored

Steps to replicate
--------------------
1. This issue is observed while applying patch 30399999.

Expected behavior
---------------------
Expectation is such that the fmx gets generated successfully.

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.