DBA_ADVISOR_FINDING_NAMES provides a list of all finding names registered with the Advisor Framework.
DBA_ADVISOR_FINDING_NAMES
ID
NUMBER
ADVISOR_NAME
VARCHAR2(30)
NOT NULL
FINDING_NAME
VARCHAR2(4000)