My Oracle Support Banner

Applying EBS Patches 32294351, 31713023, 31700686 & 31696168 Forms Generation Failed 'Compilation error on package body TOLINES_CONTROL' (Doc ID 2790376.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Oracle Inventory Management - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, Patch Application Issues


After applying EBS Patches 32294351, 31713023, 31700686 & 31696168, the following Oracle Forms objects did not generate successfully:

inv forms/US INVTTMTX.fmx
inv forms/US INVIDITM.fmx
inv forms/US INVTOTRX.fmx

Attached are the worker log files while generating the forms using adadmin.
We aborted the patching cycle and performed cleanup post abort.

Compile Errors

INVTTMTX.log

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on MTL_TRX_LINE data block...
Compilation error on WHEN-NEW-BLOCK-INSTANCE trigger on MTL_TRX_LINE data block:
PL/SQL ERROR 801 at line 1, column 1
internal error [phdite:node kind]
PL/SQL ERROR 0 at line 93, column 3
Statement ignored

--------------------

INVTOTRX.log

Compiling package body TOLINES_CONTROL...
Compilation error on package body TOLINES_CONTROL:
PL/SQL ERROR 801 at line 1, column 1
internal error [phdite:node kind]
PL/SQL ERROR 0 at line 1477, column 4
Statement ignored
PL/SQL ERROR 801 at line 1, column 1
internal error [phdite:node kind]
PL/SQL ERROR 0 at line 1485, column 12
Statement ignored
PL/SQL ERROR 801 at line 1, column 1
internal error [phdite:node kind]
PL/SQL ERROR 0 at line 1517, column 7
Statement ignored

--------------------------------------

INVIDTMP.log

Compiling PRE-INSERT trigger on form...
Compilation error on PRE-INSERT trigger on form:
PL/SQL ERROR 801 at line 1, column 1
internal error [phd_get_defn:unqualified external]
PL/SQL ERROR 0 at line 36, column 4
Statement ignored

Compiling PRE-UPDATE trigger on form...
Compilation error on PRE-UPDATE trigger on form:
PL/SQL ERROR 801 at line 1, column 1
internal error [phd_get_defn:unqualified external]
PL/SQL ERROR 0 at line 37, column 4
Statement ignored

------------------------------------------------

INVIDMNT.log

Compiling WHEN-VALIDATE-RECORD trigger on MCC_ASSIGNMENTS data block...
Compilation error on WHEN-VALIDATE-RECORD trigger on MCC_ASSIGNMENTS data block:
PL/SQL ERROR 801 at line 1, column 1
internal error [phd_get_defn:unqualified external]
PL/SQL ERROR 0 at line 5, column 3
Statement ignored

Compiling KEY-DELREC trigger on MCC_ASSIGNMENTS data block...
Compilation error on KEY-DELREC trigger on MCC_ASSIGNMENTS data block:
PL/SQL ERROR 801 at line 1, column 1
internal error [phd_get_defn:unqualified external]
PL/SQL ERROR 0 at line 5, column 3
Statement ignored

----------------------------------------------

 INVIDITM.log


Compiling package body COPY_ITEM...
Compilation error on package body COPY_ITEM:
PL/SQL ERROR 801 at line 1, column 1
internal error [phd_get_defn:unqualified external]
PL/SQL ERROR 0 at line 145, column 6
Statement ignored

Compiling package body INVIDITM_MENU...
Compilation error on package body INVIDITM_MENU:
PL/SQL ERROR 801 at line 1, column 1
internal error [phdite:node kind]
PL/SQL ERROR 0 at line 935, column 5
Statement ignored

Steps
Applied patches and see invalids.

Note: The below patch may also be applicable for other products that have similar dependency.

Changes

 

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
Changes
Cause
Solution
References


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