[BIP 11g] BI Publisher asking for bind variables on changing Dataset SQL

Issue description/Scenario: You are editing a working BIP 11g report dataset to change/add a new column and BIP is prompting you to enter values for the existing parameter and returns error when you give default values. 

For example imagine the following query in a dataset

SELECT CL.CLASS_ID
, STUD.STUDENT_ID, STUD.TOTAL_MARKS
FROM CLASS CL,
STUDENT STUD
WHERE STUD.CLASS_ID = .CLASS_ID

Now imagine you have a change to the TOTAL_MARKS column this has been moved to another column say for example TOT_MARK and you are making the change to the query as below,

SELECT CL.CLASS_ID
, STUD.STUDENT_ID, STUD.TOT_MARKS
FROM CLASS CL,
STUDENT STUD
WHERE STUD.CLASS_ID = .CLASS_ID

You could notice that I have by mistake replaced the TOT_MARK column wrongly with TOT_MARKS. Now when this kind of a column is mapped which doesn't exist in the datasource, BIP will ask you to enter default value for all parameters already present in report.

Solution: Once you correctly change the column name from TOT_MARKS to TOT_MARK, then this issue would be resolved.