Hello
We are experiencing difficulties with our APEX app using FOEX on the UAT server when deploying from DEV. It seems that the app is not functioning properly. Both the UAT and DEV servers have identical settings for Oracle, APEX, and FOEX since they are cloned virtual machines.
APEX: 22.1.8
FOEX: V22.2.0.4588.01
Oracle XE: 21c express
is_internal_error: true
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
ora_sqlcode: -20001
ora_sqlerrm: ORA-20001: Form Plugin Query Issue: ORA-01722: invalid number ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2491 ORA-06512: at "FOEX_220200.FX_P_FORM_DML", line 3178 ORA-06512: at "FOEX_220200.FX_P_FORM_DML", line 6653 ORA-06512: at "FOEX_220200.FX_P_FORM", line 6202 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2164 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 301 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC", line 357
component.type: APEX_APPLICATION_PAGE_REGIONS
component.id: 9422288929141536
component.name: aac ic form
error_backtrace:
ORA-06512: at "FOEX_220200.FX_P_FORM_DML", line 3178
ORA-06512: at "FOEX_220200.FX_P_FORM_DML", line 6653
ORA-06512: at "FOEX_220200.FX_P_FORM", line 6202
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2164
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2491
ORA-06512: at "FOEX_220200.FX_P_FORM_DML", line 3178
ORA-06512: at "FOEX_220200.FX_P_FORM_DML", line 6653
ORA-06512: at "FOEX_220200.FX_P_FORM", line 6202
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2164
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 301
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC", line 357
ORA-06512: at "APEX_220100.WWV_FLOW_PLUGIN", line 1951
error_statement:
begin declare
begin
wwv_flow_plugin_api.g_region_render_result := fx_p_form.form_plugin_render (p_region => wwv_flow_plugin_api.g_region,p_plugin => wwv_flow_plugin_api.g_plugin,p_is_printer_friendly => (:p_is_printer_friendly='Y') );end;
end;
Upon further investigation using the debug log, we have discovered that the session values are being changed to "***" when entering the FX_P_META_DATA.FOEX_FORM_SESSION_STATE_FIX function on the UAT machine. However, no such values are being changed in the DEV environment.
# UAT
....» Enter: FX_P_META_DATA.FOEX_FORM_SESSION_STATE_FIX
Session State: P202_ID=>***
Session State: COMMIT
Session State: P202_NETID=>***
Session State: COMMIT
Session State: P202_CATEGORY_IC_UI_ID=>***
Session State: COMMIT
...
....« Exit: FX_P_META_DATA.FOEX_FORM_SESSION_STATE_FIX
# DEV
........» Enter: FX_P_META_DATA.FOEX_FORM_SESSION_STATE_FIX
Session State: P202_ID=>15267
Session State: P202_NETID=>msxxxx
Session State: P202_JOURNAL_TITLE=>Materials Today Physics
........« Exit: FX_P_META_DATA.FOEX_FORM_SESSION_STATE_FIX
We would greatly appreciate any assistance or guidance you can provide to help resolve this issue. Thank you.
Regards
Kris