More Usage Tracking (NQ_ACCT) info for DashboardPrompt and ValuePrompt

Eduard Paraschiv - Oracle

Description

Currently, the standard usage tracking (S_NQ_ACCT) is offering the following info about records (among other details):
"with query_src_cd in ('ValuePrompt','DashboardPrompt')"

It would be very helpfull if we would also get the following additional info for these Prompts:
- SAW_SRC_PATH
- SAW_DASHBOARD
- SAW_DASHBOARD_PG

More specific, in attached printscreen > right hand side, we get info about errors in DashboardPrompt or ValuePrompt (QUERY_SRC_CD column).
However SAW_SRC_PATH, SAW_DASHBOARD, SAW_DASHBOARD_PG are not giving any info.
 

Use Case and Business Need

Knowing the src_path, dashboard or dashboard page where the error occurs (especially for DashboardPrompts) can save a lot of time in troubleshooting such errors.

Original Idea Number: a9083efd63

Marcelo Finkielsztein

cann be useful data when triaging errors