I am trying to view debug messages but the Utilities > Debug Output is not sufficient to locate the production error.
I am trying to locate the view identifier that contains "reference# 29,739" in MESSAGE for a specific user for a specific date/time (24-OCT-2017.
Can some provide me with the Application views / tables for the DEBUG so I can create my own select off the views/tables?
Table Column Data Type Length Precision Scale Primary Key Nullable Default Comment APEX_DEBUG_MESSAGES ID NUMBER 22 - - - - Unique ID of the message PAGE_VIEW_ID NUMBER 22 - - - - Page View Identifier, which is a unique sequence generated for each page view recorded with debugging MESSAGE_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE 13 - 6 - - Timestamp in GMT that message was saved ELAPSED_TIME NUMBER 22 - - - - Elapsed time in seconds from the beginning of the page submission or page view EXECUTION_TIME NUMBER 22 - - - - Time elapsed between the current and the next debug message MESSAGE VARCHAR2 4000 - - - - Debug message APPLICATION_ID NUMBER 22 - - - - Application Identifier, unique over all workspaces PAGE_ID NUMBER 22 - - - - Page Identifier within the specified application SESSION_ID NUMBER 22 - - - - APEX Session Identifier APEX_USER VARCHAR2 255 - - - - Username of the user authenticated to the APEX application MESSAGE_LEVEL NUMBER 22 - - - - Level of debug message, ranging from 1 to 7 WORKSPACE_ID NUMBER 22 - - - - Application Express Workspace Identifier, unique over all workspaces CALL_STACK VARCHAR2 4000 - - - - PL/SQL call stack where the message was written
Doesn't seem to be included in the documented views included in the APEX_DICTIONARY view.
Thank you fac586 for the view description. I was able to resolve the issue in matter of minuetes after viewing the debug details.
It should be included in the Utilities > Application Express Views