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!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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