R12: Compiling Package JG_ZZ_AR_AUTO_INVOICE Completes with Error - Table or View Does Not Exist (Doc ID 1587022.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Latin American Localization - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Attempting to manually compile JG_ZZ_AUTO_INVOICE and receive the following error:

Warning: Package altered with compilation errors.

SQL> show errors
No errors.

SQL> Alter package JG_ZZ_AUTO_INVOICE compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors

Errors for PACKAGE BODY JG_ZZ_AUTO_INVOICE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
102/4 PL/SQL: SQL Statement ignored
102/16 PL/SQL: ORA-00942: table or view does not exist
 

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