title: table does not exist error during execution on powercenter workflow
body: <p>During execution of workflow, I am getting below error while inserting the data in the table (TARGET), whereas when I am connecting same database user then I am able to insert the data, but powercenter is throwing the below error.</p>
  
  <p>I have already created the synonym as well as given all the access.</p>
  
  <pre><code>Severity    Timestamp    Node    Thread    Message Code    Message
  
  ERROR    23/05/2015 20:55:59    node01_CSADevelopment    WRITER_1_*_1    WRT_8229    Database errors occurred:
  
  ORA-00604: error occurred at recursive SQL level 1
  
  ORA-00942: table or view does not exist
  
  Database driver error...
  
  Function Name : Prepare DPL
  
  SQL Stmt : INSERT INTO TARGET(ID,NAME)  VALUES ( ?, ?)
  
  Oracle Fatal Error
  
  Database driver error...
  
  Function Name : Execute Multiple
  
  SQL Stmt : INSERT INTO TARGET(ID,NAME)  VALUES ( ?, ?)
  
  Oracle Fatal Error
  </code></pre>
  
  <p>Please assist.</p>