5 Replies Latest reply: Mar 20, 2013 6:01 AM by VC RSS

    Application Express 4.0.2.00.07 apex_util.set_security_group_id exception

    944276
      Hi,
      I am trying to trigger apex_util.edit_user procedure.
      But first I need set security group id. I queried SELECT provisioning_company_id FROM APEX_040000.wwv_flow_companies where short_name='MIS' and tried apex_util.set_security_group_id (3587726189450463).
      But error is occued:

      Error report:
      ORA-20001: Security Group ID (your workspace identity) is invalid.
      ORA-06512: at "APEX_040000.HTMLDB_UTIL", line 3175
      ORA-06512: at line 2

      And also select * from apex_workspaces returned empty list... apex_util.find_security_group_id (p_workspace => 'MIS') return 0
        • 1. Re: Application Express 4.0.2.00.07 apex_util.set_security_group_id exception
          VC
          user13830503 wrote:
          Hi,
          I am trying to trigger apex_util.edit_user procedure.
          But first I need set security group id. I queried SELECT provisioning_company_id FROM APEX_040000.wwv_flow_companies where short_name='MIS' and tried apex_util.set_security_group_id (3587726189450463).
          But error is occued:
          You should use:
          l_workspace_id := apex_util.find_security_group_id (p_workspace => 'MIS');
              apex_util.set_security_group_id (p_security_group_id => l_workspace_id);
          See http://docs.oracle.com/cd/E17556_01/doc/apirefs.40/e15519/apex_util.htm#AEAPI512
          Error report:
          ORA-20001: Security Group ID (your workspace identity) is invalid.
          ORA-06512: at "APEX_040000.HTMLDB_UTIL", line 3175
          ORA-06512: at line 2

          And also select * from apex_workspaces returned empty list... apex_util.find_security_group_id (p_workspace => 'MIS') return 0
          Debug the apex_workspaces view to find out why its not showing up your workspace

          I guess it will be something to do with the schema you are trying to access from!
          • 2. Re: Application Express 4.0.2.00.07 apex_util.set_security_group_id exception
            944276
            You should use:
            l_workspace_id := apex_util.find_security_group_id (p_workspace => 'MIS');
            apex_util.set_security_group_id (p_security_group_id => l_workspace_id);

            I used the same. It does not worked!
            • 3. Re: Application Express 4.0.2.00.07 apex_util.set_security_group_id exception
              VC
              user13830503 wrote:
              You should use:
              l_workspace_id := apex_util.find_security_group_id (p_workspace => 'MIS');
              apex_util.set_security_group_id (p_security_group_id => l_workspace_id);

              I used the same. It does not worked!
              Debug as mentioned above

              But anyway I am not sure whether you need to set the security group id to use the edit_user
              See http://docs.oracle.com/cd/E17556_01/doc/apirefs.40/e15519/apex_util.htm#AEAPI117
              • 4. Re: Application Express 4.0.2.00.07 apex_util.set_security_group_id exception
                944276
                If i not set security group this error occued:
                Error report:
                ORA-20001: Unauthorized access (security group package variable not set).
                ORA-06512: at "APEX_040000.WWV_FLOW_FND_USER_API", line 22
                ORA-06512: at "APEX_040000.WWV_FLOW_FND_USER_API", line 1625
                ORA-06512: at "APEX_040000.HTMLDB_UTIL", line 1435
                ORA-06512: at line 3
                • 5. Re: Application Express 4.0.2.00.07 apex_util.set_security_group_id exception
                  VC
                  OK, so what database schema(s) are assigned to MIS workspace?

                  And from what database schema you are running the actual code?