1 Reply Latest reply on Jan 14, 2016 5:00 PM by kgamble

    Publish to Apex


      When I use right-click, Publish to Apex and fill in the fields required, I get an error for invalid Theme id regardless of which theme I choose.

      When I use the wwv_flow_create_app_from_query package there is no such error unless I use theme id > 22


      How do I get the right click action to work?


      Tried on oracle 12 and oracle 11g, using apex 5 and apex 4.2

      sqldeveloper version :




        • 1. Re: Publish to Apex

          An error was encountered performing the requested operation:


          ORA-20001: Unable to create application. ORA-20001: Invalid theme ID.

          ORA-06512: at "APEX_040200.WWV_FLOW_CREATE_APP_FROM_QUERY", line 356

          ORA-06512: at "APEX_040200.WWV_FLOW_CREATE_APP_FROM_QUERY", line 549

          ORA-06512: at line 3

          ORA-06512: at "APEX_040200.WWV_FLOW_API", line 20000

          ORA-06512: at line 1


          Vendor code 20001