My Oracle Support Banner

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

Last updated on JANUARY 31, 2018

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.

Symptoms

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

PACKAGE BODY ERROR 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

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
References

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