My Oracle Support Banner

Invalid Packages ARP_PS_UTIL and ARP_PROCESS_ADJUSTMENT After Patch Application (Doc ID 2283076.1)

Last updated on JANUARY 24, 2018

Applies to:

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

Symptoms

On : 12.2.4 version, Patch Application Issues

The following seeded packages become invalid after applying <Patch 25516731>
ARP_PS_UTIL
ARP_PROCESS_ADJUSTMENT

Compilations throws Error

Errors for PACKAGE BODY ARP_PROCESS_ADJUSTMENT

PLS-00306: wrong number or types of arguments in call to 'UPDATE_ADJ_RELATED_COLUMNS'
PL/SQL: Statement ignored
PLS-00306: wrong number or types of arguments in call to 'UPDATE_ADJ_RELATED_COLUMNS'
PL/SQL: Statement ignored

Errors for PACKAGE BODY ARP_PS_UTIL

PLS-00306: wrong number or types of arguments in call to 'UPDATE_ADJ_RELATED_COLUMNS'
PL/SQL: Statement ignored
PLS-00323: subprogram or cursor 'UPDATE_ADJ_RELATED_COLUMNS' is declared in a package specification
PLS-00323: subprogram or cursor 'UPDATE_ADJ_RELATED_COLUMNS' is declared in a package specification


Automatic Receipts Creation Program (API) ends with below error in Automatic Receipts Execution Report when these two packages are invalid :

Error: APP-00001: Unable to find message: AUTORECERR 1 Application failure. You need to nullify the SELECTED FOR RECEIPT BATCH ID on the invoice when the invoice is fixed. Then apply the invoice manually to the receipt with receipt id: 2746, created by automatic receipts for that invoice APP-00001: Unable to find message: AUTORECERR 2 APPLY : ORA-06508: PL/SQL:could not find program unit being called.

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
References


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