1 Reply Latest reply on Sep 14, 2020 8:57 AM by Unplumbed_Apex

    Information/Application Info in apex_activity_log table

    4190917

      Hi Members,

       

      I am trying to build a report of 'Top Page Views by Country and language'. In Earlier Versions, we were retrieving Country Code from Application Info column in apex_activity_log table. Do we have something similar to this in present version where we can get country code. I checked APEX_WORKSPACE_ACTIVITY_LOG table but there is no data in Application Info Column.

       

      Thanks

      Harika

        • 1. Re: Information/Application Info in apex_activity_log table
          fac586

          4190917 wrote:

          Please update your forum profile with a recognisable username instead of "4190917".

           

          Help us to help you. Whenever you ask a question, include the information detailed in these guidelines so we can suggest the most effective solution for your environment and application.

          I am trying to build a report of 'Top Page Views by Country and language'. In Earlier Versions, we were retrieving Country Code from Application Info column in apex_activity_log table. Do we have something similar to this in present version where we can get country code. I checked APEX_WORKSPACE_ACTIVITY_LOG table but there is no data in Application Info Column.

          Interesting. For some reason I haven't come across this before. On describing APEX_WORKSPACE_ACTIVITY_LOG in APEX 20.1 we see:

           

           

          TableColumnData TypeLengthPrecisionScalePrimary KeyNullableDefaultComment
          APEX_WORKSPACE_ACTIVITY_LOGWORKSPACEVARCHAR2255-----A work area mapped to one or more database schemas
          WORKSPACE_DISPLAY_NAMEVARCHAR24000---nullable-Display name for the workspace
          APEX_USERVARCHAR2255---nullable-Name of the end user of the application
          APPLICATION_IDNUMBER22---nullable-Application Primary Key, Unique over all workspaces
          APPLICATION_NAMEVARCHAR2255---nullable-Identifies the application
          APPLICATION_SCHEMA_OWNERVARCHAR2128---nullable-Parsing Schema of the Application
          PAGE_IDNUMBER22---nullable-ID of the application page
          PAGE_NAMEVARCHAR2255---nullable-Name of the application page
          VIEW_DATEDATE7---nullable-Date of page view with precision to the second (indexed)
          THINK_TIMENUMBER22---nullable-Always NULL - see APEX 5.2 Release Notes, Changed Behavior
          SECONDS_AGONUMBER22---nullable--
          LOG_CONTEXTVARCHAR2255---nullable-Context of Page View
          ELAPSED_TIMENUMBER22---nullable-Elapsed time to generate page source
          ROWS_QUERIEDNUMBER22---nullable-Number of rows fetched by the APEX reporting engine
          IP_ADDRESSVARCHAR24000---nullable-IP Address for this page view
          AGENTVARCHAR24000---nullable-HTTP User Agent for this page view
          APEX_SESSION_IDNUMBER22---nullable-APEX Session ID for this page view
          APPLICATION_TENANT_IDVARCHAR232---nullable-Application Tenant ID for this page view
          ERROR_MESSAGEVARCHAR24000---nullable-Error message raised for this page view
          ERROR_ON_COMPONENT_TYPEVARCHAR2255---nullable-The component type that caused an error to be raised
          ERROR_ON_COMPONENT_NAMEVARCHAR2255---nullable-The component name which caused the error to be raised
          PAGE_VIEW_MODEVARCHAR215---nullable-The page view mode, typically Static or Dynamic
          APPLICATION_INFOVARCHAR20---nullable-Information provided by the application to provide additional application context
          INTERACTIVE_REPORT_IDNUMBER22---nullable-Identifies the Interactive Report ID foreign key to the APEX_APPLICATION_PAGE_IR view
          IR_SAVED_REPORT_IDNUMBER22---nullable-Identifies the Saved Interactive Report ID foreign key to the APEX_APPLICATION_PAGE_IR_RPT view
          IR_SEARCHVARCHAR24000---nullable-The search text entered from Interactive Report search bar
          WS_APPLICATION_IDNUMBER22---nullable-Websheet application primary key, unique over all workspaces
          WS_PAGE_IDNUMBER22---nullable-ID of the Websheet application page
          WS_DATAGRID_IDNUMBER22---nullable-ID of the Websheet application Data Grid
          CONTENT_LENGTHNUMBER22---nullable-The size of the web page served.
          REGIONS_FROM_CACHENUMBER22---nullable-Count of regions on this page that are rendered from cache
          WORKSPACE_IDNUMBER22---nullable-Primary Key of the Workspace
          PAGE_VIEW_TYPEVARCHAR223---nullable-The type of page view (Rendering, Processing, Ajax, Logout, Authentication callback, Other)
          REQUEST_VALUEVARCHAR24000---nullable-The value of the request parameter for this page view
          DEBUG_PAGE_VIEW_IDNUMBER22---nullable-The ID for debug messages stored for this page view
          VIEW_TIMESTAMPTIMESTAMP(6) WITH TIME ZONE13-6-nullable-The timestamp with time zone of the page view (not indexed)
          ECIDVARCHAR264---nullable-The web server's Execution Context ID of the page view

           

           

          There are two things of note there.

           

          Firstly, the APPLICATION_INFO column is described as containing Information provided by the application to provide additional application context, which suggests that any information that you were previously extracting from there was being generated by your application(s). How this was done I have no idea.

           

          Secondly, the column has zero length, causing a potential issue for those recording long term activity data. This is confirmed by checking the view definition, which shows the column value being returned as NULL. Investigation shows that the view was changed sometime between APEX 5.1—where the column is defined as VARCHAR2(4000)—and APEX 19.x.

           

          The APEX_ACTIVITY_LOG.APPLICATION_INFO column is undocumented and is also now zero length.

           

          This would indicate that the APPLICATION_INFO columns in the activity logs have been desupported and you will have to find an alternative means of logging and reporting the required information.