ORA-00947: not enough values- when trying to Publish to Target

Products

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

Issue/Introduction

When we try to publish to the Target database (Oracle)   a row with a null value it won't show the column. We are getting - 

Publish Error
ORA-00947: not enough values
 It will upload an image and sql text file created by publishing.  

But not when you try to publish to a target database. 

Environment

TDM Version
Test Data Manager 
Portal

Cause

This error can occur when you are performing an INSERT and the values entered are less in number than the columns that you are inserting into.

Resolution

Make sure the INSERT  Query Insert rows the same number  as that columns that you are inserting into.