Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding FOEX grid combo field to APEX page gives ora-20987

529017May 17 2018

I have a stock standard APEX app. I am trying to use the FOEX grid combo on a standard apex page. If I create a page from scratch I can get it to work. When I try to add it to an existing page I receive ORA-20001: Error creating application item id="" ORA-20987: APEX - An API call has been prohibited. Contact your administrator.

  • error_backtrace:

    ORA-06512: at "APEX_050100.WWV_FLOW_API", line 5940
    ORA-06512: at "FOEX_030100.FX_P_UTILS", line 3810
    ORA-06512: at "FOEX_030100.FX_P_UTILS", line 436
    ORA-06512: at "FOEX_030100.FX_P_UTILS", line 3041
    ORA-06512: at "FOEX_030100.FX_P_FORM", line 5502
    ORA-06512: at line 4
    ORA-06512: at "SYS.DBMS_SQL", line 1721
    ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1880
    ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1895
    ORA-06512: at "APEX_050100.WWV_FLOW_API", line 5940
    ORA-06512: at "FOEX_030100.FX_P_UTILS", line 3810
    ORA-06512: at "FOEX_030100.FX_P_UTILS", line 436
    ORA-06512: at "FOEX_030100.FX_P_UTILS", line 3041
    ORA-06512: at "FOEX_030100.FX_P_FORM", line 5502
    ORA-06512: at line 4
    ORA-06512: at "SYS.DBMS_SQL", line 1721
    ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1880
    ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 936
    ORA-06512: at "APEX_050100.WWV_FLOW_PLUGIN", line 1265

  • error_statement:

    begin declare

    begin
    wwv_flow_plugin_api.g_item_render_result := fx_p_form.textfield_render (p_item => wwv_flow_plugin_api.g_item,p_plugin => wwv_flow_plugin_api.g_plugin,p_value => :p_value,p_is_readonly => (:p_is_readonly='Y'),p_is_printer_friendly => (:p_is_printer_friendly='Y') );end;
    end;

  • I am at a complete loss why this happens. I compared templates etc, all the same. Any suggestions would be appreciated.
    I can't reproduce this in the demo ground unfortunately.

This post has been answered by FOEX GmbH on May 17 2018
Jump to Answer
Comments
Post Details
Added on May 17 2018
2 comments
425 views