On testing for upgrading from 10.2 to 11.1 (upgradedb), some db procedures were gone and were not recreated successfully. Upon investigation it was beacuse of the date format set to MULTINATIONAL4 instead of US