Javelin: Workflow Oraclebulkcopy - ORA-01031: insufficient privileges

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While executing javelin workflow, i am getting the below error:

Error executing Write Data to Oracle Table: ORA-00604: error occurred at recursive SQL level 1

ORA-01031: insufficient privileges

Does anyone know what grants/privileges needed for oraclebulkcopy  in target server?

Environment

All supported Javelin releases.

Cause

Permissions issue.

Resolution

 Bulk Copy some additional privileges need to be given, please review this link:

https://stackoverflow.com/questions/21530569/ora-01031-insufficient-privileges-when-bulk-loading-data-from-one-schema-to-ano

Giving full permissions should resolve this issue.