Importance of charge self-consistency in first-principles description of strongly correlated systems