My Oracle Support Banner

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 DECEMBER 03, 2019

Applies to:

Oracle Receivables - Version 12.0.4 and later
Information in this document applies to any platform.

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

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


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