INV Form Compilation Issues After Applying Patch 22263665 for Language RO and ZHS

(Doc ID 2294937.1)

Last updated on AUGUST 09, 2017

Applies to:

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

Symptoms

After applying Patch 22263665:R12.INV.B,  the following Oracle Forms objects did not generate successfully

inv forms/RO INVRSVF1.fmx
inv forms/ZHS INVRSVF1.fmx
inv forms/RO INVISDRI.fmx
inv forms/RO INVIVCSU.fmx
inv forms/RO INVIDITM.fmx
inv forms/ZHS INVISDRI.fmx
inv forms/ZHS INVIVCSU.fmx
inv forms/ZHS INVIDITM.fmx


ERROR
-----------------------
Compilation error for inv forms/ZHS INVRSVF1.fmx

==================

Compiling WHEN-VALIDATE-ITEM trigger on RESERVATION_UOM_CODE item in RESERV_LINES_BLK data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on RESERVATION_QUANTITY item in RESERV_LINES_BLK data block...
Compilation error on WHEN-VALIDATE-ITEM trigger on RESERVATION_QUANTITY item in RESERV_LINES_BLK data block:
PL/SQL ERROR 306 at line 214, column 10
wrong number or types of arguments in call to 'AVAIL_DEMAND_TO_RESERVE'
PL/SQL ERROR 0 at line 214, column 10
Statement ignored


Compilation error for ZHS/INVIDITM.fmx (adwork016.log )
=====================
Compiling WHEN-VALIDATE-ITEM trigger on END_DATE item in RELATED_ITEMS_PLN_INFO data block...
No compilation errors.

Compiling WHEN-CHECKBOX-CHANGED trigger on ALL_CUSTOMERS_FLAG item in RELATED_ITEMS_PLN_INFO data block...
Compilation error on WHEN-CHECKBOX-CHANGED trigger on ALL_CUSTOMERS_FLAG item in RELATED_ITEMS_PLN_INFO data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.CHECK_CUST_REFERENCES' must be declared
PL/SQL ERROR 0 at line 1, column

Compiling WHEN-VALIDATE-RECORD trigger on RELATED_ITEMS data block...
Compilation error on WHEN-VALIDATE-RECORD trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.WHEN_VALID_REC' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-NEW-ITEM-INSTANCE trigger on RELATED_ITEMS data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on RELATED_ITEMS data block...
No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on RELATED_ITEMS data block...
Compilation error on WHEN-NEW-RECORD-INSTANCE trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.SET_UP_FIELDS' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on RELATED_ITEMS data block...
Compilation error on WHEN-NEW-BLOCK-INSTANCE trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.WHEN_NEW_BLK' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compilation Error for Form INVISDRI
=====================

Compiling ON-LOCK trigger on RELATED_ITEMS data block...
Compilation error on ON-LOCK trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.ON_LOCK' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling POST-QUERY trigger on RELATED_ITEMS data block...
Compilation error on POST-QUERY trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 7, column 1
identifier 'RELATED_ITEMS.SET_UP_FIELDS' must be declared
PL/SQL ERROR 0 at line 7, column 1
Statement ignored

Compiling PRE-QUERY trigger on RELATED_ITEMS data block...
Compilation error on PRE-QUERY trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.PRE_QUERY' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-INSERT trigger on RELATED_ITEMS data block...
Compilation error on PRE-INSERT trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.PRE_INSERT' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-UPDATE trigger on RELATED_ITEMS data block...
Compilation error on PRE-UPDATE trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.PRE_UPDATE' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling QUERY_FIND trigger on RELATED_ITEMS data block...
No compilation errors.

Compiling WHEN-VALIDATE-RECORD trigger on RELATED_ITEMS data block...
Compilation error on WHEN-VALIDATE-RECORD trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.WHEN_VALID_REC' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-NEW-ITEM-INSTANCE trigger on RELATED_ITEMS data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on RELATED_ITEMS data block...
No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on RELATED_ITEMS data block...
Compilation error on WHEN-NEW-RECORD-INSTANCE trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.SET_UP_FIELDS' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on RELATED_ITEMS data block...
Compilation error on WHEN-NEW-BLOCK-INSTANCE trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.WHEN_NEW_BLK' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-CHECKBOX-CHANGED trigger on ALL_CUSTOMERS_FLAG item in RELATED_ITEMS_PLN_INFO data block...
Compilation error on WHEN-CHECKBOX-CHANGED trigger on ALL_CUSTOMERS_FLAG item in RELATED_ITEMS_PLN_INFO data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.CHECK_CUST_REFERENCES' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Errors for Form INVIVCSU
===============

Compiling ON-LOCK trigger on RELATED_ITEMS data block...
Compilation error on ON-LOCK trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.ON_LOCK' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling POST-QUERY trigger on RELATED_ITEMS data block...
Compilation error on POST-QUERY trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 7, column 1
identifier 'RELATED_ITEMS.SET_UP_FIELDS' must be declared
PL/SQL ERROR 0 at line 7, column 1
Statement ignored

Compiling PRE-QUERY trigger on RELATED_ITEMS data block...
Compilation error on PRE-QUERY trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.PRE_QUERY' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-INSERT trigger on RELATED_ITEMS data block...
Compilation error on PRE-INSERT trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.PRE_INSERT' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-UPDATE trigger on RELATED_ITEMS data block...
Compilation error on PRE-UPDATE trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.PRE_UPDATE' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling QUERY_FIND trigger on RELATED_ITEMS data block...
No compilation errors.

Compiling WHEN-VALIDATE-RECORD trigger on RELATED_ITEMS data block...
Compilation error on WHEN-VALIDATE-RECORD trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.WHEN_VALID_REC' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-NEW-ITEM-INSTANCE trigger on RELATED_ITEMS data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on RELATED_ITEMS data block...
No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on RELATED_ITEMS data block...
Compilation error on WHEN-NEW-RECORD-INSTANCE trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.SET_UP_FIELDS' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on RELATED_ITEMS data block...
Compilation error on WHEN-NEW-BLOCK-INSTANCE trigger on RELATED_ITEMS data block:
PL/SQL ERROR 201 at line 1, column 1
identifier 'RELATED_ITEMS.WHEN_NEW_BLK' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Patch 22263665:R12.INV.B
2. Notice the Patch application completed with Form Compilation error



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