Confirm Patch - ORA-20001: Unable to find fr translation of application

[rnijs]

Hi

Latest version has been installed.

When confirming the patch, we get following error: ORA-20001: Unable to find fr translation of application
We have some components into this patch, but even with the most simple object, we get this message. Can you please guide us in this error?

Thanks in advance for your help.

APEX version 22.02.05

Full Stack:
is_internal_error: false
ora_sqlcode: -20001
ora_sqlerrm: ORA-20001: Unable to find fr translation of application 251000 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at "APEX_220200.WWV_FLOW_LANG", line 2573 ORA-06512: at "APEX_220200.HTMLDB_LANG", line 219 ORA-06512: at "DOME.PKG_UTILS", line 125 ORA-06512: at "DOME.PKG_UTILS", line 125 ORA-06512: at "DOME.PKG_PATCHES", line 38 ORA-06512: at "DOME.PKG_PATCHES", line 38 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 430 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_LOCAL", line 3053 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2642 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2678 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 1230 ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 3163
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 5293378029293863623
component.name: Confirm patch
error_backtrace:
ORA-06512: at "APEX_220200.WWV_FLOW_LANG", line 2573
ORA-06512: at "APEX_220200.HTMLDB_LANG", line 219
ORA-06512: at "DOME.PKG_UTILS", line 125
ORA-06512: at "DOME.PKG_UTILS", line 125
ORA-06512: at "DOME.PKG_PATCHES", line 38
ORA-06512: at "DOME.PKG_PATCHES", line 38
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837
ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614
ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126
ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654
ORA-06512: at "APEX_220200.WWV_FLOW_LANG", line 2573
ORA-06512: at "APEX_220200.HTMLDB_LANG", line 219
ORA-06512: at "DOME.PKG_UTILS", line 125
ORA-06512: at "DOME.PKG_UTILS", line 125
ORA-06512: at "DOME.PKG_PATCHES", line 38
ORA-06512: at "DOME.PKG_PATCHES", line 38
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837
ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 430
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_LOCAL", line 3053
ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2642
ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2678
ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 34
ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 1230
ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 3163
ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS", line 170
error_statement:
begin PKG_PATCHES.p_confirm_patch(
p_patch_id => :P410_PATCH_ID,
p_user_confirmed_id => :APP_LOGGED_USER_ID
);
end;

[zorantica]

Hi!

Can You check if the translated application for FR language exists?
When You add a new translation language for Your application and do not publish it... the translated application is not created and maybe that's the reason why You get an error "Unable to find fr translation of application 251000".

[rnijs]

Hi,

The language fr and nl are already long time available in this app and has been seed & published several times already by the apex designer.

Regards,
R.