My Oracle Support Banner

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

Last updated on MAY 27, 2021

Applies to:

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


When attempting to process direct debit through receipt batch, all the failed invoices in table ra_customer_trx_all have the following 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:"

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


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

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