My Oracle Support Banner

Package BISM_CALC_FILTER is Invalid After Installing the BI Beans or D4O Catalog into a RDBMS (Doc ID 737101.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle OLAP - Version and later
Oracle BI Beans - Version and later
Information in this document applies to any platform.


When trying to install the BI Beans Catalog into an RDBMS version the following error comes up at the end of the Installation:

<DIRECTORY>JDeveloper\bibeans\bin>bi_installcatalog <SCHEMA NAME> <PASSWORD> -h <SERVER NAME> -p o 1521 -sid <ORACLE_SID> -j thin
This procedure will upgrade your BI Beans Catalog schema.  All existing catalog
objects will be lost.  Use the Import/Export utilities if you would like to pres
erve your data. Press CTRL-C to abort.
Press any key to continue . . .
bi_installcatalog: BI Beans Release (

Persistence installation

Connection information:

User / Schema: <SCHEMA NAME>
Password     : <PASSWORD>
Host name    : xxxx
Port number  : 1521
SID          : <ORACLE_SID>
Tablespace information:
System     :
Index      :
Attributes :
Clob       :

+++++     install/update D  D  L  (using
+++++     install/update (using biberrcs.pls)
+++++     install/update (using bibcnsts.pls)
+++++     install/update (using bibutils.pls and bibutilb.pls)
+++++     install/update (using bibacls.pls and bibaclb.pls)
+++++     install/update (using bibcores.pls and bibcoreb.pls)
+++++     install/update Associate (using bibascts.pls and bibasctb.pls)
+++++     install/update S e e d   D a t a (using bibpplt.sql)
+++++     install/update (bibexps.pls, bibexpb.pls, bibexpws.pls, bibexpwb.pls)
+++++     install/update Calcfilter (using bibcalcflts.pls and bibcalcfltb.pls)
+++++     install/update SYSTEM folder and PUBLIC group (using bibsys.sql)
+++++     Validating all installed packages
Package BISM_CALC_FILTER is invalid after installation!
+++++     install build version number:
+++++     D O N E

The error s shown here when installing the BI Beans Catalog. However, the same error can also come up when trying to install a D4O Catalog.





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.