Query to fetch "Issue Description" and "Resolution" for failed transactions.

We had a requirement to display issue description and resolution for failed transaction.

When we use table hrc_console_fault_details_vl hcfdv(for description and resolution) joined with fnd_console_issues fci returing duplicates as there are more than one record in hcfdv for each issue type code in fci.

We are unable to find the fault_details_id column in any of the table which is a primary key for hrc_console_fault_details_vl.

If anybody has encountered the same issue please provide us the solution.

Thank You.