Upgrading RA BANNER to 4.1.1 and above results in ORA-00942 error when trying to run any Job. Below is an snippet of the error.
Error message:
java.rmi.RemoteException: ORA-00942: table or view does not exist
; nested exception is:
java.lang.RuntimeException
Release : 9.4
Component : APPLICATIONS MANAGER
RA Banner 4.1.1 and above requires 4 additional grants that are not listed in the documentation section "Issuing Grants to Create the BANWORX Banner User":
grant SELECT on GENERAL.GJRJBMO to banworx;
grant SELECT on GENERAL.GJRJLIS to banworx;
grant SELECT on GENERAL.GTVPDFT to banworx;
grant SELECT on GENERAL.GJRLCPR to banworx;