After changing the AWBATCH Login Object, Jobs are unable to find particular views/tables.

Document ID : KB000090518
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
After changing the AWBATCH Login Object, Jobs are unable to find particular views/tables.
Resolution:
Detailed Description and Symptoms

?Jobs now abort and you receive a similar message in your RMI log:

ErrorMsg: AwE-5001 Database Query Error (<date_time>)
Details: select bankoptionvalue from bankoption where bankoptioncd = 'PDAT'
jdbc:oracle:thin:@sun2:1524:dev:UC4

 

java.sql.SQLException: ORA-00942: table or view does not exist
 
 
Resolution

Update the Login Object and verify that the DBLINK is correct.  

In addition, the following Synonyms must be set up:

create or replace synonym quenbr_pk for quenbr_pk@&&dblink;
create or replace synonym que for que@&&dblink;
create or replace synonym queappl for queappl@&&dblink;
create or replace synonym queapplhist for queapplhist@&&dblink;
create or replace synonym queapplparam for queapplparam@&&dblink;
create or replace synonym bankoption for bankoption@&&dblink;
create or replace synonym appl for appl@&&dblink;
create or replace synonym parameter for parameter@&&dblink;
create or replace synonym applparameter for applparameter@&&dblink;
create or replace synonym acctcycleappl for acctcycleappl@&&dblink;
create or replace synonym queapplacctcycle for queapplacctcycle@&&dblink;
create or replace synonym queapplerror for queapplerror@&&dblink;
Create or replace synonym quetyp for quetyp@&&dblink;
Create or replace synonym extfile for extfile@&&dblink;