My Oracle Support Banner

ORA-04061: Existing State Of Package Body "APPS.MIRS_BSS_ERP_INTERFACES" Has Been Invalidated (Doc ID 2921750.1)

Last updated on JUNE 04, 2024

Applies to:

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


On : version, OSB Build

ORA-04061: existing state of package body "APPS.MIRS_BSS_ERP_INTERFACES" has been invalidated

Define a DB adapter to call a database procedure , usually Oracle plsql procedure , after the procedure is being compiled on run time, OSB gets ORA-04061

The adapter, JDBC connection , is not familiar with the new instance of the procedure/function .
After DS reset, works as expected.

Also in test, when compiling a procedure, and in order to test it, we need to reset the DS.
Is there a DS attribute the define to reconnect the new instance of the procedure without raising an error or doing a reset?


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.