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:
Table Column Data Type Length Precision Scale Primary Key Nullable Default Comment APEX_WORKSPACE_ACTIVITY_LOG WORKSPACE VARCHAR2 255 - - - - - A work area mapped to one or more database schemas WORKSPACE_DISPLAY_NAME VARCHAR2 4000 - - - - Display name for the workspace APEX_USER VARCHAR2 255 - - - - Name of the end user of the application APPLICATION_ID NUMBER 22 - - - - Application Primary Key, Unique over all workspaces APPLICATION_NAME VARCHAR2 255 - - - - Identifies the application APPLICATION_SCHEMA_OWNER VARCHAR2 128 - - - - Parsing Schema of the Application PAGE_ID NUMBER 22 - - - - ID of the application page PAGE_NAME VARCHAR2 255 - - - - Name of the application page VIEW_DATE DATE 7 - - - - Date of page view with precision to the second (indexed) THINK_TIME NUMBER 22 - - - - Always NULL - see APEX 5.2 Release Notes, Changed Behavior SECONDS_AGO NUMBER 22 - - - - - LOG_CONTEXT VARCHAR2 255 - - - - Context of Page View ELAPSED_TIME NUMBER 22 - - - - Elapsed time to generate page source ROWS_QUERIED NUMBER 22 - - - - Number of rows fetched by the APEX reporting engine IP_ADDRESS VARCHAR2 4000 - - - - IP Address for this page view AGENT VARCHAR2 4000 - - - - HTTP User Agent for this page view APEX_SESSION_ID NUMBER 22 - - - - APEX Session ID for this page view APPLICATION_TENANT_ID VARCHAR2 32 - - - - Application Tenant ID for this page view ERROR_MESSAGE VARCHAR2 4000 - - - - Error message raised for this page view ERROR_ON_COMPONENT_TYPE VARCHAR2 255 - - - - The component type that caused an error to be raised ERROR_ON_COMPONENT_NAME VARCHAR2 255 - - - - The component name which caused the error to be raised PAGE_VIEW_MODE VARCHAR2 15 - - - - The page view mode, typically Static or Dynamic APPLICATION_INFO VARCHAR2 0 - - - - Information provided by the application to provide additional application context INTERACTIVE_REPORT_ID NUMBER 22 - - - - Identifies the Interactive Report ID foreign key to the APEX_APPLICATION_PAGE_IR view IR_SAVED_REPORT_ID NUMBER 22 - - - - Identifies the Saved Interactive Report ID foreign key to the APEX_APPLICATION_PAGE_IR_RPT view IR_SEARCH VARCHAR2 4000 - - - - The search text entered from Interactive Report search bar WS_APPLICATION_ID NUMBER 22 - - - - Websheet application primary key, unique over all workspaces WS_PAGE_ID NUMBER 22 - - - - ID of the Websheet application page WS_DATAGRID_ID NUMBER 22 - - - - ID of the Websheet application Data Grid CONTENT_LENGTH NUMBER 22 - - - - The size of the web page served. REGIONS_FROM_CACHE NUMBER 22 - - - - Count of regions on this page that are rendered from cache WORKSPACE_ID NUMBER 22 - - - - Primary Key of the Workspace PAGE_VIEW_TYPE VARCHAR2 23 - - - - The type of page view (Rendering, Processing, Ajax, Logout, Authentication callback, Other) REQUEST_VALUE VARCHAR2 4000 - - - - The value of the request parameter for this page view DEBUG_PAGE_VIEW_ID NUMBER 22 - - - - The ID for debug messages stored for this page view VIEW_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE 13 - 6 - - The timestamp with time zone of the page view (not indexed) ECID VARCHAR2 64 - - - - 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.