Skip to content

Setting up Data Archiving consistently fails with 'ORA-20105: Assert.IS_PACKAGE: <LU>_ARC_API is non existing package,' regardless of which table is being archived — what's missing?

Answer

This points to the required Data Archive installation steps not having been fully completed — per IFS's own 'Install Data Archive Objects' documentation, setting up Data Archiving requires installing two separate SQL files: a storage file, which needs to be installed in whichever database will actually store the archived data (relevant if you're moving archived data to a separate database), and a package file, which needs to be installed in the same database where the Data Archive object itself was created, run as the Application Owner (appowner) user. A consistent '<LU>_ARC_API is non existing package' error across multiple different tables strongly suggests specifically that the package SQL file was never installed — installing it as described in that documentation section resolves this.

← Browse Developer Studio, deployment, and upgrades questions