IBY_EXT_BANKACCT_PUB IBY_40000 ORA-04068 ORA-04065: not executed, altered or dropped stored procedure (Doc ID 1900783.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Payments - Version 11.5.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to process direct debit through receipt batch, all the failed invoices in table ra_customer_trx_all have the following error.

ERROR
-----------------------
IBY_40000: SQLException occurred: ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "APPS.IBY_EXT_BANKACCT_PUB
ORA-06508: PL/SQL: could not find program unit being called:"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login with AR Receipt Workbench
2. Navigate to Reciepts
3. Process receipt


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