The motion, first in the current Lok Sabha, was moved by Trinamool Congress Parliamentary Party leader Sudip Bandopadhyay and was supported by BJD.
However, it lacked the support of the required 50 members as only TMC's 18 members and BJD's three members supported.
Moving the motion, Bandopadhyay said, "This House expresses want of confidence in the Council of Ministers over its decision to allow 51% FDI in multi-brand retail as it is going to harm millions of small businesses."
The Speaker asked all those supporting the motion to stand up.
Amidst chants of "shame shame" from Congress benches, TMC members stood up and there was a verbal clash too.
On seeing the lack of adequate support, the Speaker said, "The motion does not have the leave of the House."