Patch Application Error: Unable To Compile ARP_TRX_DEFAULTS_3 Package Body After Applying Patch 6490727 (Doc ID 554139.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Order Management - Version 11.5.10.0 to 11.5.10.0 [Release 11.5.10]
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 16-Jan-2014 ***
Oracle Receivables - Version: 11.5.10This problem can occur on any platform.

Symptoms

You are attempting to apply <Patch 6359273> OM Cumulative Patch, which has a pre-requisite <Patch 6490727> SALES ORDER AUTH AMOUNT.

While applying the pre-requisite, you get the error and error on applying package body "ARP_TRX_DEFAULTS_3". To investigate you do the following:

Errors for PACKAGE BODY ARP_TRX_DEFAULTS_3:

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

92/11 PLS-00323: subprogram or cursor 'GET_BANK_DEFAULTS' is declared
in a package specification and must be defined in the package
body

119/11 PLS-00323: subprogram or cursor 'GET_PAY_METHOD_AND_BANK_DEFLTS'
is declared in a package specification and must be defined in
the package body



The following file versions are not having any problem:
ARTUDF3S.pls 115.6
ARTUDF3B.pls 115.21

Package body compilation is failing if the package spec and package body are the following:
ARTUDF3S.pls 115.6
ARTUDF3B.pls 115.22.15104.2

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