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.