This content has been marked as final. Show 2 replies
I think the only way to do this is to hack the EUL table using SQL*Plus. Fine if you backup and know what you are doing, but otherwise a recipe for disaster.
The table you want to change is EUL5_EXPRESSIONS, so for example, to change the default date mask for all audit date columns (item name begining with Audit) from DD-MON-RRRR to DD-Month-YYYY you can use this SQL:
update eul5_expressions set it_format_mask = 'fmDD-Month-YYYY' where exp_type = 'CO' and exp_data_type = 4 and exp_name like 'Audit%' and it_format_mask = 'DD-MON-RRRR'