Patch Application Errors: Invalid AR/HZ Package Body After Applying FIN_PF.G (Doc ID 468879.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
*** Checked for Relevance 30-Dec-2013 ***

Symptoms

After applying FIN_PF.G, the following package bodies are invalid with the following errors:

PACKAGE BODYERROR MESSAGE
ARP_RECON_REP PL/SQL: ORA-00942: table or view does not exist
ARP_ROUNDING PL/SQL: ORA-00942: table or view does not exist
AR_INVOICE_API_PUB PL/SQL: ORA-00942: table or view does not exist
AR_IREC_APPLY_CREDITS PL/SQL: ORA-00904: "CASH_RECEIPT_ID": invalid identifier
AR_IREC_PAYMENTS PL/SQL: ORA-00904: "ORIGINAL_DISCOUNT_AMT": invalid identifier
AR_MC_INFO PL/SQL: ORA-00942: table or view does not exist
AR_REVENUE_ADJUSTMENT_PVT PL/SQL: ORA-00942: table or view does not exist
AR_TRX_BULK_PROCESS_LINES PL/SQL: ORA-00942: table or view does not exist
AR_TRX_GLOBAL_PROCESS_CONT PL/SQL: ORA-00942: table or view does not exist
  PL/SQL: ORA-00904: "OVERRIDE_AUTO_ACCOUNTING_FLAG": invalid identifier
HZ_PURGE ORA-00904: "PARTY_ID": invalid identifier
HZ_PURGE_GEN PLS-00323: subprogram or cursor 'IDENTIFY_CANDIDATES' is declared in a
package
specification and must be defined in the package body



Most of them refers to errors regarding Global Temporary Tables that does not exist, or do not have the columns that they must have.

The following tables do not exist:

AR_GL_RECON_GT
AR_LINE_REV_ADJ_GT
AR_TRX_CONTINGENCIES_GT

The following columns do not exist:

AR_IREC_PAYMENT_LIST_GT .CASH_RECEIPT_ID
AR_IREC_PAYMENT_LIST_GT .ORIGINAL_DISCOUNT_AMT
AR_TRX_LINES_GT .OVERRIDE_AUTO_ACCOUNTING_FLAG
HZ_APPLICATION_TRANS_GT .PARTY_ID
AR_TRX_ERRORS_GT .TRX_CONTINGENCY_ID

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