R13 20A - What are the common fields to join with Issue Details and Transaction details Subject area — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

R13 20A - What are the common fields to join with Issue Details and Transaction details Subject area

edited Apr 6, 2020 5:44PM in Reporting and Analytics for HCM 1 comment

Summary

Need help with OTBI subject area

Content

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 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!