Patch Error: Invalid Objects - ORA-00904: "INCLUDE_IN_ACCUMULATION": invalid identifier (Doc ID 737508.1)

Last updated on JULY 24, 2017

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 17-May-2013

Symptoms

After applying some patches the following objects are invalid, and these are the errors:


ARP_APP_PKG PACKAGE BODY
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00984: column not allowed here
PLS-00302: component 'INCLUDE_IN_ACCUMULATION' must be declared


ARP_PROCESS_APPLICATION PACKAGE BODY
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "INCLUDE_IN_ACCUMULATION": invalid identifier
PL/SQL: Statement ignored
PLS-00302: component 'INCLUDE_IN_ACCUMULATION' must be declared
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "INCLUDE_IN_ACCUMULATION": invalid identifier

ARP_PS_UTIL PACKAGE BODY
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "RA"."INCLUDE_IN_ACCUMULATION": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "RA"."INCLUDE_IN_ACCUMULATION": invalid identifier
 


The following are some of the patches that have invalidated these objects with the above errors. However, these might not be the only ones:

<Patch 7317995>
<Patch 7310278>
<Patch 7184125 >

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