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

Document ID : KB000129533
Last Modified Date : 14/03/2019
Show Technical Document Details
Issue:
When we try to publish to Target database (Oracle)   a row  with a null value it wont 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 4.6, 4.7
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.