My Oracle Support Banner

AutoInvoice Import Fails With Error: APP-AR-11526: ORA-04063: package body "APPS.ARP_PROCESS_RETURNS" has errors (Doc ID 2143556.1)

Last updated on JULY 16, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running Autoinvoice Import Program, the following error occurs:


APP-AR-11526: ORA-04063: package body "APPS.ARP_PROCESS_RETURNS" has errors
select IL.CUSTOMER_TRX_ID ,IL.PREVIOUS_CUSTOMER_TRX_ID ,DECODE(H.INITI
APP-AR-11526: 8594453/ar/lib/raavhi.lpc 705
Error calling raavhi()
Error calling raapic()


Steps to Reproduce:

Responsibility: Receivables Manager
Navigation
: Interfaces > Autoinvoice

  1. Run Auoinvoice Import Program

 

Package body APPS.ARP_PROCESS_RETURNS fails compilation with the following error:

PLS-00302: component 'CUSTOMER_TRX_ID' must be declared
PLS-00382: expression is of wrong type
PL/SQL: ORA-22806: not an object or REF
PL/SQL: SQL Statement ignored
PLS-00302: component 'CUSTOMER_TRX_ID' must be declared
PL/SQL: Statement ignored

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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