R13 20A - What are the common fields to join with Issue Details and Transaction details Subject area
Summary
Need help with OTBI subject areaContent
We are trying to create a transaction failure report for the transactions that are failed on a daily basis due to MSS transactions. We have created the SQL and also created a data model to pull data elements from OTBI subject area
Hiuman Capital Management - Transaction Administration Real Time
We want to pull the issue details and issue comments basically the error message from the transaction
There are 2 folders issue comments and Transaction details what are the common elements between these 2 folder where we can join the transactions data.
Below is my SQL