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

How to join Transaction ID with Assignment Identifier

in Reporting and Analytics for HCM 8 comments

Summary:

We are trying to join "Compensation - Individual Compensation Real Time" with "Human Capital Management - Approval Notification Archive Real Time". This is so that we can report on the compensation data alongside the comments that were included in the approval workflow for these approved transactions.

We have tried joining the Transaction ID in Compensation subject area with Assignment Identifier from another analysis as per other discussions in Customer Connect however we get an error message. Is anyone able to advise how to correct our SQL?

Thank you.

Content (please ensure you mask any confidential information):

SQL attached.

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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