Finding failed or stuck profile transaction

Content

One of our user added a competency on June 2020 month and in his skills and qualification page still showing as transaction is submitting for the approval. We searched in the transaction console for June but due to large number of transactions it is really difficult to search.  ( user can not remember the date submitted this transaction ) And person number also not supported. We used profile as process name and searched. Is there a way to get the transaction Id from the backend query? Else is there any diagnostic to run related to the profile? Basically we need