Hello
Following this youtube video I successfully enabled the option the allow the user to change the application language on apex 22.1, but I'm finding some inconsistencies.
For example. After changing the application language from English to Spanish, right away the application raise this error
Ajax call returned server error ORA-01843: mes no válido for Year to date.
Checking the home page I've found one item that may be causing this error and fixed, but the error still is being shown. More than that, after modifying the faulty code, now the graph associated with it now is being shown on English, but not on Spanish.
Looking to get a more detailed information about this error, I enabled the apex debug, and got the following information:
POST http://172.28.7.120:8080/ords
REMOTE_USER=APEX_PUBLIC_USER
APEX_LISTENER_VERSION=21.4.1.r0250904
REFERER=http://172.28.7.120:8080/
Error: Ajax call returned server error ORA-01843: mes no válido for Year to date.
- is_internal_error: true
- is_common_runtime_error: false
- apex_error_code: APEX.AJAX_SERVER_ERROR
- ora_sqlcode: -1843
- ora_sqlerrm: ORA-01843: mes no válido
ORA-06512: en "APEX_220100.WWV_FLOW_JET_CHART", línea 2548
ORA-06512: en "APEX_220100.WWV_FLOW_JET_CHART", línea 1705
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC", línea 920
ORA-06512: en "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", línea 1347
ORA-06512: en "SYS.DBMS_SQL", línea 1771
ORA-06512: en "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", línea 1341
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 448
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 693
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 835
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 881
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 1450
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC", línea 911
ORA-06512: en "APEX_220100.WWV_FLOW_JET_CHART", línea 1697
- error_backtrace: ORA-06512: en "APEX_220100.WWV_FLOW_JET_CHART", línea 2548
ORA-06512: en "APEX_220100.WWV_FLOW_JET_CHART", línea 1705
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC", línea 920
ORA-06512: en "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", línea 1347
ORA-06512: en "SYS.DBMS_SQL", línea 1771
ORA-06512: en "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", línea 1341
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 448
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 693
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 835
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 881
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC_LOCAL", línea 1450
ORA-06512: en "APEX_220100.WWV_FLOW_EXEC", línea 911
ORA-06512: en "APEX_220100.WWV_FLOW_JET_CHART", línea 1697
ORA-06512: en "APEX_220100.WWV_FLOW_JET_CHART", línea 3895
Another weird thing that I've noticed was that the language selector once is being used (change language from English to Spanish) is not being shown on the screen anymore.
Thinking that this may be associated to a browser cache issue, set the cache to clear everything after close the browser but the error still is being generated. To be sure I replicated this error on three different browsers (Edge, chrome and Firefox).
Anyone has any idea about where else to check?
Thanks
W