My Oracle Support Banner

On 12.0.2, After Applying Patch 7149564, ARXRWRCT.pll Will Not Generate Successfully (Doc ID 874706.1)

Last updated on FEBRUARY 14, 2018

Applies to:

Oracle Receivables - Version 12.0.2 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On 12.0.2, when applying <patch 7149564>, ARXRWRCT.pll will not generate.

The following errors are shown in the worker log.

-------------------------------------------------------------------------
Compilation errors on RGW_RECEIPTS_PRIVATE3:
PL/SQL ERROR 201 at line 1208, column 11
identifier 'JAI_AR_CASH_RECEIPTS_S1.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 1208, column 4
SQL Statement ignored
PL/SQL ERROR 201 at line 1226, column 10
identifier 'JAI_AR_CASH_RECEIPTS_ALL' must be declared
PL/SQL ERROR 0 at line 1224, column 5
SQL Statement ignored
PL/SQL ERROR 201 at line 1242, column 12
identifier 'JAI_AR_CASH_RECEIPTS_S1.CURRVAL' must be declared
PL/SQL ERROR 0 at line 1242, column 5
SQL Statement ignored
PL/SQL ERROR 341 at line 1222, column 12
declaration of cursor 'C_AR_CASH_RECEIPTS' is incomplete or malformed
PL/SQL ERROR 0 at line 1250, column 23
Item ignored
PL/SQL ERROR 320 at line 1299, column 33
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 1299, column 3
SQL Statement ignored
PL/SQL ERROR 320 at line 1302, column 10
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 1302, column 3
Statement ignored

There are several JAI and JG invalid objects.

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!


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