Problem after upgrading to APEX 20.2 and using application with Spanish language

User_BB5QX

I have an application developed with APEX and it works fine on APEX 20.1. I upgraded to the latest APEX (20.2) and I started to get the following error:

is_internal_error: true

apex_error_code: APEX.REGION.UNHANDLED_ERROR

ora_sqlcode: -6502

ora_sqlerrm: ORA-06502: PL/SQL: error : la forma de la matriz asociativa no es consistente con los parámetros de la sesión numérico o de valor ORA-06512: en "APEX_200200.WWV_FLOW_THEME", línea 560

component.type: APEX_APPLICATION_PAGES

component.id: 1000000009999

component.name: &NOMBRE_APLICATIVO. - Conectar

error_backtrace:

ORA-06512: en "APEX_200200.WWV_FLOW_THEME", línea 560

ORA-06512: en "APEX_200200.WWV_FLOW_DISP_PAGE_PLUGS", línea 1173

the error only happens when I run the application using spanish language, If I change the application's language to English, the error does not happen. As I mentioned, this only happens on Apex 20.2, using the previous version of APEX (20.1) it works fine even in spanish.

InoL

Sounds like

https://community.oracle.com/tech/developers/discussion/4477648/decimal-separator-stop-working

User_BB5QX

Hello. I already applied the last PSE (PATCH_VERSION    : 2020.11.12) and the problem is still happening.

Bozo

Have you installed APEX from apex_20.2.zip (All languages) or apex_20.2.en.zip (English language only)?

I had APEX 19.2 (All languages) then upgraded to APEX 20.2 (English language only) and that caused some NLS problems in my Apps. I removed 20.2 and installed again from All languages zip file, it solved problem.

User_WOO9D

Hey how is everything!

I have the same problem. When I change the language from English to Portuguese. I have the last path of apex 20.2. Has anyone managed to find the solution to this problem?

User_BB5QX

In my case, I opened a SR and after reviewing, the APEX dev team fixed it in a PSE, and after applying everything worked fine. So, apply the last PSE and if it is the same it should solve the problem.