Forms INVISDRI.fmb, INVIDITM.fmb and INVIVCSU.fmb were throwing compilation errors related to 'RELATED_ITEMS' package

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Forms INVISDRI.fmb, INVIDITM.fmb and INVIVCSU.fmb were
throwing compilation errors related to 'RELATED_ITEMS' package.

On: 11.5.10.2 version, Install & Upgrade Issues

5739724. When applying this patch, following error is encountered: -
The following Oracle Forms objects did not generate successfully:
au resource QLTTXN.pll
inv forms/US INVIDITM.fmx
inv forms/US INVIVCSU.fmx





Symptoms:

For 11i extended support, we need to apply patch 9466436. Pre-req for this is 5739724. When applying this patch, following error is encountered: -
The following Oracle Forms objects did not generate successfully:
au resource QLTTXN.pll
inv forms/US INVIDITM.fmx
inv forms/US INVIVCSU.fmx

Log files:

adwork002.log
===================


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 302 at line 1, column 15
component 'CHECK_CUST_REFERENCES' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored
------------------------------------
Compiling KEY-DELREC trigger on RELATED_ITEMS data block...
Compilation error on KEY-DELREC trigger on RELATED_ITEMS data block:
PL/SQL ERROR 302 at line 1, column 15
component 'KEY_DELREC' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

-----------------------------------
Generating Oracle Forms files...

Temporarily resetting FORMS60_PATH to:
"/u02/dwcs/dwcsappl/au/11.5.0/resource:/u02/dwcs/dwcsappl/au/11.5.0/forms/US:/u02/dwcs/dwcsappl/au/11.5.0/resource/US"

Generating library "resource/ARXPLCOM.plx" with command:

/u02/dwcs/dwcsora/8.0.6/bin/f60gen module=/u02/dwcs/dwcsappl/au/11.5.0/resource/ARXPLCOM.pll userid=APPS/***** output_file=/u02/dwcs/dwcsappl/au/11.5.0/resource/ARXPLCOM.plx module_type=library batch=yes compile_all=special


ERROR generating library "resource/ARXPLCOM.plx" from input file
/u02/dwcs/dwcsappl/au/11.5.0/resource/ARXPLCOM.pll

Results of library generation:
(from file /u02/dwcs/dwcsappl/au/11.5.0/resource/ARXPLCOM.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on AR_COMMON_INIT_PROFILES:
PL/SQL ERROR 302 at line 117, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 117, column 8
Statement ignored
PL/SQL ERROR 302 at line 120, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 120, column 8
Statement ignored
PL/SQL ERROR 302 at line 123, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 123, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

Solution:



Bug 10263460 - CANNOT COMPILE INVIDITM OR INVIVCSU AFTER APPLYING PATCH 9153710
Apply Patch 10263460

1. Download and review the readme and pre-requisites for Patch.10263460 which will resolve the
compilation issue of the Items forms.

2. Ensure that you have taken a backup of your system before applying
the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

You can use the commands like the following:
$INV_TOP/forms/US/INVISDRI.fmb ver 115.31.115100.4
$INV_TOP/resource/INVISDRI.pld ver 115.25.115100.2

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.
STATUS

Get Oracle Certifications for all Exams
Free Online Exams.com