Could you please try setting the SQL Identifier character to ""(quotes) for the Oracle connection and see if it helps.
Hi Puneeth & Ninju,
Thank you for the suggestion. This option works and data is inserted into the table but all the column names are in lowercase, can we make all of them in uppercase?
There is no such option inside BDM to make all the columns in Uppercase.
You can use the custom query and use the UPPER(CustomerName) AS UppercaseCustomerName