Patch Application Error: After Applying Patches, ARXTWBAL.pll and ARXCOQIL.pll Become Invalid and Raise Errors: 'PL/SQL ERROR 302' and 'FRM-30312' (Doc ID 1123494.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.0.4 and later
Information in this document applies to any platform.
*** Checked for relevance 29-Oct-2013 ***



Symptoms

After Applying Patches 9081055/ 8846072/ 6164455, the files ARXTWBAL.pll  and ARXCOQIL.pll become INVALID.

On Compiling using ADADMIN, the two files fail and the ADADMIN and ADWORKER show the below errors:


For ARXTWBAL.pll, the errors are:

ARXTWBAL.pll on worker 25
.
.
Compilation errors on ARXTWBAL_BALANCE:
PL/SQL ERROR 302 at line 236, column 50
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 233, column 15
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.



for ARXCOQIL.pll, the errors are:

ARXCOQIL.pll on worker 5

Compilation errors on ARP_ARXCOQIL_TRX_PKG:
PL/SQL ERROR 302 at line 187, column 37
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 186, column 5
Statement ignored
PL/SQL ERROR 302 at line 494, column 23
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 490, column 7
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

Changes

  1. Patches 9081055/ 8846072/ 6164455 are Applied.
  2. The CUSTOM.PLL file has been modified.

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