Invalid Object ARP_PROCESS_APPLICATION After Applying Patch 3131225 (Doc ID 280841.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

After applying the <Patch 3131225>, there is an invalid object.  arp_process_application.cm_application

OBJECT_NAME OBJECT_TYPE OWNER
------------------------------ --------------- --------------------
ARP_PROCESS_APPLICATION PACKAGE BODY APPS

Compiled the package body manually, however pakage was compiled with errors.

SQL>
ALTER PACKAGE ARP_PROCESS_APPLICATION COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL>show error
Errors for PACKAGE BODY ARP_PROCESS_APPLICATION:

LINE/COL ERROR
-------- -----------------------------------------------------------------
153/11 PLS-00323: subprogram or cursor 'CM_APPLICATION' is declared in
a package specification and must be defined in the package body

Versions of ARP_PROCESS_APPLICATION are:

TEXT
--------------------------------------------------------------------------------
/* $Header: ARCEAPPS.pls 115.24 2002/05/10 10:16:26 pkm ship $ */
/* $Header: ARCEAPPB.pls 115.63.1158.7 2003/09/04 21:29:27 anukumar ship $ */

 

Changes

 <Patch 3131225> has been applied

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